PREVIEW / etf_30min / 2006-01-13

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-13.parquet
  size:    57 KB
  rows:    2,077

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
2006-01-13 07:00:00	SPY	ETF	128.65	128.66	128.65	128.65	9800.0
2006-01-13 07:30:00	SPY	ETF	128.66	128.67	128.62	128.65	155900.0
2006-01-13 08:00:00	SPY	ETF	128.65	128.71	128.61	128.71	332900.0
2006-01-13 08:30:00	SPY	ETF	128.61	128.76	128.55	128.65	911100.0
2006-01-13 09:00:00	SPY	ETF	128.65	128.66	128.55	128.55	313300.0
2006-01-13 09:30:00	SPY	ETF	128.57	128.81	128.57	128.71	2885100.0
2006-01-13 10:00:00	SPY	ETF	128.71	128.79	128.48	128.59	4997700.0
2006-01-13 10:30:00	SPY	ETF	128.59	128.69	128.41	128.64	3181900.0
2006-01-13 11:00:00	SPY	ETF	128.64	128.82	128.58	128.77	3086300.0
2006-01-13 11:30:00	SPY	ETF	128.78	128.9	128.41	128.67	2943300.0
2006-01-13 12:00:00	SPY	ETF	128.67	128.74	128.61	128.71	1148800.0
2006-01-13 12:30:00	SPY	ETF	128.7	128.7	128.27	128.37	4817400.0
2006-01-13 13:00:00	SPY	ETF	128.37	128.55	128.34	128.51	1883200.0
2006-01-13 13:30:00	SPY	ETF	128.52	128.52	128.31	128.47	2326400.0
2006-01-13 14:00:00	SPY	ETF	128.47	128.49	128.2	128.36	2890300.0
2006-01-13 14:30:00	SPY	ETF	128.37	128.7	128.33	128.61	2968400.0
2006-01-13 15:00:00	SPY	ETF	128.61	128.63	128.47	128.6	2462200.0
2006-01-13 15:30:00	SPY	ETF	128.58	128.74	128.55	128.7	3279500.0
2006-01-13 16:00:00	SPY	ETF	128.69	128.72	128.53	128.68	1172600.0
2006-01-13 16:30:00	SPY	ETF	128.62	128.64	128.61	128.62	6900.0
2006-01-13 18:00:00	SPY	ETF	128.65	128.65	128.63	128.63	2200.0
2006-01-13 18:30:00	SPY	ETF	128.65	128.65	128.65	128.65	2000.0
2006-01-13 19:00:00	SPY	ETF	128.65	128.65	128.65	128.65	3600.0
2006-01-13 19:30:00	SPY	ETF	128.65	128.65	128.65	128.65	400.0
2006-01-13 09:30:00	QQQ	ETF	42.94	43.02	42.92	42.97	9282000.0
2006-01-13 10:00:00	QQQ	ETF	42.97	42.97	42.85	42.91	7119300.0
2006-01-13 10:30:00	QQQ	ETF	42.91	42.97	42.79	42.94	4635100.0
2006-01-13 11:00:00	QQQ	ETF	42.94	43.01	42.9	43.0	6654700.0
2006-01-13 11:30:00	QQQ	ETF	43.0	43.05	42.93	42.95	4409000.0
2006-01-13 12:00:00	QQQ	ETF	42.96	42.99	42.92	42.95	1240900.0
2006-01-13 12:30:00	QQQ	ETF	42.96	42.96	42.82	42.88	2351200.0
2006-01-13 13:00:00	QQQ	ETF	42.87	42.9	42.82	42.88	1994300.0
2006-01-13 13:30:00	QQQ	ETF	42.89	42.89	42.79	42.86	2949000.0
2006-01-13 14:00:00	QQQ	ETF	42.86	42.88	42.73	42.79	6458500.0
2006-01-13 14:30:00	QQQ	ETF	42.79	42.97	42.79	42.92	4365300.0
2006-01-13 15:00:00	QQQ	ETF	42.93	42.94	42.82	42.9	3427000.0
2006-01-13 15:30:00	QQQ	ETF	42.9	42.98	42.82	42.97	4849000.0
2006-01-13 08:30:00	IWM	ETF	70.23	70.3	70.22	70.27	12500.0
2006-01-13 09:00:00	IWM	ETF	70.27	70.28	70.22	70.24	11600.0
2006-01-13 09:30:00	IWM	ETF	70.27	70.47	70.27	70.34	1705000.0
2006-01-13 10:00:00	IWM	ETF	70.34	70.37	70.1	70.13	3950300.0
2006-01-13 10:30:00	IWM	ETF	70.14	70.24	70.07	70.22	2789400.0
2006-01-13 11:00:00	IWM	ETF	70.23	70.36	70.19	70.33	1122400.0
2006-01-13 11:30:00	IWM	ETF	70.33	70.4	70.26	70.29	950300.0
2006-01-13 12:00:00	IWM	ETF	70.29	70.37	70.26	70.32	394300.0
2006-01-13 12:30:00	IWM	ETF	70.311	70.32	70.02	70.09	1390300.0
2006-01-13 13:00:00	IWM	ETF	70.1	70.21	70.06	70.18	412600.0
2006-01-13 13:30:00	IWM	ETF	70.17	70.22	70.06	70.2	805600.0
2006-01-13 14:00:00	IWM	ETF	70.2	70.22	70.09	70.15	1731400.0
2006-01-13 14:30:00	IWM	ETF	70.15	70.45	70.14	70.36	1551900.0

> showing 50 of 2,077 rows — these rows as CSV

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