PREVIEW / etf_1hour / 2006-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-29.parquet
  size:    41 KB
  rows:    1,268

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
2006-03-29 04:00:00	SPY	ETF	129.49	129.57	129.49	129.57	1600.0
2006-03-29 06:00:00	SPY	ETF	129.45	129.45	129.45	129.45	100.0
2006-03-29 07:00:00	SPY	ETF	129.44	129.56	129.44	129.49	83500.0
2006-03-29 08:00:00	SPY	ETF	129.51	129.55	129.42	129.5	1458700.0
2006-03-29 09:00:00	SPY	ETF	129.53	129.6	129.31	129.39	5818800.0
2006-03-29 10:00:00	SPY	ETF	129.39	129.71	129.29	129.5	8819900.0
2006-03-29 11:00:00	SPY	ETF	129.5	130.27	129.43	130.11	13269200.0
2006-03-29 12:00:00	SPY	ETF	130.11	130.25	130.06	130.09	5674900.0
2006-03-29 13:00:00	SPY	ETF	130.1	130.5	130.03	130.28	6295100.0
2006-03-29 14:00:00	SPY	ETF	130.27	130.43	130.06	130.28	6638700.0
2006-03-29 15:00:00	SPY	ETF	130.27	130.48	130.16	130.21	7921600.0
2006-03-29 16:00:00	SPY	ETF	130.21	130.22	130.0	130.04	1613800.0
2006-03-29 17:00:00	SPY	ETF	130.05	130.08	130.0	130.0	70000.0
2006-03-29 18:00:00	SPY	ETF	130.0	130.05	129.98	130.0	26200.0
2006-03-29 19:00:00	SPY	ETF	130.0	130.06	130.0	130.06	3400.0
2006-03-29 09:00:00	QQQ	ETF	41.2	41.28	41.17	41.22	8246400.0
2006-03-29 10:00:00	QQQ	ETF	41.22	41.46	41.18	41.36	16955500.0
2006-03-29 11:00:00	QQQ	ETF	41.36	41.78	41.35	41.73	24950200.0
2006-03-29 12:00:00	QQQ	ETF	41.73	41.79	41.55	41.73	9451200.0
2006-03-29 13:00:00	QQQ	ETF	41.73	41.94	41.72	41.88	21048700.0
2006-03-29 14:00:00	QQQ	ETF	41.87	42.1	41.83	41.91	25641200.0
2006-03-29 15:00:00	QQQ	ETF	41.91	42.06	41.82	41.9	21358900.0
2006-03-29 08:00:00	IWM	ETF	75.3	75.3	74.63	74.72	212300.0
2006-03-29 09:00:00	IWM	ETF	74.73	74.9	74.65	74.81	2552300.0
2006-03-29 10:00:00	IWM	ETF	74.81	75.15	74.69	75.02	3702500.0
2006-03-29 11:00:00	IWM	ETF	75.0494	75.59	74.98	75.57	6353900.0
2006-03-29 12:00:00	IWM	ETF	75.57	75.7	75.57	75.61	2648500.0
2006-03-29 13:00:00	IWM	ETF	75.62	75.91	75.58	75.78	4837600.0
2006-03-29 14:00:00	IWM	ETF	75.77	75.9	75.63	75.72	3400000.0
2006-03-29 15:00:00	IWM	ETF	75.7375	75.93	75.7	75.92	6965900.0
2006-03-29 16:00:00	IWM	ETF	75.92	75.96	75.8	75.87	2066400.0
2006-03-29 17:00:00	IWM	ETF	75.88	75.89	75.78	75.78	2300.0
2006-03-29 18:00:00	IWM	ETF	75.88	75.88	75.86	75.87	124200.0
2006-03-29 08:00:00	DIA	ETF	111.77	111.8	111.73	111.73	8600.0
2006-03-29 09:00:00	DIA	ETF	111.73	111.78	111.58	111.68	663500.0
2006-03-29 10:00:00	DIA	ETF	111.66	111.76	111.48	111.54	1288900.0
2006-03-29 11:00:00	DIA	ETF	111.53	112.18	111.49	112.05	2346600.0
2006-03-29 12:00:00	DIA	ETF	112.03	112.11	111.92	111.93	790500.0
2006-03-29 13:00:00	DIA	ETF	111.95	112.3	111.93	112.17	1195100.0
2006-03-29 14:00:00	DIA	ETF	112.17	112.28	112.0	112.17	751300.0
2006-03-29 15:00:00	DIA	ETF	112.17	112.36	112.05	112.07	713600.0
2006-03-29 16:00:00	DIA	ETF	112.07	112.07	111.94	111.94	51400.0
2006-03-29 17:00:00	DIA	ETF	111.94	112.03	111.94	112.03	800.0
2006-03-29 07:00:00	GLD	ETF	56.03	56.05	55.98	55.98	6500.0
2006-03-29 08:00:00	GLD	ETF	55.95	56.26	55.95	56.23	279700.0
2006-03-29 09:00:00	GLD	ETF	56.18	56.47	56.13	56.32	1508800.0
2006-03-29 10:00:00	GLD	ETF	56.31	56.5	56.26	56.47	373500.0
2006-03-29 11:00:00	GLD	ETF	56.47	56.69	56.46	56.62	606500.0
2006-03-29 12:00:00	GLD	ETF	56.63	56.97	56.57	56.96	497600.0
2006-03-29 13:00:00	GLD	ETF	56.95	57.15	56.89	57.0	1466800.0

> showing 50 of 1,268 rows — these rows as CSV

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