PREVIEW / etf_1hour / 2001-12-18

all etf 1-hour files

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

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-18 09:00:00	SPY	ETF	114.63	115.15	114.61	114.93	2781800.0
2001-12-18 10:00:00	SPY	ETF	114.98	115.12	114.72	114.8	1997300.0
2001-12-18 11:00:00	SPY	ETF	114.8	114.88	114.43	114.7	1239300.0
2001-12-18 12:00:00	SPY	ETF	114.7	114.89	114.61	114.85	847500.0
2001-12-18 13:00:00	SPY	ETF	114.85	114.94	114.51	114.73	1661700.0
2001-12-18 14:00:00	SPY	ETF	114.72	114.78	114.34	114.62	1098900.0
2001-12-18 15:00:00	SPY	ETF	114.65	115.08	114.56	114.9	1909700.0
2001-12-18 16:00:00	SPY	ETF	114.93	115.1	114.8	114.82	788100.0
2001-12-18 17:00:00	SPY	ETF	114.7	114.7	114.55	114.68	3800.0
2001-12-18 18:00:00	SPY	ETF	114.4	114.4	114.4	114.4	100.0
2001-12-18 09:00:00	QQQ	ETF	41.16	41.5	41.1	41.26	10371400.0
2001-12-18 10:00:00	QQQ	ETF	41.24	41.34	41.05	41.1	10097000.0
2001-12-18 11:00:00	QQQ	ETF	41.13	41.2	40.88	41.1	6114500.0
2001-12-18 12:00:00	QQQ	ETF	41.1	41.25	41.0	41.23	3201000.0
2001-12-18 13:00:00	QQQ	ETF	41.22	41.26	40.95	41.12	4542800.0
2001-12-18 14:00:00	QQQ	ETF	41.12	41.2	40.9	41.12	4380800.0
2001-12-18 15:00:00	QQQ	ETF	41.11	41.43	41.08	41.3	8723500.0
2001-12-18 16:00:00	QQQ	ETF	41.29	41.37	41.1	41.1	1970100.0
2001-12-18 17:00:00	QQQ	ETF	41.14	41.15	40.87	40.87	516400.0
2001-12-18 18:00:00	QQQ	ETF	40.88	40.93	40.86	40.91	15500.0
2001-12-18 09:00:00	IWM	ETF	48.25	48.325	48.135	48.32	319000.0
2001-12-18 10:00:00	IWM	ETF	48.325	48.325	48.0	48.085	150600.0
2001-12-18 11:00:00	IWM	ETF	48.125	48.125	47.875	48.0	116000.0
2001-12-18 12:00:00	IWM	ETF	47.98	48.07	47.85	48.07	53000.0
2001-12-18 13:00:00	IWM	ETF	48.04	48.04	47.895	47.975	45400.0
2001-12-18 14:00:00	IWM	ETF	47.975	48.05	47.815	47.88	166000.0
2001-12-18 15:00:00	IWM	ETF	47.98	48.275	47.945	48.075	242000.0
2001-12-18 16:00:00	IWM	ETF	48.265	48.275	48.265	48.275	2600.0
2001-12-18 09:00:00	DIA	ETF	99.86	100.25	99.61	100.02	407500.0
2001-12-18 10:00:00	DIA	ETF	100.01	100.22	99.91	99.97	197500.0
2001-12-18 11:00:00	DIA	ETF	99.9	99.97	99.61	99.77	146000.0
2001-12-18 12:00:00	DIA	ETF	99.85	100.07	99.75	100.01	65200.0
2001-12-18 13:00:00	DIA	ETF	100.09	100.15	99.76	99.92	183700.0
2001-12-18 14:00:00	DIA	ETF	99.95	100.06	99.68	99.98	89200.0
2001-12-18 15:00:00	DIA	ETF	99.97	100.4	99.9	100.31	378100.0
2001-12-18 16:00:00	DIA	ETF	100.27	100.4	100.25	100.4	37100.0
2001-12-18 17:00:00	DIA	ETF	100.05	100.05	100.05	100.05	50000.0

> showing 37 of 292 rows — these rows as CSV

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