PREVIEW / etf_1hour / 2006-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-25.parquet
  size:    39 KB
  rows:    1,204

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-01-25 06:00:00	SPY	ETF	126.95	126.95	126.95	126.95	1000.0
2006-01-25 07:00:00	SPY	ETF	126.99	127.12	126.99	127.04	92100.0
2006-01-25 08:00:00	SPY	ETF	127.01	127.13	126.92	126.97	996200.0
2006-01-25 09:00:00	SPY	ETF	126.96	127.11	126.85	127.02	5304600.0
2006-01-25 10:00:00	SPY	ETF	127.02	127.18	126.28	126.84	20410100.0
2006-01-25 11:00:00	SPY	ETF	126.82	126.99	126.4	126.57	9639500.0
2006-01-25 12:00:00	SPY	ETF	126.58	126.6	126.01	126.55	12576800.0
2006-01-25 13:00:00	SPY	ETF	126.58	126.77	126.22	126.3101	5529500.0
2006-01-25 14:00:00	SPY	ETF	126.31	126.44	125.84	125.92	11795300.0
2006-01-25 15:00:00	SPY	ETF	125.93	126.49	125.89	126.47	12011700.0
2006-01-25 16:00:00	SPY	ETF	126.49	126.84	126.3744	126.81	1885800.0
2006-01-25 17:00:00	SPY	ETF	126.81	126.81	126.73	126.73	25400.0
2006-01-25 18:00:00	SPY	ETF	126.74	126.79	126.73	126.75	25900.0
2006-01-25 19:00:00	SPY	ETF	126.76	126.87	126.75	126.86	6600.0
2006-01-25 09:00:00	QQQ	ETF	41.64	41.67	41.52	41.54	8271300.0
2006-01-25 10:00:00	QQQ	ETF	41.53	41.6	41.15	41.38	21191900.0
2006-01-25 11:00:00	QQQ	ETF	41.38	41.54	41.22	41.34	13009800.0
2006-01-25 12:00:00	QQQ	ETF	41.34	41.34	41.09	41.31	14804100.0
2006-01-25 13:00:00	QQQ	ETF	41.31	41.37	41.22	41.27	6737900.0
2006-01-25 14:00:00	QQQ	ETF	41.27	41.32	41.08	41.12	15709100.0
2006-01-25 15:00:00	QQQ	ETF	41.12	41.25	41.1	41.24	13050300.0
2006-01-25 07:00:00	IWM	ETF	71.45	71.48	71.45	71.48	23900.0
2006-01-25 08:00:00	IWM	ETF	71.4	71.48	71.33	71.41	207100.0
2006-01-25 09:00:00	IWM	ETF	71.4	71.57	71.24	71.49	2925800.0
2006-01-25 10:00:00	IWM	ETF	71.49	71.6	71.08	71.41	6501000.0
2006-01-25 11:00:00	IWM	ETF	71.41	71.52	71.13	71.24	4961100.0
2006-01-25 12:00:00	IWM	ETF	71.25	71.26	70.9	71.02	4063000.0
2006-01-25 13:00:00	IWM	ETF	71.02	71.12	70.92	70.98	2534700.0
2006-01-25 14:00:00	IWM	ETF	70.97	71.04	70.79	70.8	4695000.0
2006-01-25 15:00:00	IWM	ETF	70.84	71.19	70.77	71.19	5278200.0
2006-01-25 16:00:00	IWM	ETF	71.18	71.39	71.18	71.34	717100.0
2006-01-25 17:00:00	IWM	ETF	71.39	71.39	71.39	71.39	400.0
2006-01-25 19:00:00	IWM	ETF	71.39	71.39	71.39	71.39	700.0
2006-01-25 08:00:00	DIA	ETF	107.39	107.39	107.21	107.21	8300.0
2006-01-25 09:00:00	DIA	ETF	107.24	107.45	107.2	107.38	469300.0
2006-01-25 10:00:00	DIA	ETF	107.37	107.52	106.84	107.2801	3406500.0
2006-01-25 11:00:00	DIA	ETF	107.28	107.44	107.06	107.19	578900.0
2006-01-25 12:00:00	DIA	ETF	107.19	107.19	106.8	107.15	1369600.0
2006-01-25 13:00:00	DIA	ETF	107.16	107.28	106.95	107.03	437300.0
2006-01-25 14:00:00	DIA	ETF	107.03	107.11	106.6	106.65	1847300.0
2006-01-25 15:00:00	DIA	ETF	106.67	107.11	106.61	107.11	1345200.0
2006-01-25 16:00:00	DIA	ETF	107.12	107.3	107.01	107.3	19600.0
2006-01-25 18:00:00	DIA	ETF	107.2	107.2	107.2	107.2	100.0
2006-01-25 19:00:00	DIA	ETF	107.32	107.32	107.32	107.32	200.0
2006-01-25 08:00:00	GLD	ETF	56.14	56.33	56.1	56.26	106500.0
2006-01-25 09:00:00	GLD	ETF	56.27	56.53	56.17	56.33	2003900.0
2006-01-25 10:00:00	GLD	ETF	56.31	56.31	55.74	55.99	1657500.0
2006-01-25 11:00:00	GLD	ETF	55.99	56.22	55.82	55.82	3765100.0
2006-01-25 12:00:00	GLD	ETF	55.83	56.17	55.7703	56.0601	828200.0
2006-01-25 13:00:00	GLD	ETF	56.05	56.18	56.0401	56.12	534900.0

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

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