PREVIEW / etf_30min / 2006-01-27

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-27.parquet
  size:    60 KB
  rows:    2,140

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-27 04:00:00	SPY	ETF	127.82	127.82	127.82	127.82	50000.0
2006-01-27 04:30:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2006-01-27 06:30:00	SPY	ETF	127.77	127.77	127.77	127.77	100.0
2006-01-27 07:00:00	SPY	ETF	127.79	127.86	127.79	127.82	22700.0
2006-01-27 07:30:00	SPY	ETF	127.82	127.83	127.74	127.83	96200.0
2006-01-27 08:00:00	SPY	ETF	127.86	127.95	127.74	127.89	505300.0
2006-01-27 08:30:00	SPY	ETF	127.89	127.89	127.36	127.47	1858900.0
2006-01-27 09:00:00	SPY	ETF	127.44	127.65	127.43	127.65	912200.0
2006-01-27 09:30:00	SPY	ETF	127.66	127.93	127.45	127.91	7204100.0
2006-01-27 10:00:00	SPY	ETF	127.88	128.63	127.86	128.38	13034400.0
2006-01-27 10:30:00	SPY	ETF	128.38	128.43	128.22	128.34	6401800.0
2006-01-27 11:00:00	SPY	ETF	128.33	128.4	128.25	128.4	3002400.0
2006-01-27 11:30:00	SPY	ETF	128.39	128.56	128.25	128.45	2230900.0
2006-01-27 12:00:00	SPY	ETF	128.45	128.66	128.42	128.51	4237500.0
2006-01-27 12:30:00	SPY	ETF	128.52	128.56	128.44	128.48	1241700.0
2006-01-27 13:00:00	SPY	ETF	128.48	128.49	128.14	128.21	3188100.0
2006-01-27 13:30:00	SPY	ETF	128.2	128.54	127.93	128.14	4768300.0
2006-01-27 14:00:00	SPY	ETF	128.16	128.3	128.05	128.27	2303400.0
2006-01-27 14:30:00	SPY	ETF	128.27	128.3	128.08	128.29	2481200.0
2006-01-27 15:00:00	SPY	ETF	128.29	128.48	128.21	128.38	3439800.0
2006-01-27 15:30:00	SPY	ETF	128.38	128.46	128.26	128.32	5835000.0
2006-01-27 16:00:00	SPY	ETF	128.3	128.57	128.3	128.51	628100.0
2006-01-27 16:30:00	SPY	ETF	128.56	128.58	128.53	128.54	161400.0
2006-01-27 17:00:00	SPY	ETF	128.57	128.59	128.55	128.55	6300.0
2006-01-27 17:30:00	SPY	ETF	128.53	128.65	128.53	128.54	15100.0
2006-01-27 18:00:00	SPY	ETF	128.53	128.53	128.48	128.48	19400.0
2006-01-27 18:30:00	SPY	ETF	128.44	128.44	128.4	128.4	4000.0
2006-01-27 09:30:00	QQQ	ETF	41.81	42.09	41.74	42.06	21871100.0
2006-01-27 10:00:00	QQQ	ETF	42.05	42.39	42.03	42.22	18242400.0
2006-01-27 10:30:00	QQQ	ETF	42.22	42.22	42.12	42.15	6713500.0
2006-01-27 11:00:00	QQQ	ETF	42.15	42.19	42.05	42.11	4966100.0
2006-01-27 11:30:00	QQQ	ETF	42.14	42.2	42.08	42.16	3715700.0
2006-01-27 12:00:00	QQQ	ETF	42.16	42.23	42.14	42.16	2995000.0
2006-01-27 12:30:00	QQQ	ETF	42.17	42.17	42.12	42.15	2153500.0
2006-01-27 13:00:00	QQQ	ETF	42.14	42.15	41.98	42.0	4802400.0
2006-01-27 13:30:00	QQQ	ETF	42.0	42.0	41.87	41.92	6448900.0
2006-01-27 14:00:00	QQQ	ETF	41.92	42.02	41.89	42.0	5188400.0
2006-01-27 14:30:00	QQQ	ETF	42.01	42.01	41.89	41.96	4296900.0
2006-01-27 15:00:00	QQQ	ETF	41.97	42.08	41.94	42.05	5554100.0
2006-01-27 15:30:00	QQQ	ETF	42.06	42.11	42.0	42.1	7756600.0
2006-01-27 06:30:00	IWM	ETF	72.7	72.7	72.7	72.7	100.0
2006-01-27 07:00:00	IWM	ETF	72.66	72.7	72.66	72.7	20600.0
2006-01-27 07:30:00	IWM	ETF	72.7	72.7	72.7	72.7	3000.0
2006-01-27 08:00:00	IWM	ETF	72.72	72.81	72.67	72.75	146200.0
2006-01-27 08:30:00	IWM	ETF	72.67	72.71	72.46	72.53	98800.0
2006-01-27 09:00:00	IWM	ETF	72.52	72.54	72.46	72.52	59200.0
2006-01-27 09:30:00	IWM	ETF	72.54	72.67	72.26	72.64	2914500.0
2006-01-27 10:00:00	IWM	ETF	72.64	73.24	72.62	73.07	6537600.0
2006-01-27 10:30:00	IWM	ETF	73.08	73.1	72.96	72.98	2657800.0
2006-01-27 11:00:00	IWM	ETF	72.98	73.01	72.83	72.95	1706500.0

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

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