PREVIEW / etf_30min / 2001-05-01

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-05-01.parquet
  size:    15 KB
  rows:    353

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-05-01 09:30:00	SPY	ETF	125.07	125.34	124.6	125.27	1550200.0
2001-05-01 10:00:00	SPY	ETF	125.25	125.45	124.6	124.7	1316900.0
2001-05-01 10:30:00	SPY	ETF	124.72	125.64	124.68	125.4	506400.0
2001-05-01 11:00:00	SPY	ETF	125.4	125.5	124.86	125.13	444100.0
2001-05-01 11:30:00	SPY	ETF	125.1	125.42	124.97	125.39	347300.0
2001-05-01 12:00:00	SPY	ETF	125.39	125.48	125.01	125.01	286500.0
2001-05-01 12:30:00	SPY	ETF	125.02	125.4	124.87	125.3	250200.0
2001-05-01 13:00:00	SPY	ETF	125.44	125.73	125.3	125.7	447000.0
2001-05-01 13:30:00	SPY	ETF	125.7	125.88	125.46	125.51	625700.0
2001-05-01 14:00:00	SPY	ETF	125.65	126.27	125.48	126.1	534900.0
2001-05-01 14:30:00	SPY	ETF	126.1	126.5	125.96	126.5	519900.0
2001-05-01 15:00:00	SPY	ETF	126.59	126.67	126.11	126.33	737300.0
2001-05-01 15:30:00	SPY	ETF	126.47	126.97	126.37	126.94	1731500.0
2001-05-01 16:00:00	SPY	ETF	126.96	127.15	125.65	127.0	428000.0
2001-05-01 16:30:00	SPY	ETF	127.1	127.1	127.09	127.09	1300.0
2001-05-01 17:00:00	SPY	ETF	127.2	127.2	127.03	127.1	101900.0
2001-05-01 18:00:00	SPY	ETF	127.27	127.3	127.03	127.3	300.0
2001-05-01 09:30:00	QQQ	ETF	46.2	46.3	45.75	46.0	6303800.0
2001-05-01 10:00:00	QQQ	ETF	45.98	46.34	45.4	45.46	5125000.0
2001-05-01 10:30:00	QQQ	ETF	45.51	46.21	45.45	46.06	3394900.0
2001-05-01 11:00:00	QQQ	ETF	46.05	46.07	45.63	45.86	2149100.0
2001-05-01 11:30:00	QQQ	ETF	45.91	46.09	45.74	46.0	1608800.0
2001-05-01 12:00:00	QQQ	ETF	46.05	46.1	45.69	45.71	1639600.0
2001-05-01 12:30:00	QQQ	ETF	45.71	45.95	45.6	45.95	1500300.0
2001-05-01 13:00:00	QQQ	ETF	45.93	46.32	45.88	46.26	2088100.0
2001-05-01 13:30:00	QQQ	ETF	46.3	46.5	46.13	46.2	3065800.0
2001-05-01 14:00:00	QQQ	ETF	46.22	46.8	46.1	46.7	3714300.0
2001-05-01 14:30:00	QQQ	ETF	46.68	47.3	46.62	47.3	7122100.0
2001-05-01 15:00:00	QQQ	ETF	47.3	47.42	47.0	47.35	4946700.0
2001-05-01 15:30:00	QQQ	ETF	47.32	47.9	47.2	47.85	7285500.0
2001-05-01 16:00:00	QQQ	ETF	47.9	48.19	47.79	48.1	1527100.0
2001-05-01 16:30:00	QQQ	ETF	48.12	48.4	48.1	48.27	141000.0
2001-05-01 17:00:00	QQQ	ETF	48.2	48.3	48.05	48.3	145400.0
2001-05-01 17:30:00	QQQ	ETF	48.3	48.31	48.05	48.25	25900.0
2001-05-01 18:00:00	QQQ	ETF	48.29	48.47	48.05	48.4	36100.0
2001-05-01 09:30:00	IWM	ETF	48.325	48.5	48.325	48.5	38600.0
2001-05-01 10:00:00	IWM	ETF	48.3	48.42	48.015	48.015	119800.0
2001-05-01 10:30:00	IWM	ETF	48.15	48.275	48.15	48.2	2400.0
2001-05-01 11:00:00	IWM	ETF	48.25	48.3	48.165	48.28	25600.0
2001-05-01 11:30:00	IWM	ETF	48.25	48.25	48.25	48.25	200.0
2001-05-01 12:00:00	IWM	ETF	48.3	48.3	48.12	48.29	11600.0
2001-05-01 12:30:00	IWM	ETF	48.12	48.3	48.11	48.11	8800.0
2001-05-01 13:00:00	IWM	ETF	48.3	48.35	48.225	48.35	11600.0
2001-05-01 13:30:00	IWM	ETF	48.33	48.6	48.33	48.35	52400.0
2001-05-01 14:00:00	IWM	ETF	48.525	48.675	48.525	48.675	3600.0
2001-05-01 14:30:00	IWM	ETF	48.775	48.8	48.675	48.775	17800.0
2001-05-01 15:00:00	IWM	ETF	48.85	48.9	48.85	48.875	71800.0
2001-05-01 15:30:00	IWM	ETF	48.9	49.1	48.8	49.1	190400.0
2001-05-01 16:00:00	IWM	ETF	49.1	49.1	49.1	49.1	200.0
2001-05-01 09:30:00	DIA	ETF	107.45	107.74	107.3	107.74	499000.0

> showing 50 of 353 rows — these rows as CSV

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