PREVIEW / etf_1hour / 2008-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-06.parquet
  size:    109 KB
  rows:    3,504

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-08-06 04:00:00	SPY	ETF	128.4	128.4	128.4	128.4	400.0
2008-08-06 05:00:00	SPY	ETF	128.26	128.26	128.21	128.26	600.0
2008-08-06 06:00:00	SPY	ETF	128.19	128.19	127.91	128.1	123700.0
2008-08-06 07:00:00	SPY	ETF	128.1	128.2	127.98	128.03	1018549.0
2008-08-06 08:00:00	SPY	ETF	128.05	128.28	127.98	128.18	2078641.0
2008-08-06 09:00:00	SPY	ETF	128.15	128.26	127.78	128.07	25917889.0
2008-08-06 10:00:00	SPY	ETF	128.08	128.6123	127.48	127.85	32334357.0
2008-08-06 11:00:00	SPY	ETF	127.84	128.46	127.71	128.32	32260871.0
2008-08-06 12:00:00	SPY	ETF	128.33	128.73	128.26	128.435	23362718.0
2008-08-06 13:00:00	SPY	ETF	128.44	128.67	128.25	128.46	17906199.0
2008-08-06 14:00:00	SPY	ETF	128.47	129.3	128.375	129.18	30990984.0
2008-08-06 15:00:00	SPY	ETF	129.19	129.28	128.8	129.09	36148254.0
2008-08-06 16:00:00	SPY	ETF	129.09	129.1565	128.6124	128.9	5002324.0
2008-08-06 17:00:00	SPY	ETF	128.92	128.94	128.5	128.55	716956.0
2008-08-06 18:00:00	SPY	ETF	128.6	128.63	128.52	128.52	97521.0
2008-08-06 19:00:00	SPY	ETF	128.51	128.63	128.49	128.51	47568.0
2008-08-06 20:00:00	SPY	ETF	128.51	128.51	128.51	128.51	500.0
2008-08-06 04:00:00	QQQ	ETF	46.04	46.04	46.04	46.04	100.0
2008-08-06 06:00:00	QQQ	ETF	46.0	46.0	45.96	45.96	2400.0
2008-08-06 07:00:00	QQQ	ETF	46.02	46.07	45.98	46.0	215692.0
2008-08-06 08:00:00	QQQ	ETF	45.99	46.09	45.96	46.0	3706974.0
2008-08-06 09:00:00	QQQ	ETF	45.98	46.0	45.7	45.85	16019309.0
2008-08-06 10:00:00	QQQ	ETF	45.8599	45.89	45.58	45.69	18518005.0
2008-08-06 11:00:00	QQQ	ETF	45.69	46.23	45.6	46.22	23573391.0
2008-08-06 12:00:00	QQQ	ETF	46.22	46.43	46.19	46.26	13109917.0
2008-08-06 13:00:00	QQQ	ETF	46.25	46.48	46.2	46.34	10461435.0
2008-08-06 14:00:00	QQQ	ETF	46.34	46.81	46.31	46.7	17994268.0
2008-08-06 15:00:00	QQQ	ETF	46.7	46.77	46.52	46.63	20904388.0
2008-08-06 16:00:00	QQQ	ETF	46.63	46.65	46.2258	46.58	3232132.0
2008-08-06 17:00:00	QQQ	ETF	46.57	46.59	46.46	46.5	563000.0
2008-08-06 18:00:00	QQQ	ETF	46.5	46.51	46.45	46.49	123218.0
2008-08-06 19:00:00	QQQ	ETF	46.48	46.5	46.45	46.46	27516.0
2008-08-06 06:00:00	IWM	ETF	71.73	71.82	71.72	71.82	5240.0
2008-08-06 07:00:00	IWM	ETF	71.86	71.86	71.73	71.78	122073.0
2008-08-06 08:00:00	IWM	ETF	72.0	72.0	71.7	71.73	479993.0
2008-08-06 09:00:00	IWM	ETF	71.73	71.78	71.2	71.6	9066694.0
2008-08-06 10:00:00	IWM	ETF	71.59	71.65	71.25	71.35	12716692.0
2008-08-06 11:00:00	IWM	ETF	71.34	71.75	71.24	71.69	7990405.0
2008-08-06 12:00:00	IWM	ETF	71.68	72.14	71.63	71.9	9414506.0
2008-08-06 13:00:00	IWM	ETF	71.89	72.1	71.72	71.88	6857229.0
2008-08-06 14:00:00	IWM	ETF	71.88	72.66	71.83	72.54	11677343.0
2008-08-06 15:00:00	IWM	ETF	72.54	72.57	71.65	72.33	16008603.0
2008-08-06 16:00:00	IWM	ETF	72.34	72.58	72.31	72.4	1433326.0
2008-08-06 17:00:00	IWM	ETF	72.27	72.27	72.14	72.2	126859.0
2008-08-06 18:00:00	IWM	ETF	72.19	72.2	72.15	72.15	9700.0
2008-08-06 19:00:00	IWM	ETF	72.17	72.17	72.14	72.14	976.0
2008-08-06 06:00:00	DIA	ETF	115.8	115.8	115.55	115.55	400.0
2008-08-06 07:00:00	DIA	ETF	115.68	115.68	115.56	115.58	11500.0
2008-08-06 08:00:00	DIA	ETF	115.57	115.74	115.49	115.69	66522.0
2008-08-06 09:00:00	DIA	ETF	115.66	115.78	115.46	115.7	2093510.0

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

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