PREVIEW / etf_30min / 2006-01-04

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-04.parquet
  size:    60 KB
  rows:    2,155

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-01-04 07:00:00	SPY	ETF	126.69	126.69	126.65	126.68	14000.0
2006-01-04 07:30:00	SPY	ETF	126.68	126.69	126.65	126.65	4200.0
2006-01-04 08:00:00	SPY	ETF	126.6	126.76	126.6	126.7	727400.0
2006-01-04 08:30:00	SPY	ETF	126.7	126.87	126.7	126.82	683400.0
2006-01-04 09:00:00	SPY	ETF	126.82	126.85	126.79	126.83	113300.0
2006-01-04 09:30:00	SPY	ETF	126.86	127.02	126.7	126.89	6604600.0
2006-01-04 10:00:00	SPY	ETF	126.89	127.27	126.84	127.15	5430300.0
2006-01-04 10:30:00	SPY	ETF	127.15	127.18	126.94	127.11	2016600.0
2006-01-04 11:00:00	SPY	ETF	127.11	127.15	126.93	127.12	3561800.0
2006-01-04 11:30:00	SPY	ETF	127.13	127.47	127.1	127.41	4838200.0
2006-01-04 12:00:00	SPY	ETF	127.4	127.49	127.21	127.22	3747800.0
2006-01-04 12:30:00	SPY	ETF	127.21	127.24	127.05	127.06	1622700.0
2006-01-04 13:00:00	SPY	ETF	127.06	127.07	126.89	127.04	2471200.0
2006-01-04 13:30:00	SPY	ETF	127.03	127.12	126.83	127.02	2140500.0
2006-01-04 14:00:00	SPY	ETF	127.02	127.07	126.72	126.99	3124300.0
2006-01-04 14:30:00	SPY	ETF	126.97	127.21	126.93	127.05	2756300.0
2006-01-04 15:00:00	SPY	ETF	127.03	127.29	126.99	127.24	2434300.0
2006-01-04 15:30:00	SPY	ETF	127.24	127.4	127.13	127.27	6469700.0
2006-01-04 16:00:00	SPY	ETF	127.27	127.37	127.21	127.33	1111600.0
2006-01-04 16:30:00	SPY	ETF	127.33	127.33	127.28	127.28	120800.0
2006-01-04 17:00:00	SPY	ETF	127.27	127.31	127.22	127.22	283300.0
2006-01-04 17:30:00	SPY	ETF	127.25	127.25	127.16	127.16	44400.0
2006-01-04 18:00:00	SPY	ETF	127.17	127.22	127.16	127.21	311300.0
2006-01-04 18:30:00	SPY	ETF	127.23	127.24	127.2	127.2	1400.0
2006-01-04 19:00:00	SPY	ETF	127.2	127.21	127.2	127.21	200.0
2006-01-04 19:30:00	SPY	ETF	127.23	127.23	127.23	127.23	1500.0
2006-01-04 09:30:00	QQQ	ETF	41.4	41.51	41.34	41.44	8261900.0
2006-01-04 10:00:00	QQQ	ETF	41.44	41.66	41.16	41.61	14849700.0
2006-01-04 10:30:00	QQQ	ETF	41.6	41.62	41.49	41.59	5175200.0
2006-01-04 11:00:00	QQQ	ETF	41.6	41.61	41.46	41.59	4491800.0
2006-01-04 11:30:00	QQQ	ETF	41.59	41.73	41.57	41.69	5864000.0
2006-01-04 12:00:00	QQQ	ETF	41.69	41.74	41.67	41.67	4191100.0
2006-01-04 12:30:00	QQQ	ETF	41.67	41.69	41.63	41.64	2479300.0
2006-01-04 13:00:00	QQQ	ETF	41.65	41.65	41.51	41.6	4952500.0
2006-01-04 13:30:00	QQQ	ETF	41.6	41.65	41.5	41.59	4940200.0
2006-01-04 14:00:00	QQQ	ETF	41.6	41.61	41.44	41.55	7738300.0
2006-01-04 14:30:00	QQQ	ETF	41.55	41.61	41.52	41.53	4737600.0
2006-01-04 15:00:00	QQQ	ETF	41.53	41.66	41.52	41.66	3431800.0
2006-01-04 15:30:00	QQQ	ETF	41.65	41.73	41.65	41.73	8853700.0
2006-01-04 08:00:00	IWM	ETF	67.94	68.1	67.94	68.1	1519800.0
2006-01-04 08:30:00	IWM	ETF	68.1	68.14	68.09	68.12	16000.0
2006-01-04 09:00:00	IWM	ETF	68.1	68.11	68.09	68.11	7800.0
2006-01-04 09:30:00	IWM	ETF	68.11	68.2	67.88	67.94	3876800.0
2006-01-04 10:00:00	IWM	ETF	67.94	68.23	67.94	68.12	2545400.0
2006-01-04 10:30:00	IWM	ETF	68.12	68.36	67.97	68.35	1438100.0
2006-01-04 11:00:00	IWM	ETF	68.34	68.38	68.11	68.2	1010700.0
2006-01-04 11:30:00	IWM	ETF	68.2	68.53	68.2	68.53	1812500.0
2006-01-04 12:00:00	IWM	ETF	68.53	68.65	68.47	68.5	1613100.0
2006-01-04 12:30:00	IWM	ETF	68.49	68.58	68.45	68.47	1462400.0
2006-01-04 13:00:00	IWM	ETF	68.47	68.53	68.39	68.53	1464500.0

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

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