PREVIEW / etf_1hour / 2008-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-14.parquet
  size:    104 KB
  rows:    3,449

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-03-14 04:00:00	SPY	ETF	130.89	131.28	130.82	131.28	5300.0
2008-03-14 05:00:00	SPY	ETF	131.24	131.46	131.24	131.46	11000.0
2008-03-14 06:00:00	SPY	ETF	131.5	131.61	131.32	131.36	49200.0
2008-03-14 07:00:00	SPY	ETF	131.31	131.31	130.65	131.0	1159000.0
2008-03-14 08:00:00	SPY	ETF	131.01	132.93	130.67	132.63	19196200.0
2008-03-14 09:00:00	SPY	ETF	132.63	133.76	129.42	129.43	79058908.0
2008-03-14 10:00:00	SPY	ETF	129.44	131.0	128.0	129.99	108330737.0
2008-03-14 11:00:00	SPY	ETF	130.01	130.5	129.2	129.68	37794314.0
2008-03-14 12:00:00	SPY	ETF	129.68	130.11	128.97	129.38	34137068.0
2008-03-14 13:00:00	SPY	ETF	129.39	129.46	128.7	128.84	33190214.0
2008-03-14 14:00:00	SPY	ETF	128.8	129.08	127.78	128.5	59764987.0
2008-03-14 15:00:00	SPY	ETF	128.5	132.0	128.2	129.251	84235295.0
2008-03-14 16:00:00	SPY	ETF	129.289	129.9	128.78	129.65	13585300.0
2008-03-14 17:00:00	SPY	ETF	129.7	131.9624	129.4	129.5	3807900.0
2008-03-14 18:00:00	SPY	ETF	129.52	129.81	129.52	129.77	72800.0
2008-03-14 19:00:00	SPY	ETF	129.75	129.76	129.6	129.6	12600.0
2008-03-14 04:00:00	QQQ	ETF	42.82	42.82	42.8	42.8	200.0
2008-03-14 05:00:00	QQQ	ETF	42.92	42.92	42.92	42.92	200.0
2008-03-14 07:00:00	QQQ	ETF	42.92	42.93	42.72	42.83	831058.0
2008-03-14 08:00:00	QQQ	ETF	42.84	43.64	42.8	43.47	10087938.0
2008-03-14 09:00:00	QQQ	ETF	43.49	43.68	42.24	42.25	45912088.0
2008-03-14 10:00:00	QQQ	ETF	42.25	42.8	41.81	42.49	71802348.0
2008-03-14 11:00:00	QQQ	ETF	42.48	42.61	42.15	42.342	36827084.0
2008-03-14 12:00:00	QQQ	ETF	42.35	42.47	42.06	42.24	23758063.0
2008-03-14 13:00:00	QQQ	ETF	42.24	42.29	42.01	42.08	25321326.0
2008-03-14 14:00:00	QQQ	ETF	42.07	42.12	41.74	41.96	33090854.0
2008-03-14 15:00:00	QQQ	ETF	41.96	42.57	41.87	42.24	51232814.0
2008-03-14 16:00:00	QQQ	ETF	42.24	43.08	42.01	42.32	10561716.0
2008-03-14 17:00:00	QQQ	ETF	42.31	42.33	42.27	42.29	78672.0
2008-03-14 18:00:00	QQQ	ETF	42.29	42.3	42.22	42.24	88529.0
2008-03-14 19:00:00	QQQ	ETF	42.26	42.31	42.22	42.24	17738.0
2008-03-14 05:00:00	IWM	ETF	67.77	67.77	67.77	67.77	2500.0
2008-03-14 07:00:00	IWM	ETF	67.55	67.58	67.33	67.55	102600.0
2008-03-14 08:00:00	IWM	ETF	67.56	68.73	67.46	68.53	3434800.0
2008-03-14 09:00:00	IWM	ETF	68.53	68.89	65.99	66.01	24329231.0
2008-03-14 10:00:00	IWM	ETF	66.01	67.18	65.61	66.54	43010402.0
2008-03-14 11:00:00	IWM	ETF	66.55	66.91	65.98	66.39	18474204.0
2008-03-14 12:00:00	IWM	ETF	66.39	66.65	65.84	66.05	11032446.0
2008-03-14 13:00:00	IWM	ETF	66.05	66.42	65.74	65.98	9676647.0
2008-03-14 14:00:00	IWM	ETF	65.97	66.01	65.35	65.85	16654987.0
2008-03-14 15:00:00	IWM	ETF	65.85	68.06	65.55	66.06	34541266.0
2008-03-14 16:00:00	IWM	ETF	66.08	66.42	65.88	66.15	16656500.0
2008-03-14 17:00:00	IWM	ETF	66.25	66.35	66.25	66.35	2900.0
2008-03-14 18:00:00	IWM	ETF	66.15	66.15	66.15	66.15	1000.0
2008-03-14 19:00:00	IWM	ETF	66.16	66.16	66.16	66.16	100.0
2008-03-14 07:00:00	DIA	ETF	120.83	120.88	120.69	120.88	1400.0
2008-03-14 08:00:00	DIA	ETF	120.87	122.46	120.76	122.24	194600.0
2008-03-14 09:00:00	DIA	ETF	122.34	123.03	119.62	119.64	4203830.0
2008-03-14 10:00:00	DIA	ETF	119.64	120.98	118.64	120.32	7523570.0
2008-03-14 11:00:00	DIA	ETF	120.31	120.67	119.63	119.91	2440939.0

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

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