PREVIEW / etf_30min / 2006-07-10

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-10.parquet
  size:    74 KB
  rows:    2,639

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-07-10 06:00:00	SPY	ETF	126.92	126.92	126.87	126.87	10100.0
2006-07-10 06:30:00	SPY	ETF	126.94	126.94	126.94	126.94	25000.0
2006-07-10 07:00:00	SPY	ETF	126.9	126.98	126.9	126.97	6700.0
2006-07-10 07:30:00	SPY	ETF	127.0	127.12	127.0	127.08	60000.0
2006-07-10 08:00:00	SPY	ETF	127.08	127.17	126.94	127.12	975400.0
2006-07-10 08:30:00	SPY	ETF	127.11	127.11	126.7	126.9375	2083000.0
2006-07-10 09:00:00	SPY	ETF	126.9	127.05	126.61	126.93	2816700.0
2006-07-10 09:30:00	SPY	ETF	126.94	127.22	126.89	127.02	7427500.0
2006-07-10 10:00:00	SPY	ETF	127.01	127.33	127.01	127.19	5369200.0
2006-07-10 10:30:00	SPY	ETF	127.21	127.4	127.04	127.37	4908300.0
2006-07-10 11:00:00	SPY	ETF	127.37	127.43	127.14	127.25	2823100.0
2006-07-10 11:30:00	SPY	ETF	127.24	127.26	127.0	127.15	4451500.0
2006-07-10 12:00:00	SPY	ETF	127.15	127.15	126.9	127.04	3177400.0
2006-07-10 12:30:00	SPY	ETF	127.04	127.17	126.95	126.96	1666200.0
2006-07-10 13:00:00	SPY	ETF	126.96	127.14	126.77	126.84	4323800.0
2006-07-10 13:30:00	SPY	ETF	126.84	126.95	126.7	126.83	2046800.0
2006-07-10 14:00:00	SPY	ETF	126.83	126.97	126.71	126.74	2500200.0
2006-07-10 14:30:00	SPY	ETF	126.75	126.76	126.41	126.51	5509600.0
2006-07-10 15:00:00	SPY	ETF	126.5	126.85	126.43	126.76	6149600.0
2006-07-10 15:30:00	SPY	ETF	126.77	126.83	126.71	126.73	2558700.0
2006-07-10 16:00:00	SPY	ETF	126.74	126.89	126.47	126.85	559200.0
2006-07-10 16:30:00	SPY	ETF	126.81	126.83	126.78	126.79	111300.0
2006-07-10 17:00:00	SPY	ETF	126.78	126.78	126.75	126.77	36800.0
2006-07-10 17:30:00	SPY	ETF	126.77	126.77	126.75	126.75	2100.0
2006-07-10 18:00:00	SPY	ETF	126.75	126.78	126.73	126.74	11300.0
2006-07-10 18:30:00	SPY	ETF	126.71	126.73	126.71	126.73	8900.0
2006-07-10 19:00:00	SPY	ETF	126.74	126.75	126.74	126.75	3700.0
2006-07-10 09:30:00	QQQ	ETF	37.79	37.93	37.76	37.79	12128300.0
2006-07-10 10:00:00	QQQ	ETF	37.79	37.93	37.76	37.8	9193600.0
2006-07-10 10:30:00	QQQ	ETF	37.8	37.82	37.69	37.78	6833600.0
2006-07-10 11:00:00	QQQ	ETF	37.79	37.79	37.66	37.71	5424000.0
2006-07-10 11:30:00	QQQ	ETF	37.71	37.72	37.6	37.64	5033800.0
2006-07-10 12:00:00	QQQ	ETF	37.63	37.67	37.54	37.65	6642800.0
2006-07-10 12:30:00	QQQ	ETF	37.64	37.69	37.56	37.56	3315700.0
2006-07-10 13:00:00	QQQ	ETF	37.56	37.56	37.46	37.48	5365500.0
2006-07-10 13:30:00	QQQ	ETF	37.47	37.49	37.36	37.4	5802000.0
2006-07-10 14:00:00	QQQ	ETF	37.4	37.44	37.37	37.4	4492100.0
2006-07-10 14:30:00	QQQ	ETF	37.39	37.4	37.2	37.21	9937100.0
2006-07-10 15:00:00	QQQ	ETF	37.21	37.35	37.17	37.33	15275000.0
2006-07-10 15:30:00	QQQ	ETF	37.33	37.38	37.3	37.37	10491800.0
2006-07-10 08:00:00	IWM	ETF	70.87	70.95	70.81	70.82	66800.0
2006-07-10 08:30:00	IWM	ETF	70.85	70.86	70.72	70.75	15900.0
2006-07-10 09:00:00	IWM	ETF	70.72	70.79	70.59	70.66	564300.0
2006-07-10 09:30:00	IWM	ETF	70.66	70.9	70.5	70.82	3914600.0
2006-07-10 10:00:00	IWM	ETF	70.81	71.02	70.79	70.92	3015000.0
2006-07-10 10:30:00	IWM	ETF	70.91	71.21	70.69	71.17	2887500.0
2006-07-10 11:00:00	IWM	ETF	71.17	71.24	70.96	71.06	1687200.0
2006-07-10 11:30:00	IWM	ETF	71.06	71.07	70.88	71.0	1057000.0
2006-07-10 12:00:00	IWM	ETF	71.0	71.0	70.77	70.9	1769500.0
2006-07-10 12:30:00	IWM	ETF	70.91	71.0	70.72	70.81	3625700.0

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

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