PREVIEW / etf_1hour / 2002-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-28.parquet
  size:    13 KB
  rows:    278

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
2002-01-28 09:00:00	SPY	ETF	113.9	114.19	113.85	113.97	1081300.0
2002-01-28 10:00:00	SPY	ETF	113.96	114.08	113.61	113.73	1620900.0
2002-01-28 11:00:00	SPY	ETF	113.69	113.88	113.42	113.42	1135300.0
2002-01-28 12:00:00	SPY	ETF	113.44	113.46	113.06	113.08	1117700.0
2002-01-28 13:00:00	SPY	ETF	113.11	113.28	112.92	112.98	1153100.0
2002-01-28 14:00:00	SPY	ETF	112.98	113.31	112.97	113.1	1177500.0
2002-01-28 15:00:00	SPY	ETF	113.04	113.63	113.04	113.63	1875800.0
2002-01-28 16:00:00	SPY	ETF	113.65	113.9	113.55	113.9	1207700.0
2002-01-28 17:00:00	SPY	ETF	113.85	113.9	113.85	113.9	3000.0
2002-01-28 18:00:00	SPY	ETF	113.95	113.95	113.95	113.95	200.0
2002-01-28 09:00:00	QQQ	ETF	39.15	39.39	39.1	39.25	7967600.0
2002-01-28 10:00:00	QQQ	ETF	39.23	39.34	38.98	39.1	9093300.0
2002-01-28 11:00:00	QQQ	ETF	39.11	39.24	38.78	38.79	4950300.0
2002-01-28 12:00:00	QQQ	ETF	38.79	38.81	38.5	38.5	6369500.0
2002-01-28 13:00:00	QQQ	ETF	38.51	38.68	38.42	38.45	4237200.0
2002-01-28 14:00:00	QQQ	ETF	38.46	38.78	38.45	38.59	4535700.0
2002-01-28 15:00:00	QQQ	ETF	38.6	38.97	38.56	38.95	8316300.0
2002-01-28 16:00:00	QQQ	ETF	38.95	39.16	38.86	39.09	1395900.0
2002-01-28 17:00:00	QQQ	ETF	39.11	39.21	39.08	39.21	463700.0
2002-01-28 18:00:00	QQQ	ETF	39.17	39.21	39.15	39.2	36900.0
2002-01-28 09:00:00	IWM	ETF	47.8	47.975	47.79	47.9	42400.0
2002-01-28 10:00:00	IWM	ETF	47.9	47.9	47.65	47.845	25000.0
2002-01-28 11:00:00	IWM	ETF	47.845	47.85	47.585	47.635	42400.0
2002-01-28 12:00:00	IWM	ETF	47.61	47.71	47.5	47.62	98600.0
2002-01-28 13:00:00	IWM	ETF	47.545	47.64	47.515	47.62	19400.0
2002-01-28 14:00:00	IWM	ETF	47.61	47.69	47.6	47.625	38600.0
2002-01-28 15:00:00	IWM	ETF	47.625	48.0	47.6	47.975	138200.0
2002-01-28 16:00:00	IWM	ETF	47.805	47.95	47.805	47.83	213000.0
2002-01-28 09:00:00	DIA	ETF	98.86	99.04	98.78	98.91	529600.0
2002-01-28 10:00:00	DIA	ETF	98.89	98.92	98.52	98.62	307400.0
2002-01-28 11:00:00	DIA	ETF	98.63	98.73	98.38	98.38	95100.0
2002-01-28 12:00:00	DIA	ETF	98.35	98.41	98.09	98.17	231200.0
2002-01-28 13:00:00	DIA	ETF	98.18	98.34	98.01	98.11	219300.0
2002-01-28 14:00:00	DIA	ETF	98.21	98.43	98.16	98.21	74300.0
2002-01-28 15:00:00	DIA	ETF	98.26	98.73	98.22	98.69	99100.0
2002-01-28 16:00:00	DIA	ETF	98.72	99.5	98.69	98.88	155400.0

> showing 36 of 278 rows — these rows as CSV

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