PREVIEW / etf_1hour / 2006-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-18.parquet
  size:    50 KB
  rows:    1,577

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-08-18 06:00:00	SPY	ETF	129.81	129.81	129.81	129.81	25000.0
2006-08-18 07:00:00	SPY	ETF	129.92	129.96	129.88	129.88	62900.0
2006-08-18 08:00:00	SPY	ETF	129.85	130.0	129.85	130.0	305800.0
2006-08-18 09:00:00	SPY	ETF	130.0	130.22	129.68	129.74	11716100.0
2006-08-18 10:00:00	SPY	ETF	129.74	129.95	129.59	129.8	12684000.0
2006-08-18 11:00:00	SPY	ETF	129.8	130.03	129.71	129.91	4339800.0
2006-08-18 12:00:00	SPY	ETF	129.93	130.09	129.85	130.04	4212900.0
2006-08-18 13:00:00	SPY	ETF	130.05	130.29	130.02	130.1	6275400.0
2006-08-18 14:00:00	SPY	ETF	130.11	130.36	130.08	130.2	5454100.0
2006-08-18 15:00:00	SPY	ETF	130.21	130.48	130.13	130.46	8422500.0
2006-08-18 16:00:00	SPY	ETF	130.46	130.68	130.44	130.62	1934900.0
2006-08-18 17:00:00	SPY	ETF	130.61	130.61	130.51	130.57	182500.0
2006-08-18 18:00:00	SPY	ETF	130.56	130.56	130.56	130.56	100.0
2006-08-18 19:00:00	SPY	ETF	130.63	130.65	130.63	130.65	1500.0
2006-08-18 09:00:00	QQQ	ETF	38.65	38.67	38.28	38.33	19865400.0
2006-08-18 10:00:00	QQQ	ETF	38.33	38.87	38.32	38.45	22647500.0
2006-08-18 11:00:00	QQQ	ETF	38.45	38.55	38.43	38.51	8017800.0
2006-08-18 12:00:00	QQQ	ETF	38.51	38.6	38.47	38.56	5917100.0
2006-08-18 13:00:00	QQQ	ETF	38.56	38.68	38.54	38.56	6949000.0
2006-08-18 14:00:00	QQQ	ETF	38.56	38.72	38.55	38.65	7922000.0
2006-08-18 15:00:00	QQQ	ETF	38.65	38.83	38.63	38.79	15477800.0
2006-08-18 07:00:00	IWM	ETF	70.6	70.6	70.6	70.6	500.0
2006-08-18 08:00:00	IWM	ETF	70.5	70.63	70.5	70.58	86300.0
2006-08-18 09:00:00	IWM	ETF	70.66	70.92	70.04	70.05	6965700.0
2006-08-18 10:00:00	IWM	ETF	70.07	70.3	70.01	70.19	8066500.0
2006-08-18 11:00:00	IWM	ETF	70.19	70.42	70.19	70.39	5031200.0
2006-08-18 12:00:00	IWM	ETF	70.39	70.5	70.34	70.38	3321400.0
2006-08-18 13:00:00	IWM	ETF	70.39	70.52	70.31	70.31	2197500.0
2006-08-18 14:00:00	IWM	ETF	70.3	70.67	70.27	70.53	2190800.0
2006-08-18 15:00:00	IWM	ETF	70.53	70.94	70.51	70.76	5859600.0
2006-08-18 16:00:00	IWM	ETF	70.76	70.94	70.7	70.9	1608500.0
2006-08-18 08:00:00	DIA	ETF	113.26	113.34	113.23	113.34	6000.0
2006-08-18 09:00:00	DIA	ETF	113.35	113.66	113.12	113.17	842100.0
2006-08-18 10:00:00	DIA	ETF	113.15	113.36	113.08	113.26	863000.0
2006-08-18 11:00:00	DIA	ETF	113.28	113.44	113.16	113.24	282900.0
2006-08-18 12:00:00	DIA	ETF	113.22	113.33	113.16	113.3	239500.0
2006-08-18 13:00:00	DIA	ETF	113.31	113.44	113.27	113.31	325600.0
2006-08-18 14:00:00	DIA	ETF	113.3	113.54	113.3	113.4	372600.0
2006-08-18 15:00:00	DIA	ETF	113.4	113.7	113.36	113.64	852000.0
2006-08-18 16:00:00	DIA	ETF	113.64	113.83	113.64	113.82	122300.0
2006-08-18 17:00:00	DIA	ETF	113.7	113.8	113.7	113.8	1500.0
2006-08-18 18:00:00	DIA	ETF	113.8	113.8	113.8	113.8	500.0
2006-08-18 08:00:00	GLD	ETF	61.2	61.4	61.11	61.39	204600.0
2006-08-18 09:00:00	GLD	ETF	61.45	61.54	60.97	61.1	592300.0
2006-08-18 10:00:00	GLD	ETF	61.1	61.1	60.65	61.01	1656800.0
2006-08-18 11:00:00	GLD	ETF	61.01	61.08	60.42	60.45	1357800.0
2006-08-18 12:00:00	GLD	ETF	60.43	60.63	60.3	60.36	1065200.0
2006-08-18 13:00:00	GLD	ETF	60.38	60.87	60.35	60.861	599700.0
2006-08-18 14:00:00	GLD	ETF	60.87	61.07	60.81	61.04	454100.0
2006-08-18 15:00:00	GLD	ETF	61.04	61.08	60.97	61.06	372800.0

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

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