PREVIEW / etf_1hour / 2008-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-31.parquet
  size:    109 KB
  rows:    3,505

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-07-31 04:00:00	SPY	ETF	128.25	128.26	128.25	128.26	7583.0
2008-07-31 05:00:00	SPY	ETF	128.29	128.3	128.26	128.3	22600.0
2008-07-31 06:00:00	SPY	ETF	128.37	128.58	128.37	128.55	12300.0
2008-07-31 07:00:00	SPY	ETF	128.47	128.88	128.47	128.83	1213496.0
2008-07-31 08:00:00	SPY	ETF	128.85	129.08	127.56	127.58	13183505.0
2008-07-31 09:00:00	SPY	ETF	127.58	128.4787	127.24	128.05	46345917.0
2008-07-31 10:00:00	SPY	ETF	128.05	128.57	127.74	128.56	49444708.0
2008-07-31 11:00:00	SPY	ETF	128.55	128.57	127.61	127.8	28382042.0
2008-07-31 12:00:00	SPY	ETF	127.805	127.86	127.17	127.56	30696761.0
2008-07-31 13:00:00	SPY	ETF	127.56	128.02	127.3	127.61	21594102.0
2008-07-31 14:00:00	SPY	ETF	127.61	128.35	127.58	128.03	28570082.0
2008-07-31 15:00:00	SPY	ETF	128.04	128.23	126.63	126.84	50550827.0
2008-07-31 16:00:00	SPY	ETF	126.8	127.8081	126.6	126.84	5093452.0
2008-07-31 17:00:00	SPY	ETF	126.87	126.87	126.8	126.8	46838.0
2008-07-31 18:00:00	SPY	ETF	126.81	126.87	126.74	126.84	122561.0
2008-07-31 19:00:00	SPY	ETF	126.87	126.91	126.86	126.91	23801.0
2008-07-31 05:00:00	QQQ	ETF	45.49	45.49	45.49	45.49	100.0
2008-07-31 06:00:00	QQQ	ETF	45.59	45.59	45.59	45.59	100.0
2008-07-31 07:00:00	QQQ	ETF	45.63	45.73	45.63	45.71	101050.0
2008-07-31 08:00:00	QQQ	ETF	45.72	45.81	45.17	45.18	5178147.0
2008-07-31 09:00:00	QQQ	ETF	45.18	45.86	45.0	45.76	33689380.0
2008-07-31 10:00:00	QQQ	ETF	45.75	46.15	45.63	46.04	36264750.0
2008-07-31 11:00:00	QQQ	ETF	46.048	46.07	45.71	45.82	18412112.0
2008-07-31 12:00:00	QQQ	ETF	45.82	45.9	45.52	45.78	18997451.0
2008-07-31 13:00:00	QQQ	ETF	45.78	45.99	45.78	45.83	12773024.0
2008-07-31 14:00:00	QQQ	ETF	45.83	46.07	45.81	45.93	16243405.0
2008-07-31 15:00:00	QQQ	ETF	45.94	46.02	45.44	45.45	29848620.0
2008-07-31 16:00:00	QQQ	ETF	45.45	45.85	45.4472	45.56	2816041.0
2008-07-31 17:00:00	QQQ	ETF	45.57	45.58	45.52	45.53	81787.0
2008-07-31 18:00:00	QQQ	ETF	45.53	45.53	45.47	45.5	29985.0
2008-07-31 19:00:00	QQQ	ETF	45.49	45.52	45.48	45.5	13274.0
2008-07-31 07:00:00	IWM	ETF	71.64	71.77	71.64	71.72	114509.0
2008-07-31 08:00:00	IWM	ETF	71.72	71.84	70.83	70.86	2128929.0
2008-07-31 09:00:00	IWM	ETF	70.86	71.68	70.7	71.44	12781149.0
2008-07-31 10:00:00	IWM	ETF	71.43	72.01	71.27	71.91	13984444.0
2008-07-31 11:00:00	IWM	ETF	71.89	71.94	71.25	71.42	11842088.0
2008-07-31 12:00:00	IWM	ETF	71.41	71.47	71.1	71.39	7414394.0
2008-07-31 13:00:00	IWM	ETF	71.39	71.85	71.37	71.52	7384908.0
2008-07-31 14:00:00	IWM	ETF	71.53	71.95	71.45	71.75	10782249.0
2008-07-31 15:00:00	IWM	ETF	71.75	71.91	71.03	71.04	19361918.0
2008-07-31 16:00:00	IWM	ETF	71.04	71.51	70.88	71.24	6983717.0
2008-07-31 17:00:00	IWM	ETF	71.17	71.19	71.17	71.19	31000.0
2008-07-31 18:00:00	IWM	ETF	71.15	71.15	71.15	71.15	6700.0
2008-07-31 19:00:00	IWM	ETF	71.15	71.15	71.15	71.15	400.0
2008-07-31 07:00:00	DIA	ETF	115.97	116.09	115.97	116.06	8631.0
2008-07-31 08:00:00	DIA	ETF	116.08	116.14	114.86	114.86	628008.0
2008-07-31 09:00:00	DIA	ETF	114.8	115.35	114.48	115.17	3660792.0
2008-07-31 10:00:00	DIA	ETF	115.16	115.56	114.97	115.52	5322712.0
2008-07-31 11:00:00	DIA	ETF	115.51	115.54	114.6	114.75	2522184.0
2008-07-31 12:00:00	DIA	ETF	114.74	114.81	114.22	114.51	2034012.0

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

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