PREVIEW / etf_1hour / 2002-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-03-20.parquet
  size:    14 KB
  rows:    303

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-20 09:00:00	SPY	ETF	116.47	116.58	116.28	116.43	2296300.0
2002-03-20 10:00:00	SPY	ETF	116.4	116.43	115.94	116.17	2868300.0
2002-03-20 11:00:00	SPY	ETF	116.13	116.27	116.0	116.18	2116300.0
2002-03-20 12:00:00	SPY	ETF	116.2	116.41	116.05	116.34	1827100.0
2002-03-20 13:00:00	SPY	ETF	116.31	116.37	115.97	116.1	832200.0
2002-03-20 14:00:00	SPY	ETF	116.11	116.12	115.7	115.77	2915000.0
2002-03-20 15:00:00	SPY	ETF	115.77	115.87	115.39	115.43	2103400.0
2002-03-20 16:00:00	SPY	ETF	115.43	115.44	115.19	115.21	1055400.0
2002-03-20 17:00:00	SPY	ETF	115.27	115.4	115.2	115.28	476300.0
2002-03-20 18:00:00	SPY	ETF	115.26	115.26	114.4	115.26	11200.0
2002-03-20 09:00:00	QQQ	ETF	36.87	37.08	36.84	36.88	9776700.0
2002-03-20 10:00:00	QQQ	ETF	36.99	36.99	36.59	36.74	12809400.0
2002-03-20 11:00:00	QQQ	ETF	36.73	36.84	36.63	36.77	5026200.0
2002-03-20 12:00:00	QQQ	ETF	36.76	36.87	36.68	36.79	3270800.0
2002-03-20 13:00:00	QQQ	ETF	36.79	36.82	36.61	36.69	4330800.0
2002-03-20 14:00:00	QQQ	ETF	36.69	36.72	36.32	36.41	11205300.0
2002-03-20 15:00:00	QQQ	ETF	36.4	36.47	36.14	36.15	11140000.0
2002-03-20 16:00:00	QQQ	ETF	36.15	36.3	36.0	36.08	1781100.0
2002-03-20 17:00:00	QQQ	ETF	36.08	36.09	36.02	36.02	24000.0
2002-03-20 18:00:00	QQQ	ETF	36.05	36.08	36.0	36.05	21300.0
2002-03-20 09:00:00	IWM	ETF	49.975	50.025	49.775	49.915	145000.0
2002-03-20 10:00:00	IWM	ETF	49.88	49.89	49.6	49.75	208600.0
2002-03-20 11:00:00	IWM	ETF	49.63	49.815	49.63	49.745	258000.0
2002-03-20 12:00:00	IWM	ETF	49.745	49.915	49.745	49.915	109000.0
2002-03-20 13:00:00	IWM	ETF	49.88	49.945	49.85	49.93	104000.0
2002-03-20 14:00:00	IWM	ETF	49.865	49.875	49.735	49.78	356800.0
2002-03-20 15:00:00	IWM	ETF	49.845	49.845	49.56	49.595	510400.0
2002-03-20 16:00:00	IWM	ETF	49.565	49.58	49.425	49.435	51000.0
2002-03-20 09:00:00	DIA	ETF	105.93	105.93	105.5	105.75	760100.0
2002-03-20 10:00:00	DIA	ETF	105.68	105.77	105.39	105.57	798900.0
2002-03-20 11:00:00	DIA	ETF	105.56	105.8	105.4	105.75	421200.0
2002-03-20 12:00:00	DIA	ETF	105.69	105.87	105.6	105.8	868700.0
2002-03-20 13:00:00	DIA	ETF	105.79	105.84	105.45	105.52	639900.0
2002-03-20 14:00:00	DIA	ETF	105.51	105.52	105.2	105.34	895400.0
2002-03-20 15:00:00	DIA	ETF	105.3	105.43	105.0	105.12	611800.0
2002-03-20 16:00:00	DIA	ETF	105.09	105.11	104.93	104.94	59500.0

> showing 36 of 303 rows — these rows as CSV

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