PREVIEW / etf_1hour / 2008-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-15.parquet
  size:    106 KB
  rows:    3,480

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-15 04:00:00	SPY	ETF	130.17	130.17	130.11	130.11	300.0
2008-08-15 05:00:00	SPY	ETF	130.18	130.18	130.18	130.18	100.0
2008-08-15 06:00:00	SPY	ETF	130.01	130.05	129.97	129.97	52300.0
2008-08-15 07:00:00	SPY	ETF	130.07	130.13	129.65	129.71	724358.0
2008-08-15 08:00:00	SPY	ETF	129.9	130.24	129.68	129.91	2503663.0
2008-08-15 09:00:00	SPY	ETF	129.9	130.5	129.77	130.15	30625948.0
2008-08-15 10:00:00	SPY	ETF	130.15	130.35	129.3	130.31	46357653.0
2008-08-15 11:00:00	SPY	ETF	130.31	130.4	129.78	129.89	29599520.0
2008-08-15 12:00:00	SPY	ETF	129.89	130.12	129.63	129.98	12875135.0
2008-08-15 13:00:00	SPY	ETF	129.99	130.07	129.8	129.86	11625252.0
2008-08-15 14:00:00	SPY	ETF	129.855	129.91	129.63	129.82	14340764.0
2008-08-15 15:00:00	SPY	ETF	129.82	130.15	129.81	130.05	22616800.0
2008-08-15 16:00:00	SPY	ETF	130.05	130.25	129.95	130.16	6250772.0
2008-08-15 17:00:00	SPY	ETF	130.17	130.27	130.17	130.25	1248293.0
2008-08-15 18:00:00	SPY	ETF	130.25	130.26	130.22	130.22	3718.0
2008-08-15 19:00:00	SPY	ETF	130.22	130.25	130.22	130.22	1436.0
2008-08-15 04:00:00	QQQ	ETF	48.43	48.43	48.43	48.43	100.0
2008-08-15 05:00:00	QQQ	ETF	48.42	48.49	48.42	48.47	3500.0
2008-08-15 06:00:00	QQQ	ETF	48.41	48.41	48.41	48.41	500.0
2008-08-15 07:00:00	QQQ	ETF	48.45	48.48	48.3	48.3	258288.0
2008-08-15 08:00:00	QQQ	ETF	48.3	48.49	48.3	48.37	934623.0
2008-08-15 09:00:00	QQQ	ETF	48.37	48.57	48.28	48.38	18385350.0
2008-08-15 10:00:00	QQQ	ETF	48.38	48.51	48.0	48.48	40471708.0
2008-08-15 11:00:00	QQQ	ETF	48.49	48.49	48.16	48.2	13659415.0
2008-08-15 12:00:00	QQQ	ETF	48.19	48.35	48.15	48.28	8706147.0
2008-08-15 13:00:00	QQQ	ETF	48.29	48.32	48.11	48.13	6366563.0
2008-08-15 14:00:00	QQQ	ETF	48.13	48.16	47.96	48.09	15160496.0
2008-08-15 15:00:00	QQQ	ETF	48.09	48.25	48.07	48.17	13507992.0
2008-08-15 16:00:00	QQQ	ETF	48.13	48.31	48.13	48.26	2467683.0
2008-08-15 17:00:00	QQQ	ETF	48.26	48.3	48.25	48.3	21550.0
2008-08-15 18:00:00	QQQ	ETF	48.26	48.31	48.24	48.3	10800.0
2008-08-15 19:00:00	QQQ	ETF	48.3	48.3	48.27	48.3	7750.0
2008-08-15 06:00:00	IWM	ETF	75.67	75.67	75.67	75.67	3000.0
2008-08-15 07:00:00	IWM	ETF	75.7	75.78	75.54	75.55	99394.0
2008-08-15 08:00:00	IWM	ETF	75.55	75.81	75.3	75.7	853778.0
2008-08-15 09:00:00	IWM	ETF	75.69	76.27	75.5	75.8	17862786.0
2008-08-15 10:00:00	IWM	ETF	75.8	75.81	74.96	75.5	23123349.0
2008-08-15 11:00:00	IWM	ETF	75.5	75.5	75.0	75.05	9434995.0
2008-08-15 12:00:00	IWM	ETF	75.05	75.15	74.77	75.06	6615344.0
2008-08-15 13:00:00	IWM	ETF	75.07	75.16	74.88	74.9	6538691.0
2008-08-15 14:00:00	IWM	ETF	74.9	74.94	74.48	74.62	11380888.0
2008-08-15 15:00:00	IWM	ETF	74.62	75.2	74.62	75.19	12007395.0
2008-08-15 16:00:00	IWM	ETF	75.18	75.4	74.84	75.39	7017250.0
2008-08-15 17:00:00	IWM	ETF	75.4	75.41	75.33	75.41	10300.0
2008-08-15 07:00:00	DIA	ETF	116.67	116.67	116.32	116.32	4100.0
2008-08-15 08:00:00	DIA	ETF	116.26	116.72	116.25	116.48	106510.0
2008-08-15 09:00:00	DIA	ETF	116.48	117.07	116.3	116.78	2816745.0
2008-08-15 10:00:00	DIA	ETF	116.79	116.96	115.95	116.93	4406730.0
2008-08-15 11:00:00	DIA	ETF	116.94	116.97	116.35	116.44	2103205.0
2008-08-15 12:00:00	DIA	ETF	116.44	116.63	116.12	116.48	1609672.0

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

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