PREVIEW / etf_1hour / 2002-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-02.parquet
  size:    13 KB
  rows:    289

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
2002-01-02 09:00:00	SPY	ETF	115.11	115.13	114.49	114.5	2733600.0
2002-01-02 10:00:00	SPY	ETF	114.49	114.88	113.81	114.1	4664600.0
2002-01-02 11:00:00	SPY	ETF	114.11	114.57	114.0	114.28	1225100.0
2002-01-02 12:00:00	SPY	ETF	114.26	114.47	114.18	114.34	1232400.0
2002-01-02 13:00:00	SPY	ETF	114.31	114.95	114.26	114.89	1154600.0
2002-01-02 14:00:00	SPY	ETF	114.94	115.02	114.43	114.6	1393300.0
2002-01-02 15:00:00	SPY	ETF	114.61	115.65	114.42	115.59	3743600.0
2002-01-02 16:00:00	SPY	ETF	115.62	115.75	115.5	115.6	3062800.0
2002-01-02 17:00:00	SPY	ETF	115.56	115.56	115.56	115.56	100.0
2002-01-02 18:00:00	SPY	ETF	115.61	115.61	115.41	115.41	1300.0
2002-01-02 09:00:00	QQQ	ETF	39.57	39.65	39.24	39.24	10788900.0
2002-01-02 10:00:00	QQQ	ETF	39.28	39.57	38.93	39.13	14748900.0
2002-01-02 11:00:00	QQQ	ETF	39.14	39.35	39.04	39.08	5002900.0
2002-01-02 12:00:00	QQQ	ETF	39.09	39.2	39.0	39.1	4246100.0
2002-01-02 13:00:00	QQQ	ETF	39.1	39.52	39.03	39.48	5107500.0
2002-01-02 14:00:00	QQQ	ETF	39.48	39.57	39.26	39.37	7167800.0
2002-01-02 15:00:00	QQQ	ETF	39.37	40.05	39.27	40.02	10919700.0
2002-01-02 16:00:00	QQQ	ETF	40.04	40.2	39.88	40.17	2005800.0
2002-01-02 17:00:00	QQQ	ETF	40.15	40.16	40.1	40.15	30100.0
2002-01-02 18:00:00	QQQ	ETF	40.16	40.17	40.12	40.12	18600.0
2002-01-02 09:00:00	IWM	ETF	48.55	48.645	48.15	48.345	191000.0
2002-01-02 10:00:00	IWM	ETF	48.335	48.39	47.64	47.675	199600.0
2002-01-02 11:00:00	IWM	ETF	47.735	47.91	47.72	47.875	514400.0
2002-01-02 12:00:00	IWM	ETF	47.875	47.98	47.83	47.83	64400.0
2002-01-02 13:00:00	IWM	ETF	47.835	47.985	47.68	47.9	161000.0
2002-01-02 14:00:00	IWM	ETF	47.985	48.085	47.84	48.065	131800.0
2002-01-02 15:00:00	IWM	ETF	48.035	48.355	47.9	48.355	190200.0
2002-01-02 16:00:00	IWM	ETF	48.5	48.515	48.06	48.515	13400.0
2002-01-02 09:00:00	DIA	ETF	100.48	100.48	99.91	100.03	168500.0
2002-01-02 10:00:00	DIA	ETF	99.93	100.32	99.4	99.61	499400.0
2002-01-02 11:00:00	DIA	ETF	99.6	100.0	99.51	99.77	225000.0
2002-01-02 12:00:00	DIA	ETF	99.85	100.0	99.74	99.83	134300.0
2002-01-02 13:00:00	DIA	ETF	99.88	100.35	99.78	100.31	242100.0
2002-01-02 14:00:00	DIA	ETF	100.36	100.45	99.86	100.03	315100.0
2002-01-02 15:00:00	DIA	ETF	100.05	100.88	99.92	100.82	631700.0
2002-01-02 16:00:00	DIA	ETF	100.84	100.9	100.76	100.85	621500.0

> showing 36 of 289 rows — these rows as CSV

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