PREVIEW / etf_1hour / 2008-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-29.parquet
  size:    126 KB
  rows:    4,150

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-09-29 04:00:00	SPY	ETF	118.42	118.42	118.42	118.42	2000.0
2008-09-29 05:00:00	SPY	ETF	118.94	118.99	118.51	118.51	7300.0
2008-09-29 06:00:00	SPY	ETF	118.67	119.07	118.5	118.9	98890.0
2008-09-29 07:00:00	SPY	ETF	118.91	119.18	118.53	119.01	1130764.0
2008-09-29 08:00:00	SPY	ETF	119.01	120.55	118.6	119.17	6758861.0
2008-09-29 09:00:00	SPY	ETF	119.15	120.85	116.4	117.14	52055073.0
2008-09-29 10:00:00	SPY	ETF	117.14	117.94	115.99	117.05	64318779.0
2008-09-29 11:00:00	SPY	ETF	117.05	121.1793	116.25	116.68	34917488.0
2008-09-29 12:00:00	SPY	ETF	116.6784	121.1793	115.76	116.48	35799961.0
2008-09-29 13:00:00	SPY	ETF	116.47	117.24	111.01	114.1	99805761.0
2008-09-29 14:00:00	SPY	ETF	114.11	116.66	111.71	113.199	74695489.0
2008-09-29 15:00:00	SPY	ETF	113.2	121.18	110.97	112.83	59755613.0
2008-09-29 16:00:00	SPY	ETF	112.79	121.1793	110.52	111.37	11493635.0
2008-09-29 17:00:00	SPY	ETF	111.33	121.179	111.25	111.6	2056152.0
2008-09-29 18:00:00	SPY	ETF	111.58	111.85	111.5	111.8	213853.0
2008-09-29 19:00:00	SPY	ETF	111.8	113.47	110.98	111.74	13900498.0
2008-09-29 04:00:00	QQQ	ETF	40.24	40.24	40.24	40.24	100.0
2008-09-29 07:00:00	QQQ	ETF	40.33	40.47	40.23	40.35	233537.0
2008-09-29 08:00:00	QQQ	ETF	40.35	40.7	39.9	40.28	2564466.0
2008-09-29 09:00:00	QQQ	ETF	40.28	40.38	39.09	39.28	33268661.0
2008-09-29 10:00:00	QQQ	ETF	39.28	39.44	38.62	39.11	51758805.0
2008-09-29 11:00:00	QQQ	ETF	39.11	39.17	38.77	38.8695	22014302.0
2008-09-29 12:00:00	QQQ	ETF	38.87	39.07	38.69	38.91	25911780.0
2008-09-29 13:00:00	QQQ	ETF	38.91	39.09	37.71	38.15	53652683.0
2008-09-29 14:00:00	QQQ	ETF	38.15	38.51	37.6	37.87	47280283.0
2008-09-29 15:00:00	QQQ	ETF	37.865	38.24	37.18	37.45	50156412.0
2008-09-29 16:00:00	QQQ	ETF	37.45	41.1082	36.75	37.1	13917115.0
2008-09-29 17:00:00	QQQ	ETF	37.13	41.1082	37.04	37.15	1322082.0
2008-09-29 18:00:00	QQQ	ETF	37.16	37.24	37.14	37.19	111159.0
2008-09-29 19:00:00	QQQ	ETF	37.19	37.33	37.19	37.29	118525.0
2008-09-29 07:00:00	IWM	ETF	68.98	69.3	68.98	69.27	52807.0
2008-09-29 08:00:00	IWM	ETF	69.34	69.49	68.8	69.32	146100.0
2008-09-29 09:00:00	IWM	ETF	69.29	69.38	67.98	68.36	17067059.0
2008-09-29 10:00:00	IWM	ETF	68.35	68.72	67.85	68.67	26291891.0
2008-09-29 11:00:00	IWM	ETF	68.67	68.9	68.32	68.39	13472972.0
2008-09-29 12:00:00	IWM	ETF	68.38	70.33	67.47	68.13	15017360.0
2008-09-29 13:00:00	IWM	ETF	68.12	68.38	65.56	66.81	24724357.0
2008-09-29 14:00:00	IWM	ETF	66.81	67.61	66.29	66.63	19833601.0
2008-09-29 15:00:00	IWM	ETF	66.64	66.84	65.51	65.59	16387910.0
2008-09-29 16:00:00	IWM	ETF	65.57	70.33	64.78	70.33	6363223.0
2008-09-29 17:00:00	IWM	ETF	64.82	65.5	64.8	64.87	100766.0
2008-09-29 18:00:00	IWM	ETF	64.85	65.0	64.85	65.0	775.0
2008-09-29 19:00:00	IWM	ETF	64.91	66.55	64.85	65.0	2711959.0
2008-09-29 07:00:00	DIA	ETF	109.4	109.81	109.07	109.75	5870.0
2008-09-29 08:00:00	DIA	ETF	109.74	110.13	109.38	109.78	377140.0
2008-09-29 09:00:00	DIA	ETF	109.82	109.99	107.92	108.49	4099145.0
2008-09-29 10:00:00	DIA	ETF	108.46	109.13	107.8	108.78	5921104.0
2008-09-29 11:00:00	DIA	ETF	108.81	109.05	108.21	108.73	2527971.0
2008-09-29 12:00:00	DIA	ETF	108.7	109.09	107.97	108.59	2501743.0
2008-09-29 13:00:00	DIA	ETF	108.59	109.47	104.24	106.54	8070897.0

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

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