PREVIEW / etf_30min / 2006-06-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-20.parquet
  size:    66 KB
  rows:    2,353

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-20 04:00:00	SPY	ETF	124.1	124.1	124.1	124.1	100.0
2006-06-20 05:00:00	SPY	ETF	123.92	123.97	123.92	123.97	7500.0
2006-06-20 06:30:00	SPY	ETF	123.89	123.89	123.89	123.89	1500.0
2006-06-20 07:00:00	SPY	ETF	123.96	124.0	123.96	124.0	5200.0
2006-06-20 07:30:00	SPY	ETF	123.85	123.86	123.73	123.77	51600.0
2006-06-20 08:00:00	SPY	ETF	123.67	123.97	123.63	123.63	749800.0
2006-06-20 08:30:00	SPY	ETF	123.62	123.9	123.6	123.89	883000.0
2006-06-20 09:00:00	SPY	ETF	123.9	124.98	123.8	124.01	584700.0
2006-06-20 09:30:00	SPY	ETF	124.01	124.23	123.72	123.8	8261900.0
2006-06-20 10:00:00	SPY	ETF	123.8	124.18	123.72	123.96	6471900.0
2006-06-20 10:30:00	SPY	ETF	123.96	124.26	123.96	124.15	4478700.0
2006-06-20 11:00:00	SPY	ETF	124.15	124.68	124.07	124.64	6216200.0
2006-06-20 11:30:00	SPY	ETF	124.65	124.81	124.51	124.62	4354000.0
2006-06-20 12:00:00	SPY	ETF	124.62	124.66	124.41	124.41	3379300.0
2006-06-20 12:30:00	SPY	ETF	124.41	124.45	124.18	124.29	3206000.0
2006-06-20 13:00:00	SPY	ETF	124.3	124.41	124.25	124.25	1598700.0
2006-06-20 13:30:00	SPY	ETF	124.26	124.56	124.06	124.21	4640700.0
2006-06-20 14:00:00	SPY	ETF	124.22	124.26	123.9	123.97	5174100.0
2006-06-20 14:30:00	SPY	ETF	123.98	124.34	123.9	124.22	2546800.0
2006-06-20 15:00:00	SPY	ETF	124.2	124.56	124.01	124.13	2938900.0
2006-06-20 15:30:00	SPY	ETF	124.13	124.15	123.73	123.88	7052500.0
2006-06-20 16:00:00	SPY	ETF	123.88	124.07	123.84	124.05	546200.0
2006-06-20 16:30:00	SPY	ETF	124.05	124.13	124.04	124.11	103500.0
2006-06-20 17:00:00	SPY	ETF	124.09	124.09	123.9	124.07	1346200.0
2006-06-20 17:30:00	SPY	ETF	124.05	124.2	124.0	124.17	37700.0
2006-06-20 18:00:00	SPY	ETF	124.13	124.13	124.06	124.06	20600.0
2006-06-20 18:30:00	SPY	ETF	124.06	124.07	124.06	124.06	1500.0
2006-06-20 19:30:00	SPY	ETF	124.02	124.02	123.98	124.0	5700.0
2006-06-20 09:30:00	QQQ	ETF	38.09	38.18	37.95	38.0	14306800.0
2006-06-20 10:00:00	QQQ	ETF	38.0	38.12	37.94	38.01	8605200.0
2006-06-20 10:30:00	QQQ	ETF	38.0	38.13	37.98	38.06	9415400.0
2006-06-20 11:00:00	QQQ	ETF	38.06	38.33	38.04	38.32	13040100.0
2006-06-20 11:30:00	QQQ	ETF	38.32	38.48	38.31	38.38	10957900.0
2006-06-20 12:00:00	QQQ	ETF	38.38	38.4	38.28	38.3	3083300.0
2006-06-20 12:30:00	QQQ	ETF	38.3	38.31	38.21	38.23	3583500.0
2006-06-20 13:00:00	QQQ	ETF	38.23	38.28	38.2	38.22	2989600.0
2006-06-20 13:30:00	QQQ	ETF	38.21	38.26	38.09	38.15	6495300.0
2006-06-20 14:00:00	QQQ	ETF	38.15	38.17	38.0	38.04	7177200.0
2006-06-20 14:30:00	QQQ	ETF	38.04	38.19	38.02	38.15	4800600.0
2006-06-20 15:00:00	QQQ	ETF	38.16	38.2	38.08	38.14	4525100.0
2006-06-20 15:30:00	QQQ	ETF	38.14	38.17	38.0	38.08	7780600.0
2006-06-20 08:00:00	IWM	ETF	67.23	67.5	67.19	67.21	1993700.0
2006-06-20 08:30:00	IWM	ETF	67.36	67.8	67.23	67.43	92100.0
2006-06-20 09:00:00	IWM	ETF	67.49	67.64	67.49	67.58	278300.0
2006-06-20 09:30:00	IWM	ETF	67.56	68.08	67.35	67.38	9970400.0
2006-06-20 10:00:00	IWM	ETF	67.38	67.75	67.31	67.5	5569400.0
2006-06-20 10:30:00	IWM	ETF	67.49	68.0	67.49	67.77	3669000.0
2006-06-20 11:00:00	IWM	ETF	67.77	68.2	67.68	68.16	5921900.0
2006-06-20 11:30:00	IWM	ETF	68.17	68.33	68.05	68.14	4448200.0
2006-06-20 12:00:00	IWM	ETF	68.15	68.18	67.89	67.89	1678100.0

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

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