PREVIEW / etf_30min / 2005-07-05

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-05.parquet
  size:    45 KB
  rows:    1,601

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-07-05 07:00:00	SPY	ETF	119.24	119.26	119.24	119.26	37900.0
2005-07-05 07:30:00	SPY	ETF	119.29	119.29	119.2	119.2	42300.0
2005-07-05 08:00:00	SPY	ETF	119.24	119.24	119.15	119.15	169200.0
2005-07-05 08:30:00	SPY	ETF	119.19	119.21	119.17	119.2	37100.0
2005-07-05 09:00:00	SPY	ETF	119.22	119.24	119.2	119.24	16300.0
2005-07-05 09:30:00	SPY	ETF	119.25	119.39	119.19	119.35	5059800.0
2005-07-05 10:00:00	SPY	ETF	119.36	119.93	119.29	119.92	7166400.0
2005-07-05 10:30:00	SPY	ETF	119.92	120.22	119.81	120.18	6425100.0
2005-07-05 11:00:00	SPY	ETF	120.18	120.28	120.05	120.2	2312900.0
2005-07-05 11:30:00	SPY	ETF	120.21	120.27	120.04	120.13	1674800.0
2005-07-05 12:00:00	SPY	ETF	120.13	120.53	120.12	120.47	2877400.0
2005-07-05 12:30:00	SPY	ETF	120.47	120.6	120.44	120.47	2710300.0
2005-07-05 13:00:00	SPY	ETF	120.47	120.48	120.31	120.31	2217500.0
2005-07-05 13:30:00	SPY	ETF	120.32	120.48	120.23	120.33	2187800.0
2005-07-05 14:00:00	SPY	ETF	120.33	120.4	120.13	120.26	2154500.0
2005-07-05 14:30:00	SPY	ETF	120.27	120.53	120.2	120.41	4498200.0
2005-07-05 15:00:00	SPY	ETF	120.41	120.48	120.29	120.33	1958000.0
2005-07-05 15:30:00	SPY	ETF	120.34	120.65	120.33	120.48	5979500.0
2005-07-05 16:00:00	SPY	ETF	120.47	120.52	119.998	120.51	2622700.0
2005-07-05 16:30:00	SPY	ETF	120.5	120.5	120.42	120.47	220400.0
2005-07-05 17:00:00	SPY	ETF	120.48	120.51	120.47	120.47	9200.0
2005-07-05 17:30:00	SPY	ETF	120.48	120.49	120.48	120.49	600.0
2005-07-05 18:00:00	SPY	ETF	120.49	120.49	120.49	120.49	100.0
2005-07-05 19:00:00	SPY	ETF	120.46	120.49	120.46	120.49	900.0
2005-07-05 19:30:00	SPY	ETF	120.47	120.5	120.47	120.5	1000.0
2005-07-05 09:30:00	QQQ	ETF	36.63	36.71	36.6	36.67	8345700.0
2005-07-05 10:00:00	QQQ	ETF	36.68	36.99	36.65	36.98	14541000.0
2005-07-05 10:30:00	QQQ	ETF	36.98	37.14	36.98	37.08	9548100.0
2005-07-05 11:00:00	QQQ	ETF	37.08	37.1	37.01	37.07	3544500.0
2005-07-05 11:30:00	QQQ	ETF	37.07	37.09	36.96	37.02	3562700.0
2005-07-05 12:00:00	QQQ	ETF	37.02	37.13	37.02	37.11	3680600.0
2005-07-05 12:30:00	QQQ	ETF	37.11	37.19	37.1	37.16	4629200.0
2005-07-05 13:00:00	QQQ	ETF	37.16	37.17	37.09	37.09	2627200.0
2005-07-05 13:30:00	QQQ	ETF	37.09	37.14	37.05	37.11	1945500.0
2005-07-05 14:00:00	QQQ	ETF	37.1	37.14	37.06	37.08	3044700.0
2005-07-05 14:30:00	QQQ	ETF	37.09	37.17	37.05	37.12	2791200.0
2005-07-05 15:00:00	QQQ	ETF	37.12	37.14	37.07	37.11	2735500.0
2005-07-05 15:30:00	QQQ	ETF	37.1	37.18	37.08	37.1	5225700.0
2005-07-05 07:30:00	IWM	ETF	63.77	63.77	63.77	63.77	100.0
2005-07-05 08:00:00	IWM	ETF	63.83	63.85	63.83	63.85	41600.0
2005-07-05 08:30:00	IWM	ETF	63.75	63.8	63.75	63.8	6200.0
2005-07-05 09:00:00	IWM	ETF	63.83	63.84	63.81	63.83	7500.0
2005-07-05 09:30:00	IWM	ETF	63.81	63.97	63.76	63.9	3229200.0
2005-07-05 10:00:00	IWM	ETF	63.9	64.29	63.83	64.29	2773600.0
2005-07-05 10:30:00	IWM	ETF	64.29	64.51	64.28	64.45	2870500.0
2005-07-05 11:00:00	IWM	ETF	64.46	64.48	64.36	64.46	837800.0
2005-07-05 11:30:00	IWM	ETF	64.46	64.46	64.33	64.4	764600.0
2005-07-05 12:00:00	IWM	ETF	64.4	64.75	64.4	64.7	1829600.0
2005-07-05 12:30:00	IWM	ETF	64.7	64.8	64.63	64.75	2501800.0
2005-07-05 13:00:00	IWM	ETF	64.75	64.82	64.73	64.76	1067100.0

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

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