PREVIEW / etf_1hour / 2009-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-02.parquet
  size:    140 KB
  rows:    4,350

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
2009-09-02 04:00:00	SPY	ETF	99.91	99.93	99.83	99.93	8550.0
2009-09-02 05:00:00	SPY	ETF	100.1	100.11	99.85	99.85	10700.0
2009-09-02 06:00:00	SPY	ETF	99.96	100.11	99.96	100.03	39361.0
2009-09-02 07:00:00	SPY	ETF	100.1	100.18	100.05	100.08	116594.0
2009-09-02 08:00:00	SPY	ETF	100.06	100.2	99.67	99.8	3990917.0
2009-09-02 09:00:00	SPY	ETF	99.81	100.31	99.67	100.02	27104529.0
2009-09-02 10:00:00	SPY	ETF	100.01	100.42	99.57	100.35	36681909.0
2009-09-02 11:00:00	SPY	ETF	100.36	100.44	100.09	100.125	18038308.0
2009-09-02 12:00:00	SPY	ETF	100.13	100.37	100.0	100.3	12075405.0
2009-09-02 13:00:00	SPY	ETF	100.29	100.33	100.07	100.1	8899712.0
2009-09-02 14:00:00	SPY	ETF	100.1	100.38	100.03	100.15	15523778.0
2009-09-02 15:00:00	SPY	ETF	100.14	100.41	99.81	99.84	32541236.0
2009-09-02 16:00:00	SPY	ETF	99.83	100.37	99.77	99.87	9043923.0
2009-09-02 17:00:00	SPY	ETF	99.86	99.86	99.8	99.8	114030.0
2009-09-02 18:00:00	SPY	ETF	99.82	99.87	99.78	99.85	137508.0
2009-09-02 19:00:00	SPY	ETF	99.83	99.96	99.81	99.91	71737.0
2009-09-02 04:00:00	QQQ	ETF	39.1	39.15	39.07	39.15	10700.0
2009-09-02 05:00:00	QQQ	ETF	39.21	39.21	39.11	39.11	11100.0
2009-09-02 06:00:00	QQQ	ETF	39.13	39.18	39.13	39.15	3600.0
2009-09-02 07:00:00	QQQ	ETF	39.22	39.26	39.2	39.23	173467.0
2009-09-02 08:00:00	QQQ	ETF	39.21	39.26	39.05	39.14	755075.0
2009-09-02 09:00:00	QQQ	ETF	39.15	39.47	39.04	39.28	17441292.0
2009-09-02 10:00:00	QQQ	ETF	39.28	39.44	39.12	39.42	21477455.0
2009-09-02 11:00:00	QQQ	ETF	39.43	39.47	39.32	39.35	10480896.0
2009-09-02 12:00:00	QQQ	ETF	39.34	39.4404	39.27	39.3805	7602546.0
2009-09-02 13:00:00	QQQ	ETF	39.382	39.41	39.31	39.31	4928524.0
2009-09-02 14:00:00	QQQ	ETF	39.3199	39.43	39.28	39.37	7453132.0
2009-09-02 15:00:00	QQQ	ETF	39.36	39.47	39.22	39.25	15923508.0
2009-09-02 16:00:00	QQQ	ETF	39.25	39.42	39.19	39.22	3571410.0
2009-09-02 17:00:00	QQQ	ETF	39.22	39.26	39.2	39.26	33990.0
2009-09-02 18:00:00	QQQ	ETF	39.25	39.25	39.2	39.21	31753.0
2009-09-02 19:00:00	QQQ	ETF	39.22	39.27	39.21	39.27	55134.0
2009-09-02 07:00:00	IWM	ETF	55.81	55.91	55.81	55.86	31512.0
2009-09-02 08:00:00	IWM	ETF	55.51	55.87	55.51	55.67	391497.0
2009-09-02 09:00:00	IWM	ETF	55.68	56.06	55.58	55.81	7055614.0
2009-09-02 10:00:00	IWM	ETF	55.8	56.04	55.47	56.01	7649655.0
2009-09-02 11:00:00	IWM	ETF	56.018	56.02	55.78	55.81	3748811.0
2009-09-02 12:00:00	IWM	ETF	55.81	55.97	55.7	55.88	1984780.0
2009-09-02 13:00:00	IWM	ETF	55.88	55.92	55.69	55.7	3020815.0
2009-09-02 14:00:00	IWM	ETF	55.71	55.87	55.64	55.74	3421268.0
2009-09-02 15:00:00	IWM	ETF	55.74	55.93	55.58	55.63	6613903.0
2009-09-02 16:00:00	IWM	ETF	55.64	55.8759	55.51	55.55	3206888.0
2009-09-02 17:00:00	IWM	ETF	55.55	55.56	55.53	55.55	4276.0
2009-09-02 18:00:00	IWM	ETF	55.6	55.62	55.58	55.6	3300.0
2009-09-02 19:00:00	IWM	ETF	55.65	55.65	55.62	55.64	2300.0
2009-09-02 07:00:00	DIA	ETF	93.21	93.21	93.15	93.15	200.0
2009-09-02 08:00:00	DIA	ETF	93.15	93.22	92.87	92.95	37758.0
2009-09-02 09:00:00	DIA	ETF	92.95	93.33	92.88	93.1	2068624.0
2009-09-02 10:00:00	DIA	ETF	93.09	93.42	92.71	93.37	2604505.0
2009-09-02 11:00:00	DIA	ETF	93.37	93.42	93.13	93.19	1269977.0

> showing 50 of 4,350 rows — these rows as CSV

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