PREVIEW / etf_1hour / 2002-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-03-27.parquet
  size:    14 KB
  rows:    295

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-03-27 09:00:00	SPY	ETF	114.03	114.2	113.76	114.1	1275100.0
2002-03-27 10:00:00	SPY	ETF	114.1	114.6	113.92	114.45	2749700.0
2002-03-27 11:00:00	SPY	ETF	114.45	114.96	114.29	114.93	2459300.0
2002-03-27 12:00:00	SPY	ETF	114.95	114.98	114.73	114.9	1474600.0
2002-03-27 13:00:00	SPY	ETF	114.9	115.01	114.64	114.79	1235900.0
2002-03-27 14:00:00	SPY	ETF	114.78	114.8	114.19	114.65	5657100.0
2002-03-27 15:00:00	SPY	ETF	114.69	114.96	114.45	114.67	2690000.0
2002-03-27 16:00:00	SPY	ETF	114.71	114.8	114.5	114.52	906000.0
2002-03-27 17:00:00	SPY	ETF	114.47	114.47	114.47	114.47	200.0
2002-03-27 18:00:00	SPY	ETF	114.52	114.52	114.52	114.52	900.0
2002-03-27 09:00:00	QQQ	ETF	35.63	35.8	35.46	35.63	8454600.0
2002-03-27 10:00:00	QQQ	ETF	35.65	35.85	35.52	35.65	14148300.0
2002-03-27 11:00:00	QQQ	ETF	35.65	36.0	35.6	35.98	10388500.0
2002-03-27 12:00:00	QQQ	ETF	35.98	36.0	35.71	35.88	4383700.0
2002-03-27 13:00:00	QQQ	ETF	35.88	35.91	35.65	35.7	4796200.0
2002-03-27 14:00:00	QQQ	ETF	35.7	35.74	35.42	35.66	9399600.0
2002-03-27 15:00:00	QQQ	ETF	35.64	35.83	35.56	35.76	10820700.0
2002-03-27 16:00:00	QQQ	ETF	35.75	35.81	35.5	35.59	1289000.0
2002-03-27 17:00:00	QQQ	ETF	35.6	35.64	35.56	35.6	50300.0
2002-03-27 18:00:00	QQQ	ETF	35.58	35.61	35.56	35.57	12300.0
2002-03-27 09:00:00	IWM	ETF	49.85	49.96	49.735	49.885	29600.0
2002-03-27 10:00:00	IWM	ETF	49.95	50.175	49.95	50.05	186800.0
2002-03-27 11:00:00	IWM	ETF	50.155	50.295	50.05	50.25	164600.0
2002-03-27 12:00:00	IWM	ETF	50.285	50.315	50.2	50.25	38600.0
2002-03-27 13:00:00	IWM	ETF	50.27	50.27	50.18	50.225	11400.0
2002-03-27 14:00:00	IWM	ETF	50.155	50.165	50.04	50.165	41800.0
2002-03-27 15:00:00	IWM	ETF	50.175	50.295	50.145	50.295	93000.0
2002-03-27 16:00:00	IWM	ETF	50.295	50.32	50.295	50.32	102000.0
2002-03-27 09:00:00	DIA	ETF	103.55	103.84	103.4	103.77	630500.0
2002-03-27 10:00:00	DIA	ETF	103.76	104.25	103.67	104.06	988900.0
2002-03-27 11:00:00	DIA	ETF	104.1	104.6	103.96	104.56	878000.0
2002-03-27 12:00:00	DIA	ETF	104.57	104.61	104.41	104.55	730300.0
2002-03-27 13:00:00	DIA	ETF	104.55	104.65	104.4	104.48	313600.0
2002-03-27 14:00:00	DIA	ETF	104.47	104.47	103.91	104.31	1323500.0
2002-03-27 15:00:00	DIA	ETF	104.31	104.57	104.12	104.29	888000.0
2002-03-27 16:00:00	DIA	ETF	104.29	104.35	104.25	104.31	68000.0

> showing 36 of 295 rows — these rows as CSV

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