PREVIEW / etf_30min / 2006-08-09

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-09.parquet
  size:    80 KB
  rows:    2,733

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-08-09 05:00:00	SPY	ETF	127.55	127.55	127.55	127.55	25000.0
2006-08-09 05:30:00	SPY	ETF	127.7	127.7	127.7	127.7	25000.0
2006-08-09 06:00:00	SPY	ETF	127.7	127.7	127.7	127.7	50000.0
2006-08-09 06:30:00	SPY	ETF	127.75	127.82	127.75	127.82	25100.0
2006-08-09 07:00:00	SPY	ETF	127.86	127.99	127.86	127.93	93300.0
2006-08-09 07:30:00	SPY	ETF	127.92	127.95	127.87	127.94	244700.0
2006-08-09 08:00:00	SPY	ETF	127.94	128.18	127.77	128.11	2028400.0
2006-08-09 08:30:00	SPY	ETF	128.12	128.13	127.86	128.06	1865500.0
2006-08-09 09:00:00	SPY	ETF	128.08	128.31	128.02	128.24	1670000.0
2006-08-09 09:30:00	SPY	ETF	128.2	128.45	128.02	128.05	9212800.0
2006-08-09 10:00:00	SPY	ETF	128.05	128.16	127.95	127.99	5150800.0
2006-08-09 10:30:00	SPY	ETF	127.97	128.1	127.83	128.02	3687100.0
2006-08-09 11:00:00	SPY	ETF	128.02	128.25	128.02	128.22	3868900.0
2006-08-09 11:30:00	SPY	ETF	128.21	128.6	128.18	128.31	6448800.0
2006-08-09 12:00:00	SPY	ETF	128.31	128.34	128.2	128.26	1583700.0
2006-08-09 12:30:00	SPY	ETF	128.25	128.3	127.86	127.93	3435800.0
2006-08-09 13:00:00	SPY	ETF	127.93	127.99	127.63	127.72	4740000.0
2006-08-09 13:30:00	SPY	ETF	127.72	127.84	127.57	127.64	3622100.0
2006-08-09 14:00:00	SPY	ETF	127.65	127.93	127.61	127.73	3680600.0
2006-08-09 14:30:00	SPY	ETF	127.73	127.83	127.24	127.28	5393900.0
2006-08-09 15:00:00	SPY	ETF	127.27	127.44	126.89	126.92	11608400.0
2006-08-09 15:30:00	SPY	ETF	126.92	126.97	126.61	126.78	7565300.0
2006-08-09 16:00:00	SPY	ETF	126.79	126.99	126.73	126.95	981500.0
2006-08-09 16:30:00	SPY	ETF	126.93	126.99	126.86	126.89	462500.0
2006-08-09 17:00:00	SPY	ETF	126.87	126.88	126.82	126.86	85700.0
2006-08-09 17:30:00	SPY	ETF	126.86	126.93	126.86	126.9	7400.0
2006-08-09 18:00:00	SPY	ETF	126.9	126.9	126.81	126.86	4500.0
2006-08-09 18:30:00	SPY	ETF	126.87	126.87	126.87	126.87	500.0
2006-08-09 19:00:00	SPY	ETF	126.93	126.93	126.93	126.93	1500.0
2006-08-09 19:30:00	SPY	ETF	126.9	126.9	126.89	126.89	500.0
2006-08-09 09:30:00	QQQ	ETF	37.01	37.07	36.92	36.98	20539800.0
2006-08-09 10:00:00	QQQ	ETF	36.98	36.99	36.88	36.92	10726800.0
2006-08-09 10:30:00	QQQ	ETF	36.92	36.95	36.83	36.93	11459000.0
2006-08-09 11:00:00	QQQ	ETF	36.93	37.16	36.92	37.14	14598000.0
2006-08-09 11:30:00	QQQ	ETF	37.14	37.31	37.12	37.22	14247800.0
2006-08-09 12:00:00	QQQ	ETF	37.23	37.23	37.13	37.18	4570900.0
2006-08-09 12:30:00	QQQ	ETF	37.18	37.19	37.04	37.07	4644300.0
2006-08-09 13:00:00	QQQ	ETF	37.07	37.1	36.93	36.96	6335200.0
2006-08-09 13:30:00	QQQ	ETF	36.96	37.02	36.91	36.94	5531800.0
2006-08-09 14:00:00	QQQ	ETF	36.95	37.01	36.89	36.96	5324400.0
2006-08-09 14:30:00	QQQ	ETF	36.96	37.01	36.76	36.77	9389300.0
2006-08-09 15:00:00	QQQ	ETF	36.77	36.77	36.57	36.58	13422300.0
2006-08-09 15:30:00	QQQ	ETF	36.58	36.6	36.43	36.53	14035600.0
2006-08-09 07:00:00	IWM	ETF	68.6	68.6	68.6	68.6	2000.0
2006-08-09 07:30:00	IWM	ETF	68.7	68.7	68.7	68.7	1000.0
2006-08-09 08:00:00	IWM	ETF	68.7	68.95	68.7	68.9	389000.0
2006-08-09 08:30:00	IWM	ETF	68.9	68.94	68.88	68.93	193400.0
2006-08-09 09:00:00	IWM	ETF	68.93	69.03	68.92	68.98	392700.0
2006-08-09 09:30:00	IWM	ETF	68.99	69.28	68.77	68.82	8398300.0
2006-08-09 10:00:00	IWM	ETF	68.82	68.89	68.62	68.63	3792000.0

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

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