PREVIEW / etf_1hour / 2006-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-25.parquet
  size:    41 KB
  rows:    1,247

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-04-25 07:00:00	SPY	ETF	131.0	131.15	131.0	131.1	5900.0
2006-04-25 08:00:00	SPY	ETF	131.1	131.15	131.0	131.06	1166500.0
2006-04-25 09:00:00	SPY	ETF	131.06	131.12	130.88	131.0	3763500.0
2006-04-25 10:00:00	SPY	ETF	131.01	131.08	130.22	130.59	24550200.0
2006-04-25 11:00:00	SPY	ETF	130.6	130.74	130.03	130.16	16559100.0
2006-04-25 12:00:00	SPY	ETF	130.16	130.38	129.99	130.17	6619900.0
2006-04-25 13:00:00	SPY	ETF	130.18	130.3	129.92	130.16	10482500.0
2006-04-25 14:00:00	SPY	ETF	130.16	130.44	130.07	130.12	7702500.0
2006-04-25 15:00:00	SPY	ETF	130.12	130.28	129.93	130.21	10791200.0
2006-04-25 16:00:00	SPY	ETF	130.23	130.42	130.12	130.35	1763600.0
2006-04-25 17:00:00	SPY	ETF	130.33	130.39	130.33	130.36	164600.0
2006-04-25 18:00:00	SPY	ETF	130.36	130.36	130.36	130.36	100.0
2006-04-25 19:00:00	SPY	ETF	130.39	130.4	130.39	130.39	900.0
2006-04-25 09:00:00	QQQ	ETF	42.08	42.1	41.91	41.99	7379700.0
2006-04-25 10:00:00	QQQ	ETF	42.0	42.03	41.72	41.86	24505300.0
2006-04-25 11:00:00	QQQ	ETF	41.87	41.92	41.7	41.74	9781500.0
2006-04-25 12:00:00	QQQ	ETF	41.74	41.83	41.69	41.75	7205400.0
2006-04-25 13:00:00	QQQ	ETF	41.75	41.84	41.65	41.78	9760400.0
2006-04-25 14:00:00	QQQ	ETF	41.78	41.91	41.73	41.75	7075300.0
2006-04-25 15:00:00	QQQ	ETF	41.76	41.88	41.72	41.87	7787200.0
2006-04-25 08:00:00	IWM	ETF	76.12	76.21	76.12	76.15	507600.0
2006-04-25 09:00:00	IWM	ETF	76.15	76.21	75.86	76.07	2830200.0
2006-04-25 10:00:00	IWM	ETF	76.07	76.11	75.57	75.83	7776800.0
2006-04-25 11:00:00	IWM	ETF	75.84	75.93	75.48	75.62	5815500.0
2006-04-25 12:00:00	IWM	ETF	75.62	76.0	75.53	75.82	5345300.0
2006-04-25 13:00:00	IWM	ETF	75.83	75.97	75.58	75.76	3737800.0
2006-04-25 14:00:00	IWM	ETF	75.76	76.04	75.65	75.77	5178400.0
2006-04-25 15:00:00	IWM	ETF	75.76	75.97	75.64	75.97	5867600.0
2006-04-25 16:00:00	IWM	ETF	75.97	76.22	75.97	76.12	403200.0
2006-04-25 17:00:00	IWM	ETF	76.12	76.12	76.06	76.06	3900.0
2006-04-25 18:00:00	IWM	ETF	76.1	76.11	76.1	76.11	900.0
2006-04-25 19:00:00	IWM	ETF	76.09	76.09	76.09	76.09	1000.0
2006-04-25 07:00:00	DIA	ETF	113.58	113.62	113.57	113.59	75600.0
2006-04-25 08:00:00	DIA	ETF	113.6	113.62	113.5	113.53	308400.0
2006-04-25 09:00:00	DIA	ETF	113.5	113.5	113.25	113.36	477800.0
2006-04-25 10:00:00	DIA	ETF	113.35	113.4	112.74	113.15	2084200.0
2006-04-25 11:00:00	DIA	ETF	113.16	113.22	112.62	112.74	854500.0
2006-04-25 12:00:00	DIA	ETF	112.74	112.93	112.61	112.8	747800.0
2006-04-25 13:00:00	DIA	ETF	112.81	112.84	112.58	112.69	1053200.0
2006-04-25 14:00:00	DIA	ETF	112.66	112.92	112.62	112.67	855900.0
2006-04-25 15:00:00	DIA	ETF	112.67	112.83	112.5	112.79	1690600.0
2006-04-25 16:00:00	DIA	ETF	112.76	112.89	112.76	112.85	63200.0
2006-04-25 07:00:00	GLD	ETF	62.19	62.19	62.19	62.19	1000.0
2006-04-25 08:00:00	GLD	ETF	62.38	62.7	62.27	62.58	102400.0
2006-04-25 09:00:00	GLD	ETF	62.45	63.1799	62.44	63.04	1019700.0
2006-04-25 10:00:00	GLD	ETF	63.05	63.11	62.18	62.64	2023000.0
2006-04-25 11:00:00	GLD	ETF	62.62	62.86	62.49	62.78	621400.0
2006-04-25 12:00:00	GLD	ETF	62.79	62.89	62.6	62.75	491400.0
2006-04-25 13:00:00	GLD	ETF	62.79	62.86	62.6	62.73	371000.0
2006-04-25 14:00:00	GLD	ETF	62.72	62.83	62.65	62.67	282200.0

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

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