PREVIEW / etf_1hour / 2001-12-19

all etf 1-hour files

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

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-19 09:00:00	SPY	ETF	114.09	114.39	114.0	114.33	3166500.0
2001-12-19 10:00:00	SPY	ETF	114.35	115.07	114.28	115.05	4460300.0
2001-12-19 11:00:00	SPY	ETF	115.0	115.88	114.97	115.57	3364800.0
2001-12-19 12:00:00	SPY	ETF	115.55	115.76	115.28	115.35	2715600.0
2001-12-19 13:00:00	SPY	ETF	115.36	115.67	115.11	115.67	1144000.0
2001-12-19 14:00:00	SPY	ETF	115.69	115.92	115.55	115.82	1773200.0
2001-12-19 15:00:00	SPY	ETF	115.83	115.91	115.42	115.5	2103000.0
2001-12-19 16:00:00	SPY	ETF	115.5	116.08	115.3	115.7	964900.0
2001-12-19 17:00:00	SPY	ETF	115.73	115.73	115.52	115.71	3800.0
2001-12-19 18:00:00	SPY	ETF	115.75	115.75	115.75	115.75	1000.0
2001-12-19 09:00:00	QQQ	ETF	40.56	40.6	40.32	40.56	11279400.0
2001-12-19 10:00:00	QQQ	ETF	40.56	40.94	40.46	40.78	16714400.0
2001-12-19 11:00:00	QQQ	ETF	40.81	41.32	40.74	41.12	15118800.0
2001-12-19 12:00:00	QQQ	ETF	41.12	41.25	40.89	40.92	7684900.0
2001-12-19 13:00:00	QQQ	ETF	40.93	41.04	40.61	41.04	8175000.0
2001-12-19 14:00:00	QQQ	ETF	41.04	41.1	40.75	40.9	5883700.0
2001-12-19 15:00:00	QQQ	ETF	40.91	40.93	40.53	40.55	10776600.0
2001-12-19 16:00:00	QQQ	ETF	40.56	40.65	40.45	40.47	2932000.0
2001-12-19 17:00:00	QQQ	ETF	40.47	40.53	40.41	40.53	135200.0
2001-12-19 18:00:00	QQQ	ETF	40.53	40.6	40.41	40.55	16900.0
2001-12-19 09:00:00	IWM	ETF	47.875	47.895	47.565	47.82	90800.0
2001-12-19 10:00:00	IWM	ETF	47.825	48.05	47.785	47.94	59200.0
2001-12-19 11:00:00	IWM	ETF	48.065	48.19	48.0	48.17	54200.0
2001-12-19 12:00:00	IWM	ETF	48.125	48.145	47.94	48.02	70800.0
2001-12-19 13:00:00	IWM	ETF	48.02	48.03	47.875	48.03	173400.0
2001-12-19 14:00:00	IWM	ETF	48.05	48.17	47.92	48.13	534800.0
2001-12-19 15:00:00	IWM	ETF	48.01	48.145	47.835	47.835	214600.0
2001-12-19 16:00:00	IWM	ETF	47.95	47.95	47.75	47.9	353800.0
2001-12-19 09:00:00	DIA	ETF	99.6	99.74	99.36	99.7	276700.0
2001-12-19 10:00:00	DIA	ETF	99.73	100.32	99.66	100.29	618600.0
2001-12-19 11:00:00	DIA	ETF	100.26	100.86	100.15	100.66	516700.0
2001-12-19 12:00:00	DIA	ETF	100.65	100.81	100.47	100.52	80100.0
2001-12-19 13:00:00	DIA	ETF	100.59	100.96	100.46	100.96	122000.0
2001-12-19 14:00:00	DIA	ETF	100.98	101.15	100.86	101.0	323500.0
2001-12-19 15:00:00	DIA	ETF	101.04	101.14	100.72	100.91	201700.0
2001-12-19 16:00:00	DIA	ETF	100.9	101.17	100.85	101.16	108800.0

> showing 36 of 286 rows — these rows as CSV

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