PREVIEW / etf_30min / 2006-01-17

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-17.parquet
  size:    59 KB
  rows:    2,156

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-17 04:30:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2006-01-17 06:30:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2006-01-17 07:00:00	SPY	ETF	128.25	128.26	128.25	128.26	6100.0
2006-01-17 07:30:00	SPY	ETF	128.2	128.22	128.17	128.22	85000.0
2006-01-17 08:00:00	SPY	ETF	128.69	128.74	128.06	128.1	1697900.0
2006-01-17 08:30:00	SPY	ETF	128.09	128.19	128.07	128.19	242900.0
2006-01-17 09:00:00	SPY	ETF	128.19	128.26	128.16	128.19	1286000.0
2006-01-17 09:30:00	SPY	ETF	128.2	128.35	128.06	128.23	6204000.0
2006-01-17 10:00:00	SPY	ETF	128.24	128.31	128.04	128.25	5062300.0
2006-01-17 10:30:00	SPY	ETF	128.25	128.26	128.0	128.15	4874300.0
2006-01-17 11:00:00	SPY	ETF	128.15	128.3	128.08	128.17	2106900.0
2006-01-17 11:30:00	SPY	ETF	128.16	128.2	128.07	128.13	1226200.0
2006-01-17 12:00:00	SPY	ETF	128.14	128.19	127.87	127.89	4362900.0
2006-01-17 12:30:00	SPY	ETF	127.88	128.17	127.81	127.99	3015500.0
2006-01-17 13:00:00	SPY	ETF	127.97	127.99	127.81	127.97	2155200.0
2006-01-17 13:30:00	SPY	ETF	127.97	128.31	127.89	128.19	2902100.0
2006-01-17 14:00:00	SPY	ETF	128.19	128.42	128.03	128.06	3253000.0
2006-01-17 14:30:00	SPY	ETF	128.07	128.3	128.02	128.29	2411700.0
2006-01-17 15:00:00	SPY	ETF	128.29	128.36	128.23	128.27	2535900.0
2006-01-17 15:30:00	SPY	ETF	128.25	128.31	128.16	128.25	3730400.0
2006-01-17 16:00:00	SPY	ETF	128.26	128.4	128.0	128.05	1160300.0
2006-01-17 16:30:00	SPY	ETF	128.06	128.06	127.66	127.67	1612100.0
2006-01-17 17:00:00	SPY	ETF	127.69	127.71	127.63	127.69	135500.0
2006-01-17 17:30:00	SPY	ETF	127.74	127.75	127.55	127.61	128300.0
2006-01-17 18:00:00	SPY	ETF	127.66	127.73	127.61	127.7	31500.0
2006-01-17 18:30:00	SPY	ETF	127.7	127.72	127.67	127.67	2100.0
2006-01-17 19:00:00	SPY	ETF	127.65	127.65	127.53	127.53	4900.0
2006-01-17 19:30:00	SPY	ETF	127.53	127.58	127.51	127.58	1900.0
2006-01-17 09:30:00	QQQ	ETF	42.66	42.75	42.61	42.69	9335000.0
2006-01-17 10:00:00	QQQ	ETF	42.69	42.79	42.63	42.77	7524700.0
2006-01-17 10:30:00	QQQ	ETF	42.77	42.78	42.6	42.67	4920600.0
2006-01-17 11:00:00	QQQ	ETF	42.68	42.75	42.65	42.69	4448500.0
2006-01-17 11:30:00	QQQ	ETF	42.69	42.71	42.63	42.68	1808400.0
2006-01-17 12:00:00	QQQ	ETF	42.68	42.7	42.61	42.61	1831200.0
2006-01-17 12:30:00	QQQ	ETF	42.61	42.66	42.61	42.63	2622100.0
2006-01-17 13:00:00	QQQ	ETF	42.63	42.64	42.5	42.56	5251000.0
2006-01-17 13:30:00	QQQ	ETF	42.57	42.68	42.54	42.64	3854300.0
2006-01-17 14:00:00	QQQ	ETF	42.65	42.75	42.6	42.61	4785900.0
2006-01-17 14:30:00	QQQ	ETF	42.61	42.72	42.6	42.71	3973100.0
2006-01-17 15:00:00	QQQ	ETF	42.72	42.73	42.67	42.68	2517300.0
2006-01-17 15:30:00	QQQ	ETF	42.68	42.74	42.63	42.73	5616200.0
2006-01-17 07:00:00	IWM	ETF	70.02	70.02	70.02	70.02	1000.0
2006-01-17 07:30:00	IWM	ETF	70.01	70.01	69.98	69.98	800.0
2006-01-17 08:00:00	IWM	ETF	69.95	69.98	69.88	69.9	148500.0
2006-01-17 08:30:00	IWM	ETF	69.88	69.9	69.82	69.88	185800.0
2006-01-17 09:00:00	IWM	ETF	69.91	69.99	69.87	69.98	410100.0
2006-01-17 09:30:00	IWM	ETF	69.98	70.01	69.79	69.87	4476000.0
2006-01-17 10:00:00	IWM	ETF	69.86	70.0	69.74	69.92	2158300.0
2006-01-17 10:30:00	IWM	ETF	69.92	69.95	69.72	69.89	1429100.0
2006-01-17 11:00:00	IWM	ETF	69.91	70.05	69.88	69.93	922900.0

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

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