PREVIEW / etf_1hour / 2006-01-24

all etf 1-hour files

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

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-24 05:00:00	SPY	ETF	126.49	126.49	126.49	126.49	100.0
2006-01-24 06:00:00	SPY	ETF	126.59	126.59	126.59	126.59	200.0
2006-01-24 07:00:00	SPY	ETF	126.74	126.81	126.7	126.73	21800.0
2006-01-24 08:00:00	SPY	ETF	126.8	126.8	126.62	126.72	583100.0
2006-01-24 09:00:00	SPY	ETF	126.64	127.05	126.42	127.01	7496200.0
2006-01-24 10:00:00	SPY	ETF	127.01	127.09	126.65	126.67	9137400.0
2006-01-24 11:00:00	SPY	ETF	126.67	126.79	126.42	126.7	8916400.0
2006-01-24 12:00:00	SPY	ETF	126.69	126.82	126.44	126.66	5767000.0
2006-01-24 13:00:00	SPY	ETF	126.64	126.92	126.49	126.88	3862600.0
2006-01-24 14:00:00	SPY	ETF	126.87	127.15	126.68	126.69	7585400.0
2006-01-24 15:00:00	SPY	ETF	126.69	126.83	126.58	126.6	7365100.0
2006-01-24 16:00:00	SPY	ETF	126.59	126.765	126.53	126.65	1199000.0
2006-01-24 17:00:00	SPY	ETF	126.67	126.67	126.57	126.64	140800.0
2006-01-24 18:00:00	SPY	ETF	126.61	126.67	126.61	126.67	5100.0
2006-01-24 19:00:00	SPY	ETF	126.67	126.69	126.67	126.69	2500.0
2006-01-24 09:00:00	QQQ	ETF	41.37	41.7	41.35	41.66	15588400.0
2006-01-24 10:00:00	QQQ	ETF	41.66	41.68	41.42	41.45	11840000.0
2006-01-24 11:00:00	QQQ	ETF	41.45	41.5	41.31	41.45	12478300.0
2006-01-24 12:00:00	QQQ	ETF	41.45	41.51	41.34	41.41	8454900.0
2006-01-24 13:00:00	QQQ	ETF	41.4	41.5	41.34	41.48	4931400.0
2006-01-24 14:00:00	QQQ	ETF	41.48	41.63	41.41	41.41	9108000.0
2006-01-24 15:00:00	QQQ	ETF	41.42	41.5	41.39	41.44	8407700.0
2006-01-24 07:00:00	IWM	ETF	70.51	70.51	70.51	70.51	26000.0
2006-01-24 08:00:00	IWM	ETF	70.41	70.55	70.41	70.47	20100.0
2006-01-24 09:00:00	IWM	ETF	70.44	70.94	70.44	70.89	4222300.0
2006-01-24 10:00:00	IWM	ETF	70.9	70.98	70.77	70.82	4055300.0
2006-01-24 11:00:00	IWM	ETF	70.82	70.93	70.65	70.88	3456800.0
2006-01-24 12:00:00	IWM	ETF	70.89	71.08	70.74	70.88	8088200.0
2006-01-24 13:00:00	IWM	ETF	70.88	71.2	70.85	71.17	3435400.0
2006-01-24 14:00:00	IWM	ETF	71.17	71.39	71.16	71.25	6573100.0
2006-01-24 15:00:00	IWM	ETF	71.25	71.43	71.2	71.23	6073100.0
2006-01-24 16:00:00	IWM	ETF	71.23	71.25	71.12	71.16	442100.0
2006-01-24 17:00:00	IWM	ETF	71.19	71.19	71.15	71.15	11000.0
2006-01-24 07:00:00	DIA	ETF	107.14	107.14	107.14	107.14	1500.0
2006-01-24 08:00:00	DIA	ETF	107.14	107.14	106.96	107.05	323600.0
2006-01-24 09:00:00	DIA	ETF	107.04	107.25	106.94	107.21	715100.0
2006-01-24 10:00:00	DIA	ETF	107.2	107.24	106.9	106.97	1092900.0
2006-01-24 11:00:00	DIA	ETF	106.96	107.13	106.78	107.05	1462100.0
2006-01-24 12:00:00	DIA	ETF	107.05	107.13	106.83	107.0	528500.0
2006-01-24 13:00:00	DIA	ETF	106.99	107.27	106.89	107.22	715400.0
2006-01-24 14:00:00	DIA	ETF	107.22	107.41	107.01	107.04	833700.0
2006-01-24 15:00:00	DIA	ETF	107.05	107.15	106.94	107.0	1197800.0
2006-01-24 16:00:00	DIA	ETF	106.99	107.09	106.94	107.09	189200.0
2006-01-24 19:00:00	DIA	ETF	107.1	107.1	107.1	107.1	500.0
2006-01-24 08:00:00	GLD	ETF	55.37	55.37	55.09	55.2	39400.0
2006-01-24 09:00:00	GLD	ETF	55.2	55.57	55.2	55.51	825500.0
2006-01-24 10:00:00	GLD	ETF	55.48	55.58	55.35	55.44	622300.0
2006-01-24 11:00:00	GLD	ETF	55.44	55.5	55.27	55.37	320900.0
2006-01-24 12:00:00	GLD	ETF	55.37	55.7	55.37	55.511	383300.0
2006-01-24 13:00:00	GLD	ETF	55.52	55.67	55.5	55.67	160100.0

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

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