PREVIEW / etf_1hour / 2006-04-11

all etf 1-hour files

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

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-11 06:00:00	SPY	ETF	129.51	129.51	129.51	129.51	3000.0
2006-04-11 07:00:00	SPY	ETF	129.53	129.64	129.53	129.61	193900.0
2006-04-11 08:00:00	SPY	ETF	129.64	129.9	129.51	129.88	997600.0
2006-04-11 09:00:00	SPY	ETF	129.85	130.06	129.63	129.681	5933100.0
2006-04-11 10:00:00	SPY	ETF	129.68	129.76	128.67	128.91	20290800.0
2006-04-11 11:00:00	SPY	ETF	128.9	129.1	128.76	128.81	7495700.0
2006-04-11 12:00:00	SPY	ETF	128.81	128.98	128.67	128.8	4178700.0
2006-04-11 13:00:00	SPY	ETF	128.79	129.0	128.57	128.68	6147700.0
2006-04-11 14:00:00	SPY	ETF	128.68	128.87	128.54	128.59	6173100.0
2006-04-11 15:00:00	SPY	ETF	128.59	129.6617	128.25	128.65	17912000.0
2006-04-11 16:00:00	SPY	ETF	128.65	128.78	128.57	128.73	1551500.0
2006-04-11 17:00:00	SPY	ETF	128.78	128.81	128.64	128.75	215500.0
2006-04-11 18:00:00	SPY	ETF	128.75	128.8	128.72	128.8	5600.0
2006-04-11 19:00:00	SPY	ETF	128.78	128.78	128.73	128.73	1300.0
2006-04-11 09:00:00	QQQ	ETF	42.4	42.43	42.17	42.18	9203700.0
2006-04-11 10:00:00	QQQ	ETF	42.18	42.25	41.8	41.9	23442700.0
2006-04-11 11:00:00	QQQ	ETF	41.9	41.99	41.87	41.88	10928100.0
2006-04-11 12:00:00	QQQ	ETF	41.88	41.91	41.82	41.88	5433100.0
2006-04-11 13:00:00	QQQ	ETF	41.88	41.98	41.83	41.86	7731900.0
2006-04-11 14:00:00	QQQ	ETF	41.85	41.99	41.84	41.85	8622800.0
2006-04-11 15:00:00	QQQ	ETF	41.86	41.93	41.71	41.93	15472400.0
2006-04-11 08:00:00	IWM	ETF	74.76	75.05	74.76	74.99	568500.0
2006-04-11 09:00:00	IWM	ETF	74.98	75.06	74.56	74.56	3629200.0
2006-04-11 10:00:00	IWM	ETF	74.55	74.57	73.83	73.86	12211400.0
2006-04-11 11:00:00	IWM	ETF	73.87	74.08	73.86	73.92	5745300.0
2006-04-11 12:00:00	IWM	ETF	73.92	74.03	73.74	73.9	3852100.0
2006-04-11 13:00:00	IWM	ETF	73.9	74.07	73.76	73.79	3270000.0
2006-04-11 14:00:00	IWM	ETF	73.78	74.7895	73.73	73.7499	5667000.0
2006-04-11 15:00:00	IWM	ETF	73.74	73.75	73.45	73.65	10852800.0
2006-04-11 16:00:00	IWM	ETF	73.65	73.67	73.57	73.59	1527900.0
2006-04-11 17:00:00	IWM	ETF	73.6	73.62	73.6	73.62	2400.0
2006-04-11 19:00:00	IWM	ETF	73.62	73.62	73.62	73.62	500.0
2006-04-11 08:00:00	DIA	ETF	111.53	111.71	111.53	111.7	18100.0
2006-04-11 09:00:00	DIA	ETF	111.7	111.86	111.48	111.5	1213600.0
2006-04-11 10:00:00	DIA	ETF	111.5	111.62	110.73	110.9	2075400.0
2006-04-11 11:00:00	DIA	ETF	110.9	111.08	110.88	110.9	1004000.0
2006-04-11 12:00:00	DIA	ETF	110.9	111.03	110.82	110.84	332200.0
2006-04-11 13:00:00	DIA	ETF	110.83	110.99	110.69	110.74	536800.0
2006-04-11 14:00:00	DIA	ETF	110.72	110.9	110.66	110.76	606300.0
2006-04-11 15:00:00	DIA	ETF	110.76	110.92	110.51	110.91	1025300.0
2006-04-11 16:00:00	DIA	ETF	110.92	111.0	110.85	111.0	102700.0
2006-04-11 17:00:00	DIA	ETF	110.92	110.92	110.92	110.92	100.0
2006-04-11 06:00:00	GLD	ETF	59.8	59.8	59.8	59.8	100.0
2006-04-11 07:00:00	GLD	ETF	59.45	59.62	59.45	59.55	59900.0
2006-04-11 08:00:00	GLD	ETF	59.51	59.61	59.15	59.44	139000.0
2006-04-11 09:00:00	GLD	ETF	59.4	59.71	59.4	59.5	535500.0
2006-04-11 10:00:00	GLD	ETF	59.5	59.85	59.31	59.74	870500.0
2006-04-11 11:00:00	GLD	ETF	59.74	59.74	59.34	59.43	963800.0
2006-04-11 12:00:00	GLD	ETF	59.42	59.42	59.0	59.19	1047000.0
2006-04-11 13:00:00	GLD	ETF	59.21	59.32	59.09	59.18	527300.0

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

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