PREVIEW / etf_30min / 2002-04-23

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-04-23.parquet
  size:    18 KB
  rows:    489

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-04-23 09:30:00	SPY	ETF	111.09	111.48	110.73	111.4	2943800.0
2002-04-23 10:00:00	SPY	ETF	111.41	111.47	110.85	110.95	1729400.0
2002-04-23 10:30:00	SPY	ETF	110.99	111.48	110.95	111.31	1028300.0
2002-04-23 11:00:00	SPY	ETF	111.27	111.45	111.02	111.1	705500.0
2002-04-23 11:30:00	SPY	ETF	111.1	111.22	111.0	111.09	549500.0
2002-04-23 12:00:00	SPY	ETF	111.06	111.31	111.01	111.05	634400.0
2002-04-23 12:30:00	SPY	ETF	111.05	111.08	110.75	110.89	1903500.0
2002-04-23 13:00:00	SPY	ETF	110.9	111.18	110.85	111.13	717900.0
2002-04-23 13:30:00	SPY	ETF	111.11	111.35	111.08	111.08	686700.0
2002-04-23 14:00:00	SPY	ETF	111.1	111.22	110.81	111.03	789200.0
2002-04-23 14:30:00	SPY	ETF	111.01	111.27	110.97	111.05	530800.0
2002-04-23 15:00:00	SPY	ETF	111.04	111.05	110.58	110.65	1217000.0
2002-04-23 15:30:00	SPY	ETF	110.66	110.66	110.17	110.38	1874700.0
2002-04-23 16:00:00	SPY	ETF	110.36	110.59	110.28	110.48	1016500.0
2002-04-23 16:30:00	SPY	ETF	110.42	110.55	110.35	110.55	13800.0
2002-04-23 17:00:00	SPY	ETF	110.55	110.63	110.55	110.62	2300.0
2002-04-23 17:30:00	SPY	ETF	110.59	110.63	110.59	110.6	1600.0
2002-04-23 18:00:00	SPY	ETF	110.57	110.7	110.57	110.7	4200.0
2002-04-23 09:30:00	QQQ	ETF	33.59	33.78	33.41	33.73	8506600.0
2002-04-23 10:00:00	QQQ	ETF	33.74	33.77	33.36	33.46	6009400.0
2002-04-23 10:30:00	QQQ	ETF	33.47	33.7	33.43	33.59	5486000.0
2002-04-23 11:00:00	QQQ	ETF	33.59	33.66	33.47	33.54	2238200.0
2002-04-23 11:30:00	QQQ	ETF	33.54	33.62	33.44	33.47	1821700.0
2002-04-23 12:00:00	QQQ	ETF	33.46	33.55	33.33	33.36	2726600.0
2002-04-23 12:30:00	QQQ	ETF	33.35	33.38	33.17	33.24	5094400.0
2002-04-23 13:00:00	QQQ	ETF	33.25	33.36	33.18	33.34	2027800.0
2002-04-23 13:30:00	QQQ	ETF	33.32	33.4	33.23	33.24	2291800.0
2002-04-23 14:00:00	QQQ	ETF	33.24	33.29	33.1	33.18	3196600.0
2002-04-23 14:30:00	QQQ	ETF	33.18	33.38	33.15	33.22	2875800.0
2002-04-23 15:00:00	QQQ	ETF	33.22	33.25	32.9	32.94	5807100.0
2002-04-23 15:30:00	QQQ	ETF	32.94	32.95	32.7	32.86	21174400.0
2002-04-23 16:00:00	QQQ	ETF	32.88	33.02	32.76	32.94	1560900.0
2002-04-23 16:30:00	QQQ	ETF	32.94	33.0	32.92	32.96	546500.0
2002-04-23 17:00:00	QQQ	ETF	32.96	33.01	32.95	32.99	54900.0
2002-04-23 17:30:00	QQQ	ETF	32.99	33.5	32.99	33.04	83100.0
2002-04-23 18:00:00	QQQ	ETF	33.04	33.12	33.04	33.12	42600.0
2002-04-23 09:30:00	IWM	ETF	50.8	51.0	50.73	51.0	301000.0
2002-04-23 10:00:00	IWM	ETF	50.95	51.04	50.89	50.89	244000.0
2002-04-23 10:30:00	IWM	ETF	50.89	51.02	50.86	51.01	54600.0
2002-04-23 11:00:00	IWM	ETF	51.01	51.02	50.94	50.98	6400.0
2002-04-23 11:30:00	IWM	ETF	50.91	50.98	50.9	50.96	21800.0
2002-04-23 12:00:00	IWM	ETF	50.96	50.99	50.9	50.9	15800.0
2002-04-23 12:30:00	IWM	ETF	50.87	50.9	50.81	50.855	52600.0
2002-04-23 13:00:00	IWM	ETF	50.87	50.97	50.865	50.925	17400.0
2002-04-23 13:30:00	IWM	ETF	50.925	51.035	50.9	50.945	31000.0
2002-04-23 14:00:00	IWM	ETF	51.0	51.0	50.88	50.945	21600.0
2002-04-23 14:30:00	IWM	ETF	50.945	51.0	50.94	51.0	25400.0
2002-04-23 15:00:00	IWM	ETF	50.995	50.995	50.8	50.8	31000.0
2002-04-23 15:30:00	IWM	ETF	50.78	50.805	50.7	50.8	64600.0
2002-04-23 16:00:00	IWM	ETF	50.865	50.95	50.79	50.79	905600.0

> showing 50 of 489 rows — these rows as CSV

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