PREVIEW / etf_1hour / 2006-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-22.parquet
  size:    45 KB
  rows:    1,388

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-05-22 04:00:00	SPY	ETF	126.3	126.3	126.04	126.04	7500.0
2006-05-22 05:00:00	SPY	ETF	126.27	126.27	126.27	126.27	100.0
2006-05-22 06:00:00	SPY	ETF	126.51	126.53	126.49	126.53	3100.0
2006-05-22 07:00:00	SPY	ETF	126.5	126.53	126.28	126.49	251700.0
2006-05-22 08:00:00	SPY	ETF	126.53	126.57	126.19	126.44	2389400.0
2006-05-22 09:00:00	SPY	ETF	126.44	127.1	125.95	126.47	12776200.0
2006-05-22 10:00:00	SPY	ETF	126.47	126.79	126.1	126.32	14628200.0
2006-05-22 11:00:00	SPY	ETF	126.34	126.86	125.5	126.03	19614700.0
2006-05-22 12:00:00	SPY	ETF	126.07	126.73	125.9	126.1	13275000.0
2006-05-22 13:00:00	SPY	ETF	126.1	126.34	125.94	126.08	6853400.0
2006-05-22 14:00:00	SPY	ETF	126.09	126.5	125.7	126.32	13337800.0
2006-05-22 15:00:00	SPY	ETF	126.3188	127.17	126.25	126.4	19762100.0
2006-05-22 16:00:00	SPY	ETF	126.41	126.45	126.13	126.3	2203700.0
2006-05-22 17:00:00	SPY	ETF	126.3	126.35	126.28	126.3	307100.0
2006-05-22 18:00:00	SPY	ETF	126.3	126.38	126.3	126.38	26600.0
2006-05-22 19:00:00	SPY	ETF	126.39	126.4	126.32	126.33	1500.0
2006-05-22 09:00:00	QQQ	ETF	39.02	39.24	38.99	39.06	18900400.0
2006-05-22 10:00:00	QQQ	ETF	39.06	39.09	38.89	38.95	24024600.0
2006-05-22 11:00:00	QQQ	ETF	38.96	39.01	38.7	38.85	24257600.0
2006-05-22 12:00:00	QQQ	ETF	38.85	39.1	38.77	38.84	20502200.0
2006-05-22 13:00:00	QQQ	ETF	38.85	38.92	38.76	38.82	17725800.0
2006-05-22 14:00:00	QQQ	ETF	38.82	38.91	38.62	38.79	23758200.0
2006-05-22 15:00:00	QQQ	ETF	38.79	39.21	38.77	38.96	26279300.0
2006-05-22 08:00:00	IWM	ETF	71.4	71.59	70.76	71.3	1283700.0
2006-05-22 09:00:00	IWM	ETF	71.3	71.51	70.89	70.9	10866800.0
2006-05-22 10:00:00	IWM	ETF	70.89	71.13	70.42	70.73	15417700.0
2006-05-22 11:00:00	IWM	ETF	70.74	71.08	70.09	70.47	14746600.0
2006-05-22 12:00:00	IWM	ETF	70.47	70.97	70.39	70.55	7909100.0
2006-05-22 13:00:00	IWM	ETF	70.57	70.76	70.46	70.58	3218300.0
2006-05-22 14:00:00	IWM	ETF	70.6	70.99	70.3	70.38	10263800.0
2006-05-22 15:00:00	IWM	ETF	70.73	71.67	70.72	71.12	20131500.0
2006-05-22 16:00:00	IWM	ETF	71.12	71.17	70.78	71.13	2880800.0
2006-05-22 17:00:00	IWM	ETF	71.11	71.18	71.1	71.17	103700.0
2006-05-22 19:00:00	IWM	ETF	71.11	71.11	71.11	71.11	1000.0
2006-05-22 07:00:00	DIA	ETF	110.89	110.93	110.89	110.93	11000.0
2006-05-22 08:00:00	DIA	ETF	110.99	110.99	110.76	110.87	54500.0
2006-05-22 09:00:00	DIA	ETF	110.94	111.33	110.68	111.07	1419900.0
2006-05-22 10:00:00	DIA	ETF	111.05	111.15	110.79	110.93	1812400.0
2006-05-22 11:00:00	DIA	ETF	110.95	110.972	110.27	110.75	3354700.0
2006-05-22 12:00:00	DIA	ETF	110.72	111.17	110.57	110.74	2549500.0
2006-05-22 13:00:00	DIA	ETF	110.77	110.94	110.62	110.78	1370200.0
2006-05-22 14:00:00	DIA	ETF	110.76	111.16	110.51	110.93	2349800.0
2006-05-22 15:00:00	DIA	ETF	110.92	111.66	110.9	111.1176	3243200.0
2006-05-22 16:00:00	DIA	ETF	111.1	111.13	110.87	110.97	55300.0
2006-05-22 18:00:00	DIA	ETF	111.0	111.0	111.0	111.0	300.0
2006-05-22 19:00:00	DIA	ETF	111.01	111.08	111.01	111.06	3300.0
2006-05-22 07:00:00	GLD	ETF	64.18	64.3	63.55	64.24	294800.0
2006-05-22 08:00:00	GLD	ETF	64.27	64.84	63.6	64.6	382900.0
2006-05-22 09:00:00	GLD	ETF	64.6	64.96	63.8	64.55	2704000.0
2006-05-22 10:00:00	GLD	ETF	64.56	65.1	64.51	64.84	2513800.0

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

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