PREVIEW / etf_1hour / 2001-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-28.parquet
  size:    13 KB
  rows:    288

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2001-12-28 09:00:00	SPY	ETF	116.29	116.5	116.2	116.36	882400.0
2001-12-28 10:00:00	SPY	ETF	116.35	116.75	116.35	116.57	2280400.0
2001-12-28 11:00:00	SPY	ETF	116.57	116.64	115.95	116.06	1428900.0
2001-12-28 12:00:00	SPY	ETF	116.09	116.44	116.05	116.41	1746900.0
2001-12-28 13:00:00	SPY	ETF	116.37	116.42	116.2	116.37	1002200.0
2001-12-28 14:00:00	SPY	ETF	116.4	116.4	116.08	116.11	626000.0
2001-12-28 15:00:00	SPY	ETF	116.06	116.39	116.0	116.21	1203200.0
2001-12-28 16:00:00	SPY	ETF	116.17	116.23	115.92	116.0	1203800.0
2001-12-28 17:00:00	SPY	ETF	116.0	116.0	116.0	116.0	1700.0
2001-12-28 09:00:00	QQQ	ETF	40.29	40.64	40.26	40.53	6565300.0
2001-12-28 10:00:00	QQQ	ETF	40.46	40.8	40.45	40.56	10133900.0
2001-12-28 11:00:00	QQQ	ETF	40.54	40.62	40.23	40.29	5291400.0
2001-12-28 12:00:00	QQQ	ETF	40.28	40.49	40.25	40.47	2866400.0
2001-12-28 13:00:00	QQQ	ETF	40.47	40.48	40.33	40.45	1849800.0
2001-12-28 14:00:00	QQQ	ETF	40.4	40.45	40.25	40.28	3340800.0
2001-12-28 15:00:00	QQQ	ETF	40.28	40.47	40.25	40.34	6693500.0
2001-12-28 16:00:00	QQQ	ETF	40.34	40.38	40.24	40.34	1228400.0
2001-12-28 17:00:00	QQQ	ETF	40.34	40.35	40.3	40.34	13800.0
2001-12-28 18:00:00	QQQ	ETF	40.3	40.4	40.3	40.35	11100.0
2001-12-28 09:00:00	IWM	ETF	49.15	49.15	49.0	49.125	141600.0
2001-12-28 10:00:00	IWM	ETF	49.2	49.265	49.09	49.09	93600.0
2001-12-28 11:00:00	IWM	ETF	49.09	49.175	49.04	49.06	858400.0
2001-12-28 12:00:00	IWM	ETF	49.03	49.19	49.0	49.15	70200.0
2001-12-28 13:00:00	IWM	ETF	49.19	49.195	49.09	49.165	58600.0
2001-12-28 14:00:00	IWM	ETF	49.175	49.175	49.06	49.06	424000.0
2001-12-28 15:00:00	IWM	ETF	49.05	49.19	49.0	49.05	118000.0
2001-12-28 16:00:00	IWM	ETF	48.985	49.0	48.875	49.0	34200.0
2001-12-28 09:00:00	DIA	ETF	101.7	101.72	101.5	101.62	229900.0
2001-12-28 10:00:00	DIA	ETF	101.62	101.94	101.62	101.84	473500.0
2001-12-28 11:00:00	DIA	ETF	101.8	101.84	101.18	101.33	225100.0
2001-12-28 12:00:00	DIA	ETF	101.29	101.62	101.29	101.6	93400.0
2001-12-28 13:00:00	DIA	ETF	101.61	101.61	101.4	101.55	51400.0
2001-12-28 14:00:00	DIA	ETF	101.5	101.55	101.2	101.25	93300.0
2001-12-28 15:00:00	DIA	ETF	101.2	101.46	101.15	101.36	192600.0
2001-12-28 16:00:00	DIA	ETF	101.35	101.35	101.15	101.16	32600.0

> showing 35 of 288 rows — these rows as CSV

> unlock the full archive -- $79 one-time