PREVIEW / etf_1hour / 2001-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-12.parquet
  size:    13 KB
  rows:    281

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
2001-12-12 09:00:00	SPY	ETF	114.55	114.6	114.1	114.48	1577300.0
2001-12-12 10:00:00	SPY	ETF	114.5	114.78	113.7	113.82	3847300.0
2001-12-12 11:00:00	SPY	ETF	113.83	113.91	113.17	113.33	1782800.0
2001-12-12 12:00:00	SPY	ETF	113.3	113.55	113.11	113.45	1747400.0
2001-12-12 13:00:00	SPY	ETF	113.49	113.86	113.36	113.68	1358200.0
2001-12-12 14:00:00	SPY	ETF	113.7	113.74	113.21	113.3	1872000.0
2001-12-12 15:00:00	SPY	ETF	113.29	114.33	113.22	114.29	3154200.0
2001-12-12 16:00:00	SPY	ETF	114.22	114.74	114.15	114.31	827200.0
2001-12-12 17:00:00	SPY	ETF	114.28	114.28	114.27	114.28	900.0
2001-12-12 09:00:00	QQQ	ETF	41.5	41.74	41.31	41.71	6812100.0
2001-12-12 10:00:00	QQQ	ETF	41.71	41.94	41.02	41.16	15460600.0
2001-12-12 11:00:00	QQQ	ETF	41.16	41.28	40.6	40.82	10444600.0
2001-12-12 12:00:00	QQQ	ETF	40.8	40.95	40.6	40.84	6097400.0
2001-12-12 13:00:00	QQQ	ETF	40.85	41.31	40.8	41.14	8172200.0
2001-12-12 14:00:00	QQQ	ETF	41.18	41.24	40.74	40.79	10913600.0
2001-12-12 15:00:00	QQQ	ETF	40.8	41.63	40.75	41.57	16253100.0
2001-12-12 16:00:00	QQQ	ETF	41.57	41.63	41.4	41.55	1719100.0
2001-12-12 17:00:00	QQQ	ETF	41.15	41.57	40.9	41.52	24800.0
2001-12-12 18:00:00	QQQ	ETF	41.52	41.55	41.5	41.55	10200.0
2001-12-12 09:00:00	IWM	ETF	47.45	47.47	47.25	47.34	18400.0
2001-12-12 10:00:00	IWM	ETF	47.405	47.565	47.065	47.065	7600.0
2001-12-12 11:00:00	IWM	ETF	47.16	47.175	47.0	47.0	32000.0
2001-12-12 12:00:00	IWM	ETF	46.865	47.01	46.865	46.98	28800.0
2001-12-12 13:00:00	IWM	ETF	46.915	47.275	46.915	47.185	36400.0
2001-12-12 14:00:00	IWM	ETF	47.185	47.26	47.06	47.235	33200.0
2001-12-12 15:00:00	IWM	ETF	47.225	47.465	47.085	47.4	88400.0
2001-12-12 16:00:00	IWM	ETF	47.4	47.4	47.4	47.4	2800.0
2001-12-12 09:00:00	DIA	ETF	99.4	99.4	98.88	99.2	190800.0
2001-12-12 10:00:00	DIA	ETF	99.14	99.45	98.6	98.65	396000.0
2001-12-12 11:00:00	DIA	ETF	98.67	99.65	98.22	98.35	346700.0
2001-12-12 12:00:00	DIA	ETF	98.4	98.62	98.3	98.55	189400.0
2001-12-12 13:00:00	DIA	ETF	98.5	98.87	98.41	98.7	235700.0
2001-12-12 14:00:00	DIA	ETF	98.67	98.69	98.28	98.28	183400.0
2001-12-12 15:00:00	DIA	ETF	98.37	99.27	98.37	99.18	1504400.0
2001-12-12 16:00:00	DIA	ETF	99.24	99.35	99.2	99.23	70400.0
2001-12-12 17:00:00	DIA	ETF	99.4	99.4	99.4	99.4	400.0
2001-12-12 18:00:00	DIA	ETF	99.4	99.4	99.4	99.4	100.0

> showing 37 of 281 rows — these rows as CSV

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