PREVIEW / etf_30min / 2006-06-14

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-14.parquet
  size:    70 KB
  rows:    2,474

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-14 05:00:00	SPY	ETF	123.09	123.09	123.09	123.09	100.0
2006-06-14 06:30:00	SPY	ETF	123.14	123.22	123.12	123.19	316200.0
2006-06-14 07:00:00	SPY	ETF	123.17	123.32	123.17	123.3	517900.0
2006-06-14 07:30:00	SPY	ETF	123.25	123.38	123.23	123.34	1039500.0
2006-06-14 08:00:00	SPY	ETF	123.33	123.36	122.95	123.05	3099400.0
2006-06-14 08:30:00	SPY	ETF	123.03	123.45	122.3	122.8	21176400.0
2006-06-14 09:00:00	SPY	ETF	122.78	122.96	122.5	122.85	2306100.0
2006-06-14 09:30:00	SPY	ETF	122.84	123.54	122.76	123.46	23595300.0
2006-06-14 10:00:00	SPY	ETF	123.42	123.63	123.03	123.26	12802900.0
2006-06-14 10:30:00	SPY	ETF	123.26	123.42	122.94	123.01	9656600.0
2006-06-14 11:00:00	SPY	ETF	123.03	123.25	122.8	123.18	10208500.0
2006-06-14 11:30:00	SPY	ETF	123.17	123.31	122.93	123.05	5418600.0
2006-06-14 12:00:00	SPY	ETF	123.05	123.47	122.94	123.13	5370000.0
2006-06-14 12:30:00	SPY	ETF	123.13	123.19	123.05	123.17	1868200.0
2006-06-14 13:00:00	SPY	ETF	123.17	123.18	122.55	122.72	8269400.0
2006-06-14 13:30:00	SPY	ETF	122.72	123.13	122.39	122.84	8287800.0
2006-06-14 14:00:00	SPY	ETF	122.86	123.22	122.68	122.86	9705300.0
2006-06-14 14:30:00	SPY	ETF	122.85	122.96	122.34	122.7	9828600.0
2006-06-14 15:00:00	SPY	ETF	122.7	122.89	122.57	122.74	7097300.0
2006-06-14 15:30:00	SPY	ETF	122.77	123.5	122.77	123.49	14325200.0
2006-06-14 16:00:00	SPY	ETF	123.49	123.5	123.33	123.45	2432800.0
2006-06-14 16:30:00	SPY	ETF	123.49	123.6	123.48	123.6	126500.0
2006-06-14 17:00:00	SPY	ETF	123.62	123.72	123.59	123.72	719900.0
2006-06-14 17:30:00	SPY	ETF	123.72	123.75	123.7	123.7	3400.0
2006-06-14 18:00:00	SPY	ETF	123.7	123.72	123.69	123.69	83100.0
2006-06-14 18:30:00	SPY	ETF	123.72	123.76	123.72	123.73	2300.0
2006-06-14 19:00:00	SPY	ETF	123.73	123.81	123.73	123.79	11200.0
2006-06-14 19:30:00	SPY	ETF	123.78	123.8	123.65	123.66	4500.0
2006-06-14 09:30:00	QQQ	ETF	37.36	37.63	37.33	37.56	30113500.0
2006-06-14 10:00:00	QQQ	ETF	37.56	37.66	37.5	37.52	12833600.0
2006-06-14 10:30:00	QQQ	ETF	37.53	37.59	37.41	37.45	11663600.0
2006-06-14 11:00:00	QQQ	ETF	37.44	37.58	37.35	37.53	17414300.0
2006-06-14 11:30:00	QQQ	ETF	37.53	37.61	37.45	37.49	7846100.0
2006-06-14 12:00:00	QQQ	ETF	37.5	37.6	37.43	37.52	6372900.0
2006-06-14 12:30:00	QQQ	ETF	37.52	37.53	37.45	37.5	3029500.0
2006-06-14 13:00:00	QQQ	ETF	37.51	37.51	37.29	37.36	11515000.0
2006-06-14 13:30:00	QQQ	ETF	37.35	37.45	37.22	37.44	10551500.0
2006-06-14 14:00:00	QQQ	ETF	37.43	37.57	37.35	37.45	15749100.0
2006-06-14 14:30:00	QQQ	ETF	37.46	37.48	37.2	37.33	20549600.0
2006-06-14 15:00:00	QQQ	ETF	37.33	37.44	37.31	37.37	8684000.0
2006-06-14 15:30:00	QQQ	ETF	37.37	37.71	37.37	37.64	17597200.0
2006-06-14 07:00:00	IWM	ETF	66.71	66.71	66.7	66.7	1500.0
2006-06-14 07:30:00	IWM	ETF	66.91	66.91	66.91	66.91	1100.0
2006-06-14 08:00:00	IWM	ETF	66.95	67.42	66.65	67.27	1714800.0
2006-06-14 08:30:00	IWM	ETF	67.27	67.27	66.48	66.89	4871000.0
2006-06-14 09:00:00	IWM	ETF	66.79	66.97	66.6	66.77	2474800.0
2006-06-14 09:30:00	IWM	ETF	66.76	67.57	66.62	67.46	15135800.0
2006-06-14 10:00:00	IWM	ETF	67.47	67.68	67.0	67.3	11888900.0
2006-06-14 10:30:00	IWM	ETF	67.3	67.53	67.0	67.12	7163200.0
2006-06-14 11:00:00	IWM	ETF	67.12	67.55	66.91	67.34	6184600.0

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

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