PREVIEW / etf_1hour / 2001-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-18.parquet
  size:    12 KB
  rows:    237

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-07-18 09:00:00	SPY	ETF	120.56	121.24	120.53	121.2	907900.0
2001-07-18 10:00:00	SPY	ETF	121.17	121.64	120.06	120.66	1800200.0
2001-07-18 11:00:00	SPY	ETF	120.61	121.19	120.54	120.77	678500.0
2001-07-18 12:00:00	SPY	ETF	120.83	120.88	120.35	120.45	593500.0
2001-07-18 13:00:00	SPY	ETF	120.45	120.94	120.27	120.75	380400.0
2001-07-18 14:00:00	SPY	ETF	120.72	120.72	120.21	120.34	801300.0
2001-07-18 15:00:00	SPY	ETF	120.29	121.14	120.23	121.1	1190500.0
2001-07-18 16:00:00	SPY	ETF	121.04	121.23	120.74	120.77	988500.0
2001-07-18 17:00:00	SPY	ETF	121.0	121.0	120.55	120.9	26700.0
2001-07-18 18:00:00	SPY	ETF	120.62	120.63	120.62	120.63	1000.0
2001-07-18 09:00:00	QQQ	ETF	42.27	42.55	42.07	42.51	9647700.0
2001-07-18 10:00:00	QQQ	ETF	42.5	42.85	41.51	41.8	16870100.0
2001-07-18 11:00:00	QQQ	ETF	41.81	42.24	41.72	41.85	8283900.0
2001-07-18 12:00:00	QQQ	ETF	41.89	41.95	41.54	41.7	3682800.0
2001-07-18 13:00:00	QQQ	ETF	41.72	41.94	41.43	41.66	4539200.0
2001-07-18 14:00:00	QQQ	ETF	41.68	41.7	41.14	41.22	6723500.0
2001-07-18 15:00:00	QQQ	ETF	41.2	41.56	41.17	41.54	7880900.0
2001-07-18 16:00:00	QQQ	ETF	41.52	41.85	40.75	41.41	3425800.0
2001-07-18 17:00:00	QQQ	ETF	41.4	41.6	40.96	41.4	1971500.0
2001-07-18 18:00:00	QQQ	ETF	41.43	41.5	41.37	41.37	83900.0
2001-07-18 09:00:00	IWM	ETF	48.35	48.82	48.35	48.82	5800.0
2001-07-18 10:00:00	IWM	ETF	48.845	48.945	48.35	48.565	142600.0
2001-07-18 11:00:00	IWM	ETF	48.58	48.795	48.5	48.71	222600.0
2001-07-18 12:00:00	IWM	ETF	48.71	48.71	48.5	48.575	251400.0
2001-07-18 13:00:00	IWM	ETF	48.575	48.61	48.49	48.515	7000.0
2001-07-18 14:00:00	IWM	ETF	48.57	48.57	48.15	48.15	167600.0
2001-07-18 15:00:00	IWM	ETF	48.15	48.3	48.125	48.155	52800.0
2001-07-18 16:00:00	IWM	ETF	48.1	48.1	48.075	48.1	15200.0
2001-07-18 09:00:00	DIA	ETF	105.35	105.8	105.13	105.77	218000.0
2001-07-18 10:00:00	DIA	ETF	105.78	106.08	104.9	105.39	297600.0
2001-07-18 11:00:00	DIA	ETF	105.38	105.78	105.21	105.52	384800.0
2001-07-18 12:00:00	DIA	ETF	105.53	105.62	105.16	105.28	99100.0
2001-07-18 13:00:00	DIA	ETF	105.28	105.67	105.09	105.5	376800.0
2001-07-18 14:00:00	DIA	ETF	105.56	105.56	105.01	105.05	221200.0
2001-07-18 15:00:00	DIA	ETF	105.09	105.8	105.09	105.77	480800.0
2001-07-18 16:00:00	DIA	ETF	105.72	105.8	105.35	105.65	126500.0
2001-07-18 17:00:00	DIA	ETF	105.4	105.4	105.0	105.25	11800.0

> showing 37 of 237 rows — these rows as CSV

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