PREVIEW / etf_30min / 2006-01-31

all etf 30-min files

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

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-31 05:30:00	SPY	ETF	128.47	128.47	128.47	128.47	200.0
2006-01-31 07:00:00	SPY	ETF	128.34	128.43	128.34	128.42	7200.0
2006-01-31 07:30:00	SPY	ETF	128.4	128.4	128.3	128.3	82300.0
2006-01-31 08:00:00	SPY	ETF	128.3	128.43	128.3	128.31	62300.0
2006-01-31 08:30:00	SPY	ETF	128.34	128.36	128.26	128.33	399100.0
2006-01-31 09:00:00	SPY	ETF	128.33	128.38	128.3	128.34	424500.0
2006-01-31 09:30:00	SPY	ETF	128.32	128.38	128.08	128.15	6934700.0
2006-01-31 10:00:00	SPY	ETF	128.14	128.25	127.92	127.98	6158900.0
2006-01-31 10:30:00	SPY	ETF	127.97	128.09	127.93	128.07	3089500.0
2006-01-31 11:00:00	SPY	ETF	128.07	128.1	127.93	128.02	1858300.0
2006-01-31 11:30:00	SPY	ETF	128.02	128.15	127.94	127.99	1392800.0
2006-01-31 12:00:00	SPY	ETF	127.98	128.07	127.9	127.99	904400.0
2006-01-31 12:30:00	SPY	ETF	127.97	128.08	127.97	128.05	679400.0
2006-01-31 13:00:00	SPY	ETF	128.05	128.08	127.98	127.99	977200.0
2006-01-31 13:30:00	SPY	ETF	127.98	128.29	127.96	128.18	2877700.0
2006-01-31 14:00:00	SPY	ETF	128.18	128.43	127.66	127.92	13984200.0
2006-01-31 14:30:00	SPY	ETF	127.92	128.37	127.75	128.3	10263600.0
2006-01-31 15:00:00	SPY	ETF	128.27	128.51	128.2	128.45	5594000.0
2006-01-31 15:30:00	SPY	ETF	128.45	128.54	127.93	127.94	6800300.0
2006-01-31 16:00:00	SPY	ETF	127.94	128.04	127.5	127.56	1959100.0
2006-01-31 16:30:00	SPY	ETF	127.57	127.68	127.4	127.47	950100.0
2006-01-31 17:00:00	SPY	ETF	127.47	127.6	127.29	127.45	4865700.0
2006-01-31 17:30:00	SPY	ETF	127.43	127.49	127.34	127.49	61500.0
2006-01-31 18:00:00	SPY	ETF	127.51	127.63	127.44	127.58	141900.0
2006-01-31 18:30:00	SPY	ETF	127.53	127.53	127.53	127.53	13400.0
2006-01-31 19:00:00	SPY	ETF	127.55	127.55	127.53	127.54	3200.0
2006-01-31 19:30:00	SPY	ETF	127.56	127.61	127.53	127.58	16800.0
2006-01-31 09:30:00	QQQ	ETF	42.14	42.19	41.91	41.96	9598400.0
2006-01-31 10:00:00	QQQ	ETF	41.95	41.98	41.81	41.85	7571000.0
2006-01-31 10:30:00	QQQ	ETF	41.86	41.97	41.83	41.95	3214100.0
2006-01-31 11:00:00	QQQ	ETF	41.96	41.97	41.91	41.95	2944900.0
2006-01-31 11:30:00	QQQ	ETF	41.94	42.02	41.91	41.95	2738500.0
2006-01-31 12:00:00	QQQ	ETF	41.95	42.0	41.95	41.97	1156700.0
2006-01-31 12:30:00	QQQ	ETF	41.96	42.0	41.94	41.97	2121500.0
2006-01-31 13:00:00	QQQ	ETF	41.97	41.99	41.94	41.96	2136500.0
2006-01-31 13:30:00	QQQ	ETF	41.95	42.09	41.95	42.05	3662200.0
2006-01-31 14:00:00	QQQ	ETF	42.04	42.14	41.82	41.94	14092400.0
2006-01-31 14:30:00	QQQ	ETF	41.95	42.1	41.88	42.1	7240700.0
2006-01-31 15:00:00	QQQ	ETF	42.11	42.27	42.1	42.21	12589500.0
2006-01-31 15:30:00	QQQ	ETF	42.21	42.24	42.0	42.01	8998200.0
2006-01-31 07:30:00	IWM	ETF	72.5	72.52	72.5	72.52	17000.0
2006-01-31 08:00:00	IWM	ETF	72.52	72.52	72.44	72.45	285200.0
2006-01-31 08:30:00	IWM	ETF	72.45	72.45	72.38	72.43	18600.0
2006-01-31 09:00:00	IWM	ETF	72.44	72.48	72.44	72.46	285200.0
2006-01-31 09:30:00	IWM	ETF	72.48	72.48	72.24	72.3	2598200.0
2006-01-31 10:00:00	IWM	ETF	72.3	72.35	72.13	72.23	2689000.0
2006-01-31 10:30:00	IWM	ETF	72.23	72.33	72.21	72.32	1169500.0
2006-01-31 11:00:00	IWM	ETF	72.32	72.34	72.25	72.31	1774000.0
2006-01-31 11:30:00	IWM	ETF	72.3	72.54	72.3	72.46	2296700.0
2006-01-31 12:00:00	IWM	ETF	72.46	72.5	72.4	72.48	911500.0

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

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