PREVIEW / etf_30min / 2001-07-24

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-24.parquet
  size:    15 KB
  rows:    379

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-07-24 09:30:00	SPY	ETF	119.0	119.2	118.6	119.13	1396500.0
2001-07-24 10:00:00	SPY	ETF	119.11	119.15	118.41	118.67	979900.0
2001-07-24 10:30:00	SPY	ETF	118.7	119.15	118.62	119.05	313500.0
2001-07-24 11:00:00	SPY	ETF	119.06	119.12	118.08	118.18	893100.0
2001-07-24 11:30:00	SPY	ETF	118.21	118.38	118.17	118.27	336200.0
2001-07-24 12:00:00	SPY	ETF	118.25	118.25	117.66	118.03	1276400.0
2001-07-24 12:30:00	SPY	ETF	118.01	118.02	117.71	117.9	362300.0
2001-07-24 13:00:00	SPY	ETF	117.88	118.14	117.88	118.1	581500.0
2001-07-24 13:30:00	SPY	ETF	118.09	118.34	117.62	117.62	507000.0
2001-07-24 14:00:00	SPY	ETF	117.65	117.79	117.37	117.69	1244800.0
2001-07-24 14:30:00	SPY	ETF	117.74	117.89	117.36	117.41	429800.0
2001-07-24 15:00:00	SPY	ETF	117.33	117.49	116.75	116.98	1778300.0
2001-07-24 15:30:00	SPY	ETF	116.96	117.48	116.96	117.39	1340900.0
2001-07-24 16:00:00	SPY	ETF	117.58	117.8	117.42	117.8	390900.0
2001-07-24 16:30:00	SPY	ETF	118.0	118.0	117.8	117.9	224200.0
2001-07-24 17:00:00	SPY	ETF	117.9	118.0	117.9	118.0	13200.0
2001-07-24 09:30:00	QQQ	ETF	40.38	40.7	40.12	40.65	9810700.0
2001-07-24 10:00:00	QQQ	ETF	40.54	40.7	40.15	40.38	5445300.0
2001-07-24 10:30:00	QQQ	ETF	40.39	40.89	40.35	40.79	4911200.0
2001-07-24 11:00:00	QQQ	ETF	40.77	40.9	40.28	40.4	6663600.0
2001-07-24 11:30:00	QQQ	ETF	40.38	40.5	40.25	40.29	2763200.0
2001-07-24 12:00:00	QQQ	ETF	40.26	40.34	40.02	40.18	3363100.0
2001-07-24 12:30:00	QQQ	ETF	40.19	40.24	39.97	40.15	1894900.0
2001-07-24 13:00:00	QQQ	ETF	40.14	40.34	40.06	40.2	2353200.0
2001-07-24 13:30:00	QQQ	ETF	40.2	40.36	39.89	39.95	4009200.0
2001-07-24 14:00:00	QQQ	ETF	39.96	40.09	39.53	39.72	7873700.0
2001-07-24 14:30:00	QQQ	ETF	39.72	39.9	39.61	39.68	3930200.0
2001-07-24 15:00:00	QQQ	ETF	39.7	39.8	39.31	39.6	5208900.0
2001-07-24 15:30:00	QQQ	ETF	39.57	40.05	39.55	40.01	6004800.0
2001-07-24 16:00:00	QQQ	ETF	40.01	40.3	40.01	40.25	2352000.0
2001-07-24 16:30:00	QQQ	ETF	40.25	40.3	40.16	40.29	280600.0
2001-07-24 17:00:00	QQQ	ETF	40.3	40.44	40.21	40.42	209400.0
2001-07-24 17:30:00	QQQ	ETF	40.39	40.5	40.35	40.44	88500.0
2001-07-24 18:00:00	QQQ	ETF	40.45	40.5	40.4	40.4	6800.0
2001-07-24 09:30:00	IWM	ETF	48.0	48.025	47.885	48.025	11000.0
2001-07-24 10:00:00	IWM	ETF	48.175	48.175	47.875	47.95	21200.0
2001-07-24 10:30:00	IWM	ETF	47.97	48.015	47.955	47.955	22200.0
2001-07-24 11:00:00	IWM	ETF	47.875	47.875	47.4	47.475	7400.0
2001-07-24 11:30:00	IWM	ETF	47.5	47.6	47.5	47.6	159200.0
2001-07-24 12:00:00	IWM	ETF	47.5	47.5	47.15	47.32	8800.0
2001-07-24 12:30:00	IWM	ETF	47.35	47.425	47.15	47.275	10600.0
2001-07-24 13:00:00	IWM	ETF	47.26	47.425	47.255	47.425	39000.0
2001-07-24 13:30:00	IWM	ETF	47.355	47.48	47.3	47.3	61800.0
2001-07-24 14:00:00	IWM	ETF	47.3	47.375	47.055	47.055	40200.0
2001-07-24 14:30:00	IWM	ETF	47.15	47.275	47.05	47.1	20400.0
2001-07-24 15:00:00	IWM	ETF	47.1	47.2	46.9	47.195	51200.0
2001-07-24 15:30:00	IWM	ETF	47.15	47.365	47.1	47.255	131000.0
2001-07-24 16:00:00	IWM	ETF	47.25	47.35	47.25	47.35	400.0
2001-07-24 09:30:00	DIA	ETF	103.8	104.17	103.77	104.09	241800.0
2001-07-24 10:00:00	DIA	ETF	104.1	104.11	103.44	103.7	189600.0

> showing 50 of 379 rows — these rows as CSV

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