PREVIEW / etf_1hour / 2008-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-16.parquet
  size:    119 KB
  rows:    3,893

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-16 04:00:00	SPY	ETF	119.45	119.45	119.33	119.45	300.0
2008-09-16 05:00:00	SPY	ETF	119.88	120.25	119.79	120.22	8400.0
2008-09-16 06:00:00	SPY	ETF	120.22	120.22	118.95	119.01	1321029.0
2008-09-16 07:00:00	SPY	ETF	118.99	119.06	118.37	118.87	4742576.0
2008-09-16 08:00:00	SPY	ETF	118.87	119.3	117.34	117.61	23885490.0
2008-09-16 09:00:00	SPY	ETF	117.61	118.92	116.71	117.79	72832728.0
2008-09-16 10:00:00	SPY	ETF	117.79	120.58	117.79	120.03	95414773.0
2008-09-16 11:00:00	SPY	ETF	120.0299	121.0	118.66	119.82	67857529.0
2008-09-16 12:00:00	SPY	ETF	119.82	120.41	119.37	120.16	45918980.0
2008-09-16 13:00:00	SPY	ETF	120.16	120.45	119.47	119.7	31653261.0
2008-09-16 14:00:00	SPY	ETF	119.7	121.49	117.97	121.18	124504519.0
2008-09-16 15:00:00	SPY	ETF	121.19	122.09	120.71	121.88	69241138.0
2008-09-16 16:00:00	SPY	ETF	121.9	123.35	119.7612	120.29	26099817.0
2008-09-16 17:00:00	SPY	ETF	120.32	121.5	120.32	120.8	2409747.0
2008-09-16 18:00:00	SPY	ETF	120.76	122.1	118.6218	120.88	12201657.0
2008-09-16 19:00:00	SPY	ETF	120.87	123.25	120.87	122.63	2902112.0
2008-09-16 20:00:00	SPY	ETF	122.64	122.64	122.64	122.64	500.0
2008-09-16 04:00:00	QQQ	ETF	42.1	42.1	42.1	42.1	200.0
2008-09-16 05:00:00	QQQ	ETF	42.2	42.56	42.2	42.42	9900.0
2008-09-16 06:00:00	QQQ	ETF	42.47	42.47	42.22	42.24	6800.0
2008-09-16 07:00:00	QQQ	ETF	42.2	42.2	41.84	42.1	2200532.0
2008-09-16 08:00:00	QQQ	ETF	42.11	42.11	41.52	41.61	7695674.0
2008-09-16 09:00:00	QQQ	ETF	41.61	42.21	41.41	41.51	48595684.0
2008-09-16 10:00:00	QQQ	ETF	41.5	42.31	41.49	42.25	63214183.0
2008-09-16 11:00:00	QQQ	ETF	42.25	42.5	41.74	42.07	38407396.0
2008-09-16 12:00:00	QQQ	ETF	42.08	42.35	42.0	42.24	24644193.0
2008-09-16 13:00:00	QQQ	ETF	42.23	42.26	41.89	42.0	13440672.0
2008-09-16 14:00:00	QQQ	ETF	41.991	42.51	41.49	42.42	87557292.0
2008-09-16 15:00:00	QQQ	ETF	42.42	42.84	42.21	42.39	46788184.0
2008-09-16 16:00:00	QQQ	ETF	42.38	42.59	41.9642	42.02	7572471.0
2008-09-16 17:00:00	QQQ	ETF	42.1	42.38	42.09	42.19	660065.0
2008-09-16 18:00:00	QQQ	ETF	42.18	42.26	42.14	42.2	173917.0
2008-09-16 19:00:00	QQQ	ETF	42.23	42.8	42.23	42.76	804517.0
2008-09-16 05:00:00	IWM	ETF	69.56	69.56	69.56	69.56	200.0
2008-09-16 06:00:00	IWM	ETF	69.1	69.15	69.05	69.08	48300.0
2008-09-16 07:00:00	IWM	ETF	69.02	69.02	68.55	68.74	694138.0
2008-09-16 08:00:00	IWM	ETF	68.83	68.84	67.7	67.88	2318913.0
2008-09-16 09:00:00	IWM	ETF	67.86	69.54	67.52	68.2	26647630.0
2008-09-16 10:00:00	IWM	ETF	68.2	69.77	68.17	69.42	41511530.0
2008-09-16 11:00:00	IWM	ETF	69.42	69.83	68.68	69.57	34455800.0
2008-09-16 12:00:00	IWM	ETF	69.57	69.95	69.29	69.55	18064364.0
2008-09-16 13:00:00	IWM	ETF	69.53	69.77	69.38	69.45	12067141.0
2008-09-16 14:00:00	IWM	ETF	69.45	70.26	68.4	70.14	44734875.0
2008-09-16 15:00:00	IWM	ETF	70.14	70.97	69.85	70.91	44439321.0
2008-09-16 16:00:00	IWM	ETF	70.91	71.7	69.67	70.5	5061659.0
2008-09-16 17:00:00	IWM	ETF	70.44	70.93	70.44	70.78	237396.0
2008-09-16 18:00:00	IWM	ETF	70.7	70.85	68.92	70.8	4250535.0
2008-09-16 19:00:00	IWM	ETF	70.68	71.85	70.68	71.6	70023.0
2008-09-16 04:00:00	DIA	ETF	110.46	110.46	110.46	110.46	100.0
2008-09-16 06:00:00	DIA	ETF	109.43	109.43	109.21	109.21	6900.0

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

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