PREVIEW / etf_30min / 2001-07-31

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-31.parquet
  size:    15 KB
  rows:    385

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-31 09:30:00	SPY	ETF	121.0	121.25	120.88	121.25	763600.0
2001-07-31 10:00:00	SPY	ETF	121.21	121.88	120.86	121.8	2045200.0
2001-07-31 10:30:00	SPY	ETF	121.8	122.26	121.71	122.24	498700.0
2001-07-31 11:00:00	SPY	ETF	122.24	122.55	122.1	122.42	1040900.0
2001-07-31 11:30:00	SPY	ETF	122.39	122.48	122.28	122.29	438700.0
2001-07-31 12:00:00	SPY	ETF	122.27	122.55	122.23	122.48	406800.0
2001-07-31 12:30:00	SPY	ETF	122.46	122.49	122.32	122.4	130900.0
2001-07-31 13:00:00	SPY	ETF	122.39	122.47	122.23	122.38	96900.0
2001-07-31 13:30:00	SPY	ETF	122.35	122.67	122.35	122.65	443800.0
2001-07-31 14:00:00	SPY	ETF	122.68	122.68	122.16	122.26	877200.0
2001-07-31 14:30:00	SPY	ETF	122.28	122.29	122.1	122.17	300000.0
2001-07-31 15:00:00	SPY	ETF	122.17	122.37	121.83	121.86	353300.0
2001-07-31 15:30:00	SPY	ETF	121.9	121.94	121.4	121.46	698500.0
2001-07-31 16:00:00	SPY	ETF	121.44	121.47	121.2	121.35	867000.0
2001-07-31 17:00:00	SPY	ETF	121.18	121.18	121.18	121.18	1500.0
2001-07-31 18:00:00	SPY	ETF	121.01	121.01	121.01	121.01	500.0
2001-07-31 09:30:00	QQQ	ETF	41.84	42.01	41.52	41.83	4284100.0
2001-07-31 10:00:00	QQQ	ETF	41.88	42.14	41.5	41.97	6073000.0
2001-07-31 10:30:00	QQQ	ETF	42.0	42.48	41.85	42.4	5443800.0
2001-07-31 11:00:00	QQQ	ETF	42.38	42.73	42.32	42.55	5381500.0
2001-07-31 11:30:00	QQQ	ETF	42.55	42.61	42.45	42.46	1923900.0
2001-07-31 12:00:00	QQQ	ETF	42.46	42.78	42.4	42.72	2557300.0
2001-07-31 12:30:00	QQQ	ETF	42.72	42.75	42.57	42.62	1187400.0
2001-07-31 13:00:00	QQQ	ETF	42.62	42.67	42.5	42.55	1371800.0
2001-07-31 13:30:00	QQQ	ETF	42.6	42.78	42.52	42.72	1996600.0
2001-07-31 14:00:00	QQQ	ETF	42.74	42.74	42.25	42.37	2667000.0
2001-07-31 14:30:00	QQQ	ETF	42.34	42.42	42.21	42.35	2768600.0
2001-07-31 15:00:00	QQQ	ETF	42.39	42.48	42.03	42.11	3551900.0
2001-07-31 15:30:00	QQQ	ETF	42.13	42.2	41.9	41.95	5818500.0
2001-07-31 16:00:00	QQQ	ETF	41.93	42.08	41.73	41.82	1854800.0
2001-07-31 16:30:00	QQQ	ETF	41.91	42.08	41.8	41.82	944500.0
2001-07-31 17:00:00	QQQ	ETF	41.89	41.92	41.75	41.75	95400.0
2001-07-31 17:30:00	QQQ	ETF	41.74	41.92	41.73	41.75	112500.0
2001-07-31 18:00:00	QQQ	ETF	41.75	41.97	41.72	41.75	32600.0
2001-07-31 09:30:00	IWM	ETF	48.295	48.3	48.295	48.3	3400.0
2001-07-31 10:00:00	IWM	ETF	48.38	48.565	48.295	48.555	25400.0
2001-07-31 10:30:00	IWM	ETF	48.575	48.665	48.475	48.645	19400.0
2001-07-31 11:00:00	IWM	ETF	48.685	48.835	48.6	48.825	83200.0
2001-07-31 11:30:00	IWM	ETF	48.825	48.825	48.6	48.775	84400.0
2001-07-31 12:00:00	IWM	ETF	48.745	48.805	48.63	48.775	17200.0
2001-07-31 12:30:00	IWM	ETF	48.805	48.805	48.67	48.68	5400.0
2001-07-31 13:00:00	IWM	ETF	48.75	48.77	48.66	48.77	6400.0
2001-07-31 13:30:00	IWM	ETF	48.75	48.825	48.75	48.825	1400.0
2001-07-31 14:00:00	IWM	ETF	48.8	48.8	48.625	48.63	54800.0
2001-07-31 14:30:00	IWM	ETF	48.625	48.625	48.31	48.35	82000.0
2001-07-31 15:00:00	IWM	ETF	48.38	48.52	48.25	48.25	41400.0
2001-07-31 15:30:00	IWM	ETF	48.3	48.3	48.06	48.06	173400.0
2001-07-31 16:00:00	IWM	ETF	48.12	48.12	48.075	48.115	19000.0
2001-07-31 09:30:00	DIA	ETF	104.25	104.57	104.16	104.57	322100.0
2001-07-31 10:00:00	DIA	ETF	104.55	105.35	104.36	105.32	240000.0

> showing 50 of 385 rows — these rows as CSV

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