PREVIEW / etf_30min / 2005-06-29

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-29.parquet
  size:    42 KB
  rows:    1,551

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
2005-06-29 07:00:00	SPY	ETF	120.12	120.27	120.11	120.15	100600.0
2005-06-29 07:30:00	SPY	ETF	120.15	120.18	120.11	120.18	64800.0
2005-06-29 08:00:00	SPY	ETF	120.17	120.26	120.15	120.25	123500.0
2005-06-29 08:30:00	SPY	ETF	120.26	120.36	120.25	120.34	111200.0
2005-06-29 09:00:00	SPY	ETF	120.35	120.41	120.31	120.37	51300.0
2005-06-29 09:30:00	SPY	ETF	120.37	120.4	120.08	120.11	4834600.0
2005-06-29 10:00:00	SPY	ETF	120.11	120.22	120.02	120.12	3765400.0
2005-06-29 10:30:00	SPY	ETF	120.12	120.36	120.12	120.25	5962200.0
2005-06-29 11:00:00	SPY	ETF	120.22	120.26	120.11	120.19	1389800.0
2005-06-29 11:30:00	SPY	ETF	120.19	120.29	120.15	120.21	959800.0
2005-06-29 12:00:00	SPY	ETF	120.21	120.25	120.14	120.22	761100.0
2005-06-29 12:30:00	SPY	ETF	120.21	120.29	120.18	120.24	870300.0
2005-06-29 13:00:00	SPY	ETF	120.24	120.27	120.16	120.18	1460400.0
2005-06-29 13:30:00	SPY	ETF	120.18	120.24	119.86	119.91	5336600.0
2005-06-29 14:00:00	SPY	ETF	119.91	120.04	119.88	120.01	2827400.0
2005-06-29 14:30:00	SPY	ETF	120.01	120.18	119.81	119.86	2904700.0
2005-06-29 15:00:00	SPY	ETF	119.85	119.98	119.81	119.86	2569900.0
2005-06-29 15:30:00	SPY	ETF	119.86	120.13	119.85	119.94	5559900.0
2005-06-29 16:00:00	SPY	ETF	119.95	119.96	119.77	119.82	1396700.0
2005-06-29 16:30:00	SPY	ETF	119.84	119.87	119.84	119.87	12300.0
2005-06-29 17:00:00	SPY	ETF	119.85	119.95	119.85	119.86	667100.0
2005-06-29 17:30:00	SPY	ETF	119.85	119.85	119.85	119.85	100.0
2005-06-29 18:00:00	SPY	ETF	119.84	119.84	119.8	119.84	700.0
2005-06-29 18:30:00	SPY	ETF	119.82	119.82	119.82	119.82	49100.0
2005-06-29 19:00:00	SPY	ETF	119.87	119.87	119.86	119.86	500.0
2005-06-29 09:30:00	QQQ	ETF	37.25	37.26	37.07	37.09	10625000.0
2005-06-29 10:00:00	QQQ	ETF	37.1	37.11	37.01	37.05	8568700.0
2005-06-29 10:30:00	QQQ	ETF	37.06	37.21	37.05	37.16	10132000.0
2005-06-29 11:00:00	QQQ	ETF	37.15	37.17	37.08	37.15	3021200.0
2005-06-29 11:30:00	QQQ	ETF	37.15	37.17	37.11	37.14	2204600.0
2005-06-29 12:00:00	QQQ	ETF	37.14	37.17	37.12	37.17	1043900.0
2005-06-29 12:30:00	QQQ	ETF	37.17	37.19	37.13	37.15	1257200.0
2005-06-29 13:00:00	QQQ	ETF	37.16	37.16	37.11	37.13	1074500.0
2005-06-29 13:30:00	QQQ	ETF	37.13	37.15	36.99	37.01	5975400.0
2005-06-29 14:00:00	QQQ	ETF	37.01	37.09	36.97	37.07	4938800.0
2005-06-29 14:30:00	QQQ	ETF	37.07	37.16	36.99	37.04	5637500.0
2005-06-29 15:00:00	QQQ	ETF	37.04	37.09	36.98	37.0	3592900.0
2005-06-29 15:30:00	QQQ	ETF	37.01	37.08	37.0	37.06	5562800.0
2005-06-29 08:00:00	IWM	ETF	63.74	63.83	63.74	63.83	200.0
2005-06-29 08:30:00	IWM	ETF	63.83	63.83	63.83	63.83	2000.0
2005-06-29 09:00:00	IWM	ETF	63.91	63.92	63.87	63.87	17400.0
2005-06-29 09:30:00	IWM	ETF	63.86	63.95	63.71	63.74	2445800.0
2005-06-29 10:00:00	IWM	ETF	63.76	63.89	63.69	63.87	2085500.0
2005-06-29 10:30:00	IWM	ETF	63.87	64.06	63.86	63.91	2300600.0
2005-06-29 11:00:00	IWM	ETF	63.9	64.0	63.88	63.98	453500.0
2005-06-29 11:30:00	IWM	ETF	63.98	64.04	63.91	63.94	351800.0
2005-06-29 12:00:00	IWM	ETF	63.922	63.95	63.85	63.9	639600.0
2005-06-29 12:30:00	IWM	ETF	63.89	63.99	63.82	63.89	907300.0
2005-06-29 13:00:00	IWM	ETF	63.89	63.94	63.83	63.86	847200.0
2005-06-29 13:30:00	IWM	ETF	63.86	63.88	63.63	63.69	1174300.0

> showing 50 of 1,551 rows — these rows as CSV

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