PREVIEW / etf_1hour / 2001-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-02.parquet
  size:    12 KB
  rows:    226

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-05-02 09:00:00	SPY	ETF	127.41	127.69	126.55	126.8	1362000.0
2001-05-02 10:00:00	SPY	ETF	126.83	127.04	126.0	126.5	1660500.0
2001-05-02 11:00:00	SPY	ETF	126.46	126.72	126.03	126.56	1016600.0
2001-05-02 12:00:00	SPY	ETF	126.68	126.91	126.38	126.4	388600.0
2001-05-02 13:00:00	SPY	ETF	126.46	127.35	126.24	127.18	880300.0
2001-05-02 14:00:00	SPY	ETF	127.21	127.63	126.95	127.19	1714800.0
2001-05-02 15:00:00	SPY	ETF	127.18	127.58	126.6	126.89	1392700.0
2001-05-02 16:00:00	SPY	ETF	126.91	127.18	126.72	126.98	313000.0
2001-05-02 17:00:00	SPY	ETF	127.0	127.03	126.84	126.84	101600.0
2001-05-02 09:00:00	QQQ	ETF	48.8	49.4	48.55	48.85	14013100.0
2001-05-02 10:00:00	QQQ	ETF	48.78	48.99	47.9	48.5	13855800.0
2001-05-02 11:00:00	QQQ	ETF	48.42	48.5	47.7	48.33	8358500.0
2001-05-02 12:00:00	QQQ	ETF	48.34	48.83	48.06	48.43	6408700.0
2001-05-02 13:00:00	QQQ	ETF	48.39	49.12	48.2	49.03	6393600.0
2001-05-02 14:00:00	QQQ	ETF	49.05	49.4	48.77	48.97	9903200.0
2001-05-02 15:00:00	QQQ	ETF	48.92	49.3	48.43	48.9	12083900.0
2001-05-02 16:00:00	QQQ	ETF	48.9	49.06	48.8	48.99	1389400.0
2001-05-02 17:00:00	QQQ	ETF	49.0	49.03	48.8	48.86	22100.0
2001-05-02 18:00:00	QQQ	ETF	48.86	48.87	48.7	48.77	15300.0
2001-05-02 09:00:00	IWM	ETF	49.2	49.225	49.0	49.0	35200.0
2001-05-02 10:00:00	IWM	ETF	49.025	49.05	48.6	48.675	103400.0
2001-05-02 11:00:00	IWM	ETF	48.625	48.75	48.5	48.75	176200.0
2001-05-02 12:00:00	IWM	ETF	48.675	48.925	48.625	48.875	28000.0
2001-05-02 13:00:00	IWM	ETF	48.805	49.025	48.775	49.025	44600.0
2001-05-02 14:00:00	IWM	ETF	49.12	49.3	49.025	49.25	15000.0
2001-05-02 15:00:00	IWM	ETF	49.25	49.295	48.9	48.975	155400.0
2001-05-02 16:00:00	IWM	ETF	48.975	48.975	48.975	48.975	600.0
2001-05-02 09:00:00	DIA	ETF	109.05	109.49	108.45	108.51	726400.0
2001-05-02 10:00:00	DIA	ETF	108.63	108.79	107.96	108.33	652700.0
2001-05-02 11:00:00	DIA	ETF	108.38	108.6	108.0	108.43	482400.0
2001-05-02 12:00:00	DIA	ETF	108.5	108.69	108.35	108.38	465500.0
2001-05-02 13:00:00	DIA	ETF	108.37	109.19	108.3	109.08	291600.0
2001-05-02 14:00:00	DIA	ETF	109.1	109.39	108.7	109.07	983900.0
2001-05-02 15:00:00	DIA	ETF	109.04	109.29	108.5	108.7	582300.0
2001-05-02 16:00:00	DIA	ETF	108.66	108.82	108.0	108.69	44000.0
2001-05-02 17:00:00	DIA	ETF	108.59	108.59	108.56	108.56	200.0

> showing 36 of 226 rows — these rows as CSV

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