PREVIEW / etf_30min / 2001-07-18

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-18.parquet
  size:    15 KB
  rows:    382

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-18 09:30:00	SPY	ETF	120.56	121.24	120.53	121.2	907900.0
2001-07-18 10:00:00	SPY	ETF	121.17	121.64	120.06	120.49	1036700.0
2001-07-18 10:30:00	SPY	ETF	120.46	120.7	120.21	120.66	763500.0
2001-07-18 11:00:00	SPY	ETF	120.61	121.19	120.54	120.94	406000.0
2001-07-18 11:30:00	SPY	ETF	121.0	121.13	120.73	120.77	272500.0
2001-07-18 12:00:00	SPY	ETF	120.83	120.88	120.45	120.5	352200.0
2001-07-18 12:30:00	SPY	ETF	120.46	120.64	120.35	120.45	241300.0
2001-07-18 13:00:00	SPY	ETF	120.45	120.74	120.27	120.7	183700.0
2001-07-18 13:30:00	SPY	ETF	120.65	120.94	120.58	120.75	196700.0
2001-07-18 14:00:00	SPY	ETF	120.72	120.72	120.27	120.44	352100.0
2001-07-18 14:30:00	SPY	ETF	120.38	120.65	120.21	120.34	449200.0
2001-07-18 15:00:00	SPY	ETF	120.29	120.65	120.23	120.58	262900.0
2001-07-18 15:30:00	SPY	ETF	120.53	121.14	120.47	121.1	927600.0
2001-07-18 16:00:00	SPY	ETF	121.04	121.23	120.74	121.1	987900.0
2001-07-18 16:30:00	SPY	ETF	121.0	121.0	120.77	120.77	600.0
2001-07-18 17:00:00	SPY	ETF	121.0	121.0	120.55	120.55	18700.0
2001-07-18 17:30:00	SPY	ETF	120.88	120.9	120.7	120.9	8000.0
2001-07-18 18:00:00	SPY	ETF	120.62	120.63	120.62	120.63	1000.0
2001-07-18 09:30:00	QQQ	ETF	42.27	42.55	42.07	42.51	9647700.0
2001-07-18 10:00:00	QQQ	ETF	42.5	42.85	41.54	41.81	11614700.0
2001-07-18 10:30:00	QQQ	ETF	41.85	41.94	41.51	41.8	5255400.0
2001-07-18 11:00:00	QQQ	ETF	41.81	42.24	41.72	42.0	5990600.0
2001-07-18 11:30:00	QQQ	ETF	42.0	42.11	41.78	41.85	2293300.0
2001-07-18 12:00:00	QQQ	ETF	41.89	41.95	41.6	41.63	1769200.0
2001-07-18 12:30:00	QQQ	ETF	41.65	41.84	41.54	41.7	1913600.0
2001-07-18 13:00:00	QQQ	ETF	41.72	41.82	41.43	41.7	2644400.0
2001-07-18 13:30:00	QQQ	ETF	41.7	41.94	41.56	41.66	1894800.0
2001-07-18 14:00:00	QQQ	ETF	41.68	41.7	41.26	41.35	2440400.0
2001-07-18 14:30:00	QQQ	ETF	41.35	41.57	41.14	41.22	4283100.0
2001-07-18 15:00:00	QQQ	ETF	41.2	41.51	41.17	41.31	3399600.0
2001-07-18 15:30:00	QQQ	ETF	41.35	41.56	41.24	41.54	4481300.0
2001-07-18 16:00:00	QQQ	ETF	41.52	41.85	40.75	41.31	3086900.0
2001-07-18 16:30:00	QQQ	ETF	41.39	41.55	41.0	41.41	338900.0
2001-07-18 17:00:00	QQQ	ETF	41.4	41.48	40.96	41.17	1487000.0
2001-07-18 17:30:00	QQQ	ETF	41.19	41.6	41.02	41.4	484500.0
2001-07-18 18:00:00	QQQ	ETF	41.43	41.5	41.37	41.37	83900.0
2001-07-18 09:30:00	IWM	ETF	48.35	48.82	48.35	48.82	5800.0
2001-07-18 10:00:00	IWM	ETF	48.845	48.945	48.35	48.575	129600.0
2001-07-18 10:30:00	IWM	ETF	48.565	48.58	48.45	48.565	13000.0
2001-07-18 11:00:00	IWM	ETF	48.58	48.795	48.5	48.775	199200.0
2001-07-18 11:30:00	IWM	ETF	48.75	48.76	48.55	48.71	23400.0
2001-07-18 12:00:00	IWM	ETF	48.71	48.71	48.67	48.67	106000.0
2001-07-18 12:30:00	IWM	ETF	48.595	48.6	48.5	48.575	145400.0
2001-07-18 13:00:00	IWM	ETF	48.575	48.6	48.49	48.57	6200.0
2001-07-18 13:30:00	IWM	ETF	48.61	48.61	48.515	48.515	800.0
2001-07-18 14:00:00	IWM	ETF	48.57	48.57	48.45	48.45	15000.0
2001-07-18 14:30:00	IWM	ETF	48.415	48.48	48.15	48.15	152600.0
2001-07-18 15:00:00	IWM	ETF	48.15	48.3	48.125	48.24	23400.0
2001-07-18 15:30:00	IWM	ETF	48.285	48.3	48.155	48.155	29400.0
2001-07-18 16:00:00	IWM	ETF	48.1	48.1	48.075	48.1	15200.0

> showing 50 of 382 rows — these rows as CSV

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