PREVIEW / etf_1hour / 2006-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-25.parquet
  size:    50 KB
  rows:    1,565

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-07-25 04:00:00	SPY	ETF	126.1	126.1	126.1	126.1	1000.0
2006-07-25 05:00:00	SPY	ETF	126.19	126.19	126.19	126.19	500.0
2006-07-25 06:00:00	SPY	ETF	126.35	126.35	126.32	126.32	300.0
2006-07-25 07:00:00	SPY	ETF	126.32	126.33	126.16	126.24	44700.0
2006-07-25 08:00:00	SPY	ETF	126.21	126.32	126.05	126.06	460200.0
2006-07-25 09:00:00	SPY	ETF	126.06	126.17	125.83	126.12	9287300.0
2006-07-25 10:00:00	SPY	ETF	126.1	126.77	125.72	125.96	26954200.0
2006-07-25 11:00:00	SPY	ETF	125.97	126.07	125.73	125.84	7086000.0
2006-07-25 12:00:00	SPY	ETF	125.84	126.2	125.72	126.15	5942900.0
2006-07-25 13:00:00	SPY	ETF	126.15	126.25	125.91	126.09	4750500.0
2006-07-25 14:00:00	SPY	ETF	126.09	126.44	125.85	126.34	9865800.0
2006-07-25 15:00:00	SPY	ETF	126.34	127.3	126.34	126.95	23515500.0
2006-07-25 16:00:00	SPY	ETF	126.95	126.9585	125.943	126.57	4505400.0
2006-07-25 17:00:00	SPY	ETF	126.58	126.65	126.56	126.63	119300.0
2006-07-25 18:00:00	SPY	ETF	126.63	126.63	126.56	126.56	44000.0
2006-07-25 19:00:00	SPY	ETF	126.55	126.6	126.55	126.6	3100.0
2006-07-25 09:00:00	QQQ	ETF	36.47	36.51	36.36	36.5	13210500.0
2006-07-25 10:00:00	QQQ	ETF	36.5	37.73	36.27	36.34	31578700.0
2006-07-25 11:00:00	QQQ	ETF	36.35	36.45	36.27	36.32	8597800.0
2006-07-25 12:00:00	QQQ	ETF	36.31	36.45	36.25	36.41	6821100.0
2006-07-25 13:00:00	QQQ	ETF	36.41	36.45	36.29	36.36	6233500.0
2006-07-25 14:00:00	QQQ	ETF	36.35	36.48	36.24	36.42	10599000.0
2006-07-25 15:00:00	QQQ	ETF	36.42	36.72	36.41	36.6	22878400.0
2006-07-25 07:00:00	IWM	ETF	68.95	69.0	68.95	69.0	10000.0
2006-07-25 08:00:00	IWM	ETF	69.06	69.67	68.75	68.76	578600.0
2006-07-25 09:00:00	IWM	ETF	68.78	69.4	68.39	69.06	12294500.0
2006-07-25 10:00:00	IWM	ETF	69.06	69.78	68.5	68.79	29066200.0
2006-07-25 11:00:00	IWM	ETF	68.8	69.0	68.65	68.79	5331600.0
2006-07-25 12:00:00	IWM	ETF	68.8	69.2	68.68	69.1	6696100.0
2006-07-25 13:00:00	IWM	ETF	69.11	69.11	68.66	68.81	4337500.0
2006-07-25 14:00:00	IWM	ETF	68.82	69.16	68.59	69.08	7210600.0
2006-07-25 15:00:00	IWM	ETF	69.07	69.66	69.03	69.28	16828800.0
2006-07-25 16:00:00	IWM	ETF	69.28	69.29	68.85	68.92	842900.0
2006-07-25 17:00:00	IWM	ETF	68.92	69.2	68.92	69.05	356000.0
2006-07-25 18:00:00	IWM	ETF	68.92	68.92	68.91	68.91	1800.0
2006-07-25 19:00:00	IWM	ETF	68.9	68.9	68.9	68.9	400.0
2006-07-25 08:00:00	DIA	ETF	110.5	110.5	110.38	110.38	12100.0
2006-07-25 09:00:00	DIA	ETF	110.31	110.35	110.12	110.24	688200.0
2006-07-25 10:00:00	DIA	ETF	110.24	110.73	109.92	110.06	1528000.0
2006-07-25 11:00:00	DIA	ETF	110.08	110.27	109.89	110.04	1251600.0
2006-07-25 12:00:00	DIA	ETF	110.06	110.35	109.94	110.25	747000.0
2006-07-25 13:00:00	DIA	ETF	110.26	110.38	110.08	110.2	819000.0
2006-07-25 14:00:00	DIA	ETF	110.21	110.51	110.01	110.45	756400.0
2006-07-25 15:00:00	DIA	ETF	110.45	111.26	110.45	110.98	2229600.0
2006-07-25 16:00:00	DIA	ETF	110.99	111.02	110.7	110.74	57800.0
2006-07-25 17:00:00	DIA	ETF	110.87	111.0	110.85	110.87	2800.0
2006-07-25 04:00:00	GLD	ETF	61.27	61.27	61.27	61.27	100.0
2006-07-25 07:00:00	GLD	ETF	61.7	61.7	61.7	61.7	100.0
2006-07-25 08:00:00	GLD	ETF	61.75	61.83	61.51	61.64	61000.0
2006-07-25 09:00:00	GLD	ETF	61.75	61.75	61.23	61.37	626300.0

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

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