PREVIEW / etf_30min / 2001-02-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-02-27.parquet
  size:    15 KB
  rows:    361

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-02-27 09:30:00	SPY	ETF	126.8	127.25	126.75	127.17	1414800.0
2001-02-27 10:00:00	SPY	ETF	127.05	127.6	126.0	126.6	1487700.0
2001-02-27 10:30:00	SPY	ETF	126.58	126.79	126.01	126.61	998500.0
2001-02-27 11:00:00	SPY	ETF	126.6	127.19	126.41	127.19	447700.0
2001-02-27 11:30:00	SPY	ETF	127.19	127.84	127.11	127.55	1878200.0
2001-02-27 12:00:00	SPY	ETF	127.66	127.73	127.26	127.35	367900.0
2001-02-27 12:30:00	SPY	ETF	127.3	127.57	126.89	127.18	479800.0
2001-02-27 13:00:00	SPY	ETF	127.15	127.21	126.45	126.51	567400.0
2001-02-27 13:30:00	SPY	ETF	126.51	126.89	126.27	126.38	364600.0
2001-02-27 14:00:00	SPY	ETF	126.35	126.49	125.9	126.18	543400.0
2001-02-27 14:30:00	SPY	ETF	126.19	126.55	125.8	126.4	596500.0
2001-02-27 15:00:00	SPY	ETF	126.32	126.37	125.51	125.73	894600.0
2001-02-27 15:30:00	SPY	ETF	125.73	126.55	125.7	126.35	515700.0
2001-02-27 16:00:00	SPY	ETF	126.32	126.55	126.25	126.44	535700.0
2001-02-27 16:30:00	SPY	ETF	126.4	126.4	126.4	126.4	600.0
2001-02-27 18:00:00	SPY	ETF	126.5	126.5	126.5	126.5	200.0
2001-02-27 09:30:00	QQQ	ETF	51.54	51.72	51.19	51.49	6697700.0
2001-02-27 10:00:00	QQQ	ETF	51.54	52.05	50.29	50.77	10397700.0
2001-02-27 10:30:00	QQQ	ETF	50.78	50.95	50.13	50.45	4819700.0
2001-02-27 11:00:00	QQQ	ETF	50.5	51.05	50.37	50.98	2990100.0
2001-02-27 11:30:00	QQQ	ETF	50.9	51.37	50.9	51.25	3627900.0
2001-02-27 12:00:00	QQQ	ETF	51.21	51.36	50.78	50.87	1509200.0
2001-02-27 12:30:00	QQQ	ETF	50.8	51.14	50.63	50.67	1807800.0
2001-02-27 13:00:00	QQQ	ETF	50.69	50.8	50.25	50.35	2711000.0
2001-02-27 13:30:00	QQQ	ETF	50.27	50.56	49.95	50.03	3813100.0
2001-02-27 14:00:00	QQQ	ETF	50.05	50.12	49.58	49.9	5123200.0
2001-02-27 14:30:00	QQQ	ETF	49.9	50.15	49.55	49.99	4855400.0
2001-02-27 15:00:00	QQQ	ETF	49.94	50.0	49.0	49.12	6770800.0
2001-02-27 15:30:00	QQQ	ETF	49.1	49.6	48.9	49.15	7234200.0
2001-02-27 16:00:00	QQQ	ETF	49.15	49.24	48.6	49.08	1489100.0
2001-02-27 16:30:00	QQQ	ETF	49.01	49.05	48.66	48.7	370900.0
2001-02-27 17:00:00	QQQ	ETF	48.75	49.2	48.6	48.67	210900.0
2001-02-27 17:30:00	QQQ	ETF	48.75	48.89	48.65	48.74	27000.0
2001-02-27 18:00:00	QQQ	ETF	48.85	48.85	48.66	48.78	17400.0
2001-02-27 09:30:00	IWM	ETF	48.65	48.65	48.375	48.375	7600.0
2001-02-27 10:00:00	IWM	ETF	48.5	48.5	48.175	48.25	131800.0
2001-02-27 10:30:00	IWM	ETF	48.185	48.185	48.185	48.185	2000.0
2001-02-27 11:00:00	IWM	ETF	48.125	48.475	48.125	48.475	4200.0
2001-02-27 11:30:00	IWM	ETF	48.5	48.5	48.425	48.425	600.0
2001-02-27 12:00:00	IWM	ETF	48.525	48.525	48.355	48.355	6000.0
2001-02-27 12:30:00	IWM	ETF	48.47	48.5	48.35	48.36	21000.0
2001-02-27 13:00:00	IWM	ETF	48.225	48.325	48.225	48.275	20600.0
2001-02-27 13:30:00	IWM	ETF	48.255	48.275	48.105	48.125	10400.0
2001-02-27 14:00:00	IWM	ETF	48.1	48.2	47.875	47.925	135200.0
2001-02-27 14:30:00	IWM	ETF	48.045	48.05	47.875	48.05	35800.0
2001-02-27 15:00:00	IWM	ETF	47.85	47.85	47.625	47.725	11800.0
2001-02-27 15:30:00	IWM	ETF	47.8	47.93	47.625	47.73	30800.0
2001-02-27 16:00:00	IWM	ETF	47.71	47.775	47.635	47.775	10400.0
2001-02-27 09:30:00	DIA	ETF	106.28	106.77	106.2	106.77	174000.0
2001-02-27 10:00:00	DIA	ETF	106.77	107.0	105.6	106.3	491900.0

> showing 50 of 361 rows — these rows as CSV

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