PREVIEW / etf_1hour / 2008-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-02.parquet
  size:    114 KB
  rows:    3,710

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
2008-10-02 05:00:00	SPY	ETF	115.8	115.98	115.76	115.98	3170.0
2008-10-02 06:00:00	SPY	ETF	115.88	116.1	115.65	115.87	42600.0
2008-10-02 07:00:00	SPY	ETF	115.84	115.88	115.05	115.09	967330.0
2008-10-02 08:00:00	SPY	ETF	115.12	116.45	114.63	114.95	4982702.0
2008-10-02 09:00:00	SPY	ETF	114.95	115.26	113.73	113.84	37082807.0
2008-10-02 10:00:00	SPY	ETF	113.84	113.84	112.82	113.09	44664675.0
2008-10-02 11:00:00	SPY	ETF	113.1	113.25	112.06	113.18	41439786.0
2008-10-02 12:00:00	SPY	ETF	113.17	113.47	112.59	112.89	26797522.0
2008-10-02 13:00:00	SPY	ETF	112.9	113.11	111.85	112.58	48156335.0
2008-10-02 14:00:00	SPY	ETF	112.58	112.92	111.46	112.32	42811782.0
2008-10-02 15:00:00	SPY	ETF	112.32	112.4	111.06	111.3	74870970.0
2008-10-02 16:00:00	SPY	ETF	111.35	116.0278	111.28	111.96	38966373.0
2008-10-02 17:00:00	SPY	ETF	111.94	116.1	111.74	111.8	3741287.0
2008-10-02 18:00:00	SPY	ETF	111.82	112.15	111.52	111.95	423144.0
2008-10-02 19:00:00	SPY	ETF	111.94	112.12	111.91	112.11	25958.0
2008-10-02 05:00:00	QQQ	ETF	38.87	38.87	38.85	38.85	4200.0
2008-10-02 06:00:00	QQQ	ETF	38.75	38.75	38.7	38.7	300.0
2008-10-02 07:00:00	QQQ	ETF	38.65	38.65	38.35	38.37	188133.0
2008-10-02 08:00:00	QQQ	ETF	38.37	38.85	38.11	38.25	1753709.0
2008-10-02 09:00:00	QQQ	ETF	38.24	38.33	37.65	37.66	19261238.0
2008-10-02 10:00:00	QQQ	ETF	37.66	37.67	37.1101	37.24	31005251.0
2008-10-02 11:00:00	QQQ	ETF	37.24	37.5	37.02	37.422	25119532.0
2008-10-02 12:00:00	QQQ	ETF	37.429	37.47	37.16	37.3	13129669.0
2008-10-02 13:00:00	QQQ	ETF	37.2905	37.2979	36.94	37.19	27643197.0
2008-10-02 14:00:00	QQQ	ETF	37.19	37.29	36.73	37.03	31375603.0
2008-10-02 15:00:00	QQQ	ETF	37.0217	37.05	36.64	36.68	34214082.0
2008-10-02 16:00:00	QQQ	ETF	36.678	37.36	36.66	37.0	5172087.0
2008-10-02 17:00:00	QQQ	ETF	37.0	37.0	36.92	36.96	52219.0
2008-10-02 18:00:00	QQQ	ETF	36.96	37.01	36.87	36.97	31170.0
2008-10-02 19:00:00	QQQ	ETF	36.96	37.07	36.96	37.0	47960.0
2008-10-02 07:00:00	IWM	ETF	67.17	67.25	66.78	66.79	37100.0
2008-10-02 08:00:00	IWM	ETF	66.79	67.77	66.53	66.59	515190.0
2008-10-02 09:00:00	IWM	ETF	66.62	66.83	65.82	65.91	8091550.0
2008-10-02 10:00:00	IWM	ETF	65.91	66.2	65.19	65.4	14180901.0
2008-10-02 11:00:00	IWM	ETF	65.4	65.46	64.7	65.41	13976925.0
2008-10-02 12:00:00	IWM	ETF	65.41	65.48	64.92	64.98	7950706.0
2008-10-02 13:00:00	IWM	ETF	64.98	65.06	64.26	64.52	16051903.0
2008-10-02 14:00:00	IWM	ETF	64.51	64.7	63.87	64.38	13344380.0
2008-10-02 15:00:00	IWM	ETF	64.38	64.39	63.42	63.52	19718765.0
2008-10-02 16:00:00	IWM	ETF	63.52	67.03	63.42	64.15	10693628.0
2008-10-02 17:00:00	IWM	ETF	64.1	64.1	64.1	64.1	611.0
2008-10-02 18:00:00	IWM	ETF	64.0	64.0	64.0	64.0	100.0
2008-10-02 19:00:00	IWM	ETF	63.93	63.93	63.93	63.93	100.0
2008-10-02 07:00:00	DIA	ETF	108.1	108.1	107.75	107.75	700.0
2008-10-02 08:00:00	DIA	ETF	108.01	108.03	107.3	107.48	59650.0
2008-10-02 09:00:00	DIA	ETF	107.45	107.65	106.5	106.56	1964081.0
2008-10-02 10:00:00	DIA	ETF	106.56	106.56	105.83	105.97	3105482.0
2008-10-02 11:00:00	DIA	ETF	105.94	106.1	105.2	106.0	3308647.0
2008-10-02 12:00:00	DIA	ETF	105.99	106.3	105.48	105.78	1335741.0
2008-10-02 13:00:00	DIA	ETF	105.77	106.03	104.97	105.57	2719935.0

> showing 50 of 3,710 rows — these rows as CSV

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