PREVIEW / etf_1hour / 2008-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-11.parquet
  size:    107 KB
  rows:    3,542

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-11 04:00:00	SPY	ETF	128.36	128.36	128.22	128.22	2700.0
2008-03-11 05:00:00	SPY	ETF	128.58	128.76	128.58	128.76	900.0
2008-03-11 06:00:00	SPY	ETF	128.9	128.9	128.66	128.85	41900.0
2008-03-11 07:00:00	SPY	ETF	128.84	129.0	128.6	128.65	1271600.0
2008-03-11 08:00:00	SPY	ETF	128.65	131.26	128.3	130.84	30436411.0
2008-03-11 09:00:00	SPY	ETF	130.84	131.04	128.35	130.16	39780694.0
2008-03-11 10:00:00	SPY	ETF	130.15	130.53	129.9	130.3	33532382.0
2008-03-11 11:00:00	SPY	ETF	130.3	130.5	129.0	129.22	41551341.0
2008-03-11 12:00:00	SPY	ETF	129.22	129.77	128.95	129.56	35017566.0
2008-03-11 13:00:00	SPY	ETF	129.55	130.37	129.28	130.3	35459419.0
2008-03-11 14:00:00	SPY	ETF	130.29	131.53	130.2	131.28	52057285.0
2008-03-11 15:00:00	SPY	ETF	131.27	132.46	131.07	132.39	54312159.0
2008-03-11 16:00:00	SPY	ETF	132.351	132.77	131.38	132.75	11739920.0
2008-03-11 17:00:00	SPY	ETF	132.76	133.07	130.59	133.06	2450800.0
2008-03-11 18:00:00	SPY	ETF	133.05	133.15	132.9	132.91	211700.0
2008-03-11 19:00:00	SPY	ETF	132.94	133.0	132.75	132.85	50100.0
2008-03-11 04:00:00	QQQ	ETF	41.35	41.37	41.34	41.37	2700.0
2008-03-11 05:00:00	QQQ	ETF	41.34	41.43	41.33	41.4	24300.0
2008-03-11 06:00:00	QQQ	ETF	41.41	41.46	41.37	41.43	25200.0
2008-03-11 07:00:00	QQQ	ETF	41.41	41.47	41.29	41.3	933749.0
2008-03-11 08:00:00	QQQ	ETF	41.3	42.09	41.18	41.97	12083455.0
2008-03-11 09:00:00	QQQ	ETF	41.97	42.19	41.85	41.88	31123787.0
2008-03-11 10:00:00	QQQ	ETF	41.88	42.05	41.74	41.985	21150698.0
2008-03-11 11:00:00	QQQ	ETF	41.99	42.03	41.59	41.68	19338598.0
2008-03-11 12:00:00	QQQ	ETF	41.68	41.86	41.51	41.72	17282248.0
2008-03-11 13:00:00	QQQ	ETF	41.72	42.09	41.66	42.06	21034257.0
2008-03-11 14:00:00	QQQ	ETF	42.06	42.45	42.02	42.3495	25021774.0
2008-03-11 15:00:00	QQQ	ETF	42.35	42.85	42.28	42.84	35454521.0
2008-03-11 16:00:00	QQQ	ETF	42.8125	43.14	42.505	43.08	11801611.0
2008-03-11 17:00:00	QQQ	ETF	43.07	43.1	42.8301	43.06	763434.0
2008-03-11 18:00:00	QQQ	ETF	43.06	43.14	43.03	43.07	206469.0
2008-03-11 19:00:00	QQQ	ETF	43.08	43.13	43.07	43.1	54584.0
2008-03-11 07:00:00	IWM	ETF	65.01	65.1	64.86	64.9	281200.0
2008-03-11 08:00:00	IWM	ETF	64.9	66.5	64.5	66.33	8464003.0
2008-03-11 09:00:00	IWM	ETF	66.33	66.56	65.74	65.75	11197044.0
2008-03-11 10:00:00	IWM	ETF	65.74	66.3	65.63	66.1	19626918.0
2008-03-11 11:00:00	IWM	ETF	66.1	66.14	65.09	65.2	11923252.0
2008-03-11 12:00:00	IWM	ETF	65.21	65.68	65.11	65.45	10539230.0
2008-03-11 13:00:00	IWM	ETF	65.45	66.04	65.29	65.96	10441555.0
2008-03-11 14:00:00	IWM	ETF	65.96	66.82	65.9	66.71	20574742.0
2008-03-11 15:00:00	IWM	ETF	66.71	67.23	66.45	67.23	21008555.0
2008-03-11 16:00:00	IWM	ETF	67.23	67.35	66.12	67.24	3710600.0
2008-03-11 17:00:00	IWM	ETF	67.18	67.4	67.18	67.29	59400.0
2008-03-11 18:00:00	IWM	ETF	67.35	67.35	67.28	67.34	1200.0
2008-03-11 19:00:00	IWM	ETF	67.33	67.33	67.22	67.22	1600.0
2008-03-11 05:00:00	DIA	ETF	118.08	118.08	118.08	118.08	100.0
2008-03-11 06:00:00	DIA	ETF	118.5	118.5	118.5	118.5	100.0
2008-03-11 07:00:00	DIA	ETF	118.71	118.71	118.6	118.6	25600.0
2008-03-11 08:00:00	DIA	ETF	118.56	120.5	118.38	120.22	806900.0
2008-03-11 09:00:00	DIA	ETF	120.23	120.42	119.81	119.89	2899979.0

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

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