PREVIEW / etf_1hour / 2008-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-07.parquet
  size:    114 KB
  rows:    3,623

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-07 04:00:00	SPY	ETF	126.41	126.41	126.0	126.0	300.0
2008-07-07 05:00:00	SPY	ETF	126.02	126.26	126.02	126.22	5120.0
2008-07-07 06:00:00	SPY	ETF	126.22	126.45	126.22	126.24	13800.0
2008-07-07 07:00:00	SPY	ETF	126.22	126.52	126.0	126.47	868366.0
2008-07-07 08:00:00	SPY	ETF	126.47	126.66	126.21	126.32	2465516.0
2008-07-07 09:00:00	SPY	ETF	126.34	127.34	126.34	127.2899	29093667.0
2008-07-07 10:00:00	SPY	ETF	127.28	127.33	126.66	126.79	40839623.0
2008-07-07 11:00:00	SPY	ETF	126.79	127.05	126.36	126.47	32587835.0
2008-07-07 12:00:00	SPY	ETF	126.47	126.61	124.51	124.57	63777952.0
2008-07-07 13:00:00	SPY	ETF	124.57	124.95	124.0	124.315	51377727.0
2008-07-07 14:00:00	SPY	ETF	124.33	124.65	123.92	124.43	53196000.0
2008-07-07 15:00:00	SPY	ETF	124.42	127.02	124.11	125.09	83210184.0
2008-07-07 16:00:00	SPY	ETF	125.088	126.9479	124.3862	125.09	6744121.0
2008-07-07 17:00:00	SPY	ETF	125.06	125.12	125.02	125.11	142251.0
2008-07-07 18:00:00	SPY	ETF	125.11	125.2	125.11	125.2	48149.0
2008-07-07 19:00:00	SPY	ETF	125.16	125.16	125.07	125.1	32690.0
2008-07-07 04:00:00	QQQ	ETF	44.75	44.75	44.69	44.69	6200.0
2008-07-07 06:00:00	QQQ	ETF	44.78	44.78	44.78	44.78	2000.0
2008-07-07 07:00:00	QQQ	ETF	44.7	44.92	44.67	44.89	171398.0
2008-07-07 08:00:00	QQQ	ETF	44.9	44.97	44.81	44.83	1740353.0
2008-07-07 09:00:00	QQQ	ETF	44.84	45.45	44.83	45.43	20843662.0
2008-07-07 10:00:00	QQQ	ETF	45.44	45.46	45.16	45.28	18563516.0
2008-07-07 11:00:00	QQQ	ETF	45.2805	45.37	45.09	45.18	13843692.0
2008-07-07 12:00:00	QQQ	ETF	45.18	45.24	44.47	44.49	23783362.0
2008-07-07 13:00:00	QQQ	ETF	44.4995	44.61	44.31	44.41	21128729.0
2008-07-07 14:00:00	QQQ	ETF	44.4026	44.6	44.24	44.47	19748457.0
2008-07-07 15:00:00	QQQ	ETF	44.47	45.36	44.47	44.91	51661490.0
2008-07-07 16:00:00	QQQ	ETF	44.92	45.2725	44.87	44.99	3720868.0
2008-07-07 17:00:00	QQQ	ETF	44.95	44.99	44.95	44.98	8020.0
2008-07-07 18:00:00	QQQ	ETF	44.94	45.0	44.94	44.95	10786.0
2008-07-07 19:00:00	QQQ	ETF	44.95	45.0	44.95	45.0	36456.0
2008-07-07 07:00:00	IWM	ETF	66.49	66.7	66.49	66.7	8000.0
2008-07-07 08:00:00	IWM	ETF	66.72	66.82	66.45	66.56	201044.0
2008-07-07 09:00:00	IWM	ETF	66.59	67.04	66.57	66.97	10759423.0
2008-07-07 10:00:00	IWM	ETF	66.96	66.97	66.33	66.35	11699360.0
2008-07-07 11:00:00	IWM	ETF	66.35	66.43	66.04	66.17	9445211.0
2008-07-07 12:00:00	IWM	ETF	66.17	66.2	65.12	65.14	16403643.0
2008-07-07 13:00:00	IWM	ETF	65.14	65.38	64.99	65.19	11095152.0
2008-07-07 14:00:00	IWM	ETF	65.18	65.42	64.94	65.15	17815436.0
2008-07-07 15:00:00	IWM	ETF	65.15	66.38	65.14	65.65	32108127.0
2008-07-07 16:00:00	IWM	ETF	65.66	66.36	65.4	65.65	5927466.0
2008-07-07 17:00:00	IWM	ETF	65.64	65.67	65.53	65.53	4008.0
2008-07-07 18:00:00	IWM	ETF	65.62	65.68	65.62	65.65	2400.0
2008-07-07 19:00:00	IWM	ETF	65.62	65.66	65.62	65.66	5475.0
2008-07-07 07:00:00	DIA	ETF	112.87	113.19	112.87	113.17	1816.0
2008-07-07 08:00:00	DIA	ETF	113.12	113.24	112.97	112.98	54904.0
2008-07-07 09:00:00	DIA	ETF	113.03	113.92	113.02	113.86	3061683.0
2008-07-07 10:00:00	DIA	ETF	113.86	113.89	113.39	113.61	3072983.0
2008-07-07 11:00:00	DIA	ETF	113.61	113.83	113.29	113.45	2448413.0
2008-07-07 12:00:00	DIA	ETF	113.46	113.61	111.66	111.72	5847615.0

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

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