PREVIEW / etf_1hour / 2008-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-04.parquet
  size:    102 KB
  rows:    3,361

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-04 04:00:00	SPY	ETF	133.33	133.33	133.0	133.0	400.0
2008-03-04 05:00:00	SPY	ETF	132.79	132.79	132.49	132.49	3100.0
2008-03-04 06:00:00	SPY	ETF	132.58	132.62	132.0	132.25	245300.0
2008-03-04 07:00:00	SPY	ETF	132.25	132.65	132.2	132.44	803400.0
2008-03-04 08:00:00	SPY	ETF	132.44	132.73	132.03	132.52	2449500.0
2008-03-04 09:00:00	SPY	ETF	132.52	132.89	132.11	132.78	25799143.0
2008-03-04 10:00:00	SPY	ETF	132.78	133.0	131.74	131.76	35521209.0
2008-03-04 11:00:00	SPY	ETF	131.76	132.03	131.43	131.55	35127473.0
2008-03-04 12:00:00	SPY	ETF	131.56	132.1501	131.48	131.61	22831548.0
2008-03-04 13:00:00	SPY	ETF	131.6001	131.98	131.14	131.33	33649624.0
2008-03-04 14:00:00	SPY	ETF	131.34	132.4	130.99	131.83	50369169.0
2008-03-04 15:00:00	SPY	ETF	131.84	133.4	131.65	132.92	68299053.0
2008-03-04 16:00:00	SPY	ETF	132.85	133.4	131.45	133.31	4118000.0
2008-03-04 17:00:00	SPY	ETF	133.31	133.32	132.95	133.01	503700.0
2008-03-04 18:00:00	SPY	ETF	133.0	133.24	133.0	133.2	43100.0
2008-03-04 19:00:00	SPY	ETF	133.2	133.28	133.03	133.11	90900.0
2008-03-04 04:00:00	QQQ	ETF	42.68	42.68	42.68	42.68	300.0
2008-03-04 06:00:00	QQQ	ETF	42.41	42.41	42.22	42.22	156200.0
2008-03-04 07:00:00	QQQ	ETF	42.29	42.44	42.29	42.39	503872.0
2008-03-04 08:00:00	QQQ	ETF	42.42	42.5	42.31	42.44	1127339.0
2008-03-04 09:00:00	QQQ	ETF	42.46	42.52	42.32	42.4578	15171249.0
2008-03-04 10:00:00	QQQ	ETF	42.45	42.57	42.2	42.2	22326188.0
2008-03-04 11:00:00	QQQ	ETF	42.21	42.3	42.08	42.205	18004152.0
2008-03-04 12:00:00	QQQ	ETF	42.2	42.45	42.18	42.26	14580052.0
2008-03-04 13:00:00	QQQ	ETF	42.26	42.41	42.12	42.14	15417480.0
2008-03-04 14:00:00	QQQ	ETF	42.15	42.39	42.02	42.33	30977760.0
2008-03-04 15:00:00	QQQ	ETF	42.32	43.04	42.2775	42.91	57237397.0
2008-03-04 16:00:00	QQQ	ETF	42.91	43.05	42.14	43.0	8186891.0
2008-03-04 17:00:00	QQQ	ETF	43.0	43.0	42.88	42.92	132945.0
2008-03-04 18:00:00	QQQ	ETF	42.91	42.97	42.91	42.96	50357.0
2008-03-04 19:00:00	QQQ	ETF	42.97	42.98	42.93	42.94	45129.0
2008-03-04 07:00:00	IWM	ETF	67.57	67.74	67.55	67.73	19200.0
2008-03-04 08:00:00	IWM	ETF	67.61	68.24	67.49	67.67	430400.0
2008-03-04 09:00:00	IWM	ETF	67.75	67.87	67.33	67.69	8953393.0
2008-03-04 10:00:00	IWM	ETF	67.7	67.98	67.12	67.13	13730813.0
2008-03-04 11:00:00	IWM	ETF	67.13	67.32	66.93	67.06	7347812.0
2008-03-04 12:00:00	IWM	ETF	67.07	67.58	67.03	67.12	6076581.0
2008-03-04 13:00:00	IWM	ETF	67.13	67.5	66.88	66.94	11935191.0
2008-03-04 14:00:00	IWM	ETF	66.95	67.66	66.78	67.36	15723038.0
2008-03-04 15:00:00	IWM	ETF	67.37	68.43	67.15	67.79	22341519.0
2008-03-04 16:00:00	IWM	ETF	67.79	68.21	67.47	68.02	5043800.0
2008-03-04 17:00:00	IWM	ETF	67.8	67.85	67.7	67.7	36200.0
2008-03-04 18:00:00	IWM	ETF	67.76	67.93	67.76	67.93	3900.0
2008-03-04 19:00:00	IWM	ETF	67.9	67.9	67.9	67.9	300.0
2008-03-04 07:00:00	DIA	ETF	121.65	121.9	121.61	121.9	6100.0
2008-03-04 08:00:00	DIA	ETF	121.8	121.92	121.63	121.76	135600.0
2008-03-04 09:00:00	DIA	ETF	121.9	122.0	121.41	121.85	1597560.0
2008-03-04 10:00:00	DIA	ETF	121.86	122.06	121.1	121.13	2892962.0
2008-03-04 11:00:00	DIA	ETF	121.1	121.31	120.78	120.82	2119573.0
2008-03-04 12:00:00	DIA	ETF	120.84	121.34	120.74	120.86	1436090.0

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

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