PREVIEW / etf_30min / 2006-07-18

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-18.parquet
  size:    78 KB
  rows:    2,675

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-18 04:30:00	SPY	ETF	123.04	123.04	123.04	123.04	2000.0
2006-07-18 05:30:00	SPY	ETF	123.2	123.2	123.2	123.2	2000.0
2006-07-18 06:30:00	SPY	ETF	123.1	123.1	123.1	123.1	400.0
2006-07-18 07:00:00	SPY	ETF	123.1	123.4	123.08	123.4	54800.0
2006-07-18 07:30:00	SPY	ETF	123.41	123.43	123.27	123.33	80300.0
2006-07-18 08:00:00	SPY	ETF	123.12	123.55	123.08	123.52	1938500.0
2006-07-18 08:30:00	SPY	ETF	123.51	123.62	123.23	123.57	2304400.0
2006-07-18 09:00:00	SPY	ETF	123.56	123.76	123.53	123.76	1612200.0
2006-07-18 09:30:00	SPY	ETF	123.74	124.05	123.71	123.93	11493500.0
2006-07-18 10:00:00	SPY	ETF	123.92	123.93	123.45	123.6212	10053000.0
2006-07-18 10:30:00	SPY	ETF	123.63	123.65	123.11	123.15	5827400.0
2006-07-18 11:00:00	SPY	ETF	123.15	123.26	122.94	123.17	8989900.0
2006-07-18 11:30:00	SPY	ETF	123.17	123.43	123.15	123.29	4957100.0
2006-07-18 12:00:00	SPY	ETF	123.29	123.34	123.08	123.3	3883100.0
2006-07-18 12:30:00	SPY	ETF	123.32	123.49	123.01	123.12	5875900.0
2006-07-18 13:00:00	SPY	ETF	123.13	123.14	122.64	122.8	9684800.0
2006-07-18 13:30:00	SPY	ETF	122.8	122.93	122.48	122.59	7075000.0
2006-07-18 14:00:00	SPY	ETF	122.58	123.22	122.56	123.06	9102300.0
2006-07-18 14:30:00	SPY	ETF	123.11	123.52	122.39	123.29	12080400.0
2006-07-18 15:00:00	SPY	ETF	123.3	123.3	122.77	123.07	7525900.0
2006-07-18 15:30:00	SPY	ETF	123.07	123.89	123.06	123.68	13303900.0
2006-07-18 16:00:00	SPY	ETF	123.66	124.02	123.63	123.98	1930100.0
2006-07-18 16:30:00	SPY	ETF	123.98	124.0	123.8	123.92	1205700.0
2006-07-18 17:00:00	SPY	ETF	123.93	123.93	123.8	123.84	1433000.0
2006-07-18 17:30:00	SPY	ETF	123.82	123.85	123.79	123.82	36400.0
2006-07-18 18:00:00	SPY	ETF	123.87	123.94	123.87	123.88	33400.0
2006-07-18 18:30:00	SPY	ETF	123.88	123.88	123.82	123.82	900.0
2006-07-18 19:00:00	SPY	ETF	123.84	123.87	123.82	123.87	8000.0
2006-07-18 19:30:00	SPY	ETF	123.84	123.84	123.84	123.84	1300.0
2006-07-18 09:30:00	QQQ	ETF	36.22	36.33	36.16	36.24	23738900.0
2006-07-18 10:00:00	QQQ	ETF	36.24	36.25	35.96	36.05	15765200.0
2006-07-18 10:30:00	QQQ	ETF	36.05	36.08	35.86	35.89	13582100.0
2006-07-18 11:00:00	QQQ	ETF	35.88	35.91	35.78	35.88	11107500.0
2006-07-18 11:30:00	QQQ	ETF	35.88	35.99	35.85	35.91	7521100.0
2006-07-18 12:00:00	QQQ	ETF	35.92	35.95	35.83	35.94	4781500.0
2006-07-18 12:30:00	QQQ	ETF	35.93	36.07	35.8	35.84	10983100.0
2006-07-18 13:00:00	QQQ	ETF	35.84	36.03	35.61	35.7	11109100.0
2006-07-18 13:30:00	QQQ	ETF	35.7	35.75	35.54	35.63	22386600.0
2006-07-18 14:00:00	QQQ	ETF	35.63	35.86	35.61	35.79	16837200.0
2006-07-18 14:30:00	QQQ	ETF	35.79	35.98	35.76	35.89	21659000.0
2006-07-18 15:00:00	QQQ	ETF	35.9	35.9	35.72	35.87	9589900.0
2006-07-18 15:30:00	QQQ	ETF	35.87	36.22	35.87	36.14	22739900.0
2006-07-18 07:00:00	IWM	ETF	67.44	67.48	67.44	67.48	20000.0
2006-07-18 08:00:00	IWM	ETF	67.5	67.7	67.44	67.7	809200.0
2006-07-18 08:30:00	IWM	ETF	67.74	67.77	67.57	67.73	2031000.0
2006-07-18 09:00:00	IWM	ETF	67.71	67.86	67.7	67.82	638200.0
2006-07-18 09:30:00	IWM	ETF	67.82	68.25	67.76	68.0	8843900.0
2006-07-18 10:00:00	IWM	ETF	68.0	68.0	67.59	67.65	6426800.0
2006-07-18 10:30:00	IWM	ETF	67.66	67.67	67.22	67.26	3383300.0
2006-07-18 11:00:00	IWM	ETF	67.25	67.25	67.0	67.2	3359500.0

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

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