PREVIEW / etf_1hour / 2006-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-18.parquet
  size:    42 KB
  rows:    1,280

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-18 06:00:00	SPY	ETF	128.78	128.78	128.78	128.78	3000.0
2006-04-18 07:00:00	SPY	ETF	128.76	128.95	128.75	128.89	73900.0
2006-04-18 08:00:00	SPY	ETF	128.88	129.1	128.74	129.0	2611300.0
2006-04-18 09:00:00	SPY	ETF	128.99	129.29	128.93	129.26	7334600.0
2006-04-18 10:00:00	SPY	ETF	129.2574	129.39	129.11	129.12	7314400.0
2006-04-18 11:00:00	SPY	ETF	129.12	129.89	129.11	129.86	12909700.0
2006-04-18 12:00:00	SPY	ETF	129.86	130.07	129.81	130.04	9106600.0
2006-04-18 13:00:00	SPY	ETF	130.06	130.18	129.75	129.84	8256100.0
2006-04-18 14:00:00	SPY	ETF	129.84	130.67	129.84	130.38	20403600.0
2006-04-18 15:00:00	SPY	ETF	130.38	130.94	130.36	130.73	18159500.0
2006-04-18 16:00:00	SPY	ETF	130.72	130.98	130.65	130.95	2698300.0
2006-04-18 17:00:00	SPY	ETF	130.99	131.0	130.91	130.94	892400.0
2006-04-18 18:00:00	SPY	ETF	130.95	130.98	130.86	130.91	127700.0
2006-04-18 19:00:00	SPY	ETF	130.89	130.89	130.89	130.89	20000.0
2006-04-18 09:00:00	QQQ	ETF	41.78	41.92	41.77	41.91	8887900.0
2006-04-18 10:00:00	QQQ	ETF	41.92	41.94	41.81	41.82	8164200.0
2006-04-18 11:00:00	QQQ	ETF	41.82	42.1	41.81	42.1	13971200.0
2006-04-18 12:00:00	QQQ	ETF	42.1	42.3	42.08	42.3	18044800.0
2006-04-18 13:00:00	QQQ	ETF	42.29	42.39	42.13	42.21	15700400.0
2006-04-18 14:00:00	QQQ	ETF	42.19	42.56	42.19	42.34	25028400.0
2006-04-18 15:00:00	QQQ	ETF	42.35	42.52	42.32	42.46	21681800.0
2006-04-18 08:00:00	IWM	ETF	74.73	74.83	74.71	74.8	74300.0
2006-04-18 09:00:00	IWM	ETF	74.7	75.15	74.7	75.15	6191100.0
2006-04-18 10:00:00	IWM	ETF	75.15	75.33	75.06	75.18	4469900.0
2006-04-18 11:00:00	IWM	ETF	75.17	75.77	75.15	75.76	8696600.0
2006-04-18 12:00:00	IWM	ETF	75.76	75.85	75.65	75.81	6523600.0
2006-04-18 13:00:00	IWM	ETF	75.82	75.95	75.7	75.74	5370800.0
2006-04-18 14:00:00	IWM	ETF	75.75	76.19	75.75	76.07	9537300.0
2006-04-18 15:00:00	IWM	ETF	76.08	76.57	76.05	76.49	14211200.0
2006-04-18 16:00:00	IWM	ETF	76.49	76.76	76.0	76.75	972600.0
2006-04-18 17:00:00	IWM	ETF	76.74	76.74	76.73	76.73	14000.0
2006-04-18 18:00:00	IWM	ETF	76.73	76.76	76.73	76.73	6400.0
2006-04-18 19:00:00	IWM	ETF	76.69	76.69	76.66	76.66	400.0
2006-04-18 08:00:00	DIA	ETF	111.01	111.13	110.99	111.07	16900.0
2006-04-18 09:00:00	DIA	ETF	111.08	111.33	111.03	111.2801	830000.0
2006-04-18 10:00:00	DIA	ETF	111.28	111.45	111.23	111.3	711400.0
2006-04-18 11:00:00	DIA	ETF	111.28	112.08	111.26	112.03	2638100.0
2006-04-18 12:00:00	DIA	ETF	112.03	112.21	111.96	112.12	1224800.0
2006-04-18 13:00:00	DIA	ETF	112.1	112.18	111.82	111.88	1059200.0
2006-04-18 14:00:00	DIA	ETF	111.88	112.59	111.87	112.38	2067000.0
2006-04-18 15:00:00	DIA	ETF	112.4	112.79	112.38	112.63	2130500.0
2006-04-18 16:00:00	DIA	ETF	112.6	112.79	112.59	112.79	131400.0
2006-04-18 17:00:00	DIA	ETF	112.8	112.84	112.7	112.84	5100.0
2006-04-18 18:00:00	DIA	ETF	112.8	112.8	112.8	112.8	100.0
2006-04-18 07:00:00	GLD	ETF	61.22	61.22	61.18	61.18	13100.0
2006-04-18 08:00:00	GLD	ETF	61.28	61.31	60.95	61.16	195400.0
2006-04-18 09:00:00	GLD	ETF	61.12	61.39	61.05	61.18	746200.0
2006-04-18 10:00:00	GLD	ETF	61.18	61.5	61.12	61.5	946700.0
2006-04-18 11:00:00	GLD	ETF	61.5	61.57	61.17	61.47	746800.0
2006-04-18 12:00:00	GLD	ETF	61.47	61.57	61.36	61.56	483000.0

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

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