PREVIEW / etf_30min / 2006-06-05

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-05.parquet
  size:    69 KB
  rows:    2,392

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-06-05 06:30:00	SPY	ETF	128.8	128.8	128.74	128.74	1600.0
2006-06-05 07:00:00	SPY	ETF	128.84	128.87	128.78	128.8	5100.0
2006-06-05 07:30:00	SPY	ETF	128.81	128.81	128.71	128.74	48300.0
2006-06-05 08:00:00	SPY	ETF	128.87	129.0	128.58	128.71	649400.0
2006-06-05 08:30:00	SPY	ETF	128.71	128.8	128.71	128.8	564100.0
2006-06-05 09:00:00	SPY	ETF	128.79	128.81	128.78	128.79	643300.0
2006-06-05 09:30:00	SPY	ETF	128.79	128.86	128.47	128.64	9945100.0
2006-06-05 10:00:00	SPY	ETF	128.64	128.76	128.45	128.65	3582700.0
2006-06-05 10:30:00	SPY	ETF	128.65	128.79	128.61	128.68	2313900.0
2006-06-05 11:00:00	SPY	ETF	128.67	128.79	128.61	128.63	3028000.0
2006-06-05 11:30:00	SPY	ETF	128.63	128.71	128.52	128.56	1903400.0
2006-06-05 12:00:00	SPY	ETF	128.57	128.61	128.4	128.43	2978200.0
2006-06-05 12:30:00	SPY	ETF	128.43	128.54	128.37	128.49	2030700.0
2006-06-05 13:00:00	SPY	ETF	128.48	128.56	128.34	128.42	2289300.0
2006-06-05 13:30:00	SPY	ETF	128.42	128.5	128.21	128.26	3792700.0
2006-06-05 14:00:00	SPY	ETF	128.26	128.29	127.53	127.82	15590700.0
2006-06-05 14:30:00	SPY	ETF	127.83	128.32	127.33	127.6	6811900.0
2006-06-05 15:00:00	SPY	ETF	127.57	127.86	127.11	127.19	9003800.0
2006-06-05 15:30:00	SPY	ETF	127.19	127.39	126.77	126.91	13809900.0
2006-06-05 16:00:00	SPY	ETF	126.91	127.18	126.68	127.12	1410100.0
2006-06-05 16:30:00	SPY	ETF	127.13	127.3	126.87	127.18	2150200.0
2006-06-05 17:00:00	SPY	ETF	127.18	127.2	127.18	127.2	9300.0
2006-06-05 17:30:00	SPY	ETF	127.23	127.34	127.2	127.2	23400.0
2006-06-05 18:00:00	SPY	ETF	127.18	127.2	127.13	127.13	13700.0
2006-06-05 19:00:00	SPY	ETF	127.21	127.21	127.21	127.21	100.0
2006-06-05 19:30:00	SPY	ETF	127.21	127.24	127.21	127.23	25200.0
2006-06-05 09:30:00	QQQ	ETF	39.55	39.56	39.34	39.4	10554500.0
2006-06-05 10:00:00	QQQ	ETF	39.41	39.54	39.35	39.49	6689300.0
2006-06-05 10:30:00	QQQ	ETF	39.49	39.54	39.43	39.49	3192400.0
2006-06-05 11:00:00	QQQ	ETF	39.48	39.55	39.46	39.48	4511000.0
2006-06-05 11:30:00	QQQ	ETF	39.47	39.47	39.42	39.45	3058500.0
2006-06-05 12:00:00	QQQ	ETF	39.45	39.45	39.29	39.3	10131000.0
2006-06-05 12:30:00	QQQ	ETF	39.3	39.38	39.28	39.33	3768700.0
2006-06-05 13:00:00	QQQ	ETF	39.33	39.38	39.26	39.28	3630300.0
2006-06-05 13:30:00	QQQ	ETF	39.28	39.32	39.23	39.25	4004300.0
2006-06-05 14:00:00	QQQ	ETF	39.25	39.25	38.97	39.08	15088600.0
2006-06-05 14:30:00	QQQ	ETF	39.09	39.09	38.9	39.02	10050500.0
2006-06-05 15:00:00	QQQ	ETF	39.01	39.02	38.84	38.87	10327500.0
2006-06-05 15:30:00	QQQ	ETF	38.86	38.93	38.78	38.79	12317000.0
2006-06-05 08:00:00	IWM	ETF	73.05	73.23	72.95	72.97	585700.0
2006-06-05 08:30:00	IWM	ETF	72.97	73.03	72.95	73.02	168300.0
2006-06-05 09:00:00	IWM	ETF	73.03	73.05	73.0	73.04	146000.0
2006-06-05 09:30:00	IWM	ETF	73.06	73.15	72.74	72.89	4014300.0
2006-06-05 10:00:00	IWM	ETF	72.9	72.99	72.71	72.89	2151100.0
2006-06-05 10:30:00	IWM	ETF	72.9	73.0	72.84	72.95	1416500.0
2006-06-05 11:00:00	IWM	ETF	72.96	73.08	72.75	72.77	2547200.0
2006-06-05 11:30:00	IWM	ETF	72.78	72.79	72.61	72.66	2437100.0
2006-06-05 12:00:00	IWM	ETF	72.66	72.66	72.29	72.31	2858000.0
2006-06-05 12:30:00	IWM	ETF	72.31	72.4	72.26	72.29	2064300.0
2006-06-05 13:00:00	IWM	ETF	72.3	72.38	72.21	72.26	1895100.0

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

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