PREVIEW / etf_1hour / 2006-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-07.parquet
  size:    49 KB
  rows:    1,522

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-07-07 06:00:00	SPY	ETF	127.51	127.56	127.51	127.51	121700.0
2006-07-07 07:00:00	SPY	ETF	127.5	127.54	127.42	127.45	244200.0
2006-07-07 08:00:00	SPY	ETF	127.21	128.13	127.21	127.58	10495200.0
2006-07-07 09:00:00	SPY	ETF	127.59	127.59	126.84	127.05	17054300.0
2006-07-07 10:00:00	SPY	ETF	127.05	127.41	126.93	127.151	11584400.0
2006-07-07 11:00:00	SPY	ETF	127.12	127.54	127.01	127.33	7117000.0
2006-07-07 12:00:00	SPY	ETF	127.33	127.56	127.21	127.3	4267700.0
2006-07-07 13:00:00	SPY	ETF	127.28	127.55	126.89	127.02	5896800.0
2006-07-07 14:00:00	SPY	ETF	127.02	127.18	126.37	126.41	9460500.0
2006-07-07 15:00:00	SPY	ETF	126.41	126.61	126.29	126.53	12444300.0
2006-07-07 16:00:00	SPY	ETF	126.53	126.67	126.51	126.58	806000.0
2006-07-07 17:00:00	SPY	ETF	126.6	126.62	126.58	126.6	9400.0
2006-07-07 18:00:00	SPY	ETF	126.59	126.63	126.58	126.63	1800.0
2006-07-07 19:00:00	SPY	ETF	126.59	126.59	126.59	126.59	100.0
2006-07-07 09:00:00	QQQ	ETF	37.89	37.9	37.71	37.8	13151200.0
2006-07-07 10:00:00	QQQ	ETF	37.8	37.91	37.76	37.83	11396700.0
2006-07-07 11:00:00	QQQ	ETF	37.83	38.02	37.78	37.93	10012200.0
2006-07-07 12:00:00	QQQ	ETF	37.94	38.17	37.91	38.02	10225900.0
2006-07-07 13:00:00	QQQ	ETF	38.03	38.05	37.87	37.93	7592400.0
2006-07-07 14:00:00	QQQ	ETF	37.92	38.0	37.61	37.65	18139200.0
2006-07-07 15:00:00	QQQ	ETF	37.65	37.7	37.57	37.68	19781200.0
2006-07-07 08:00:00	IWM	ETF	71.38	72.23	71.38	71.84	899600.0
2006-07-07 09:00:00	IWM	ETF	71.83	71.86	70.9	71.11	7202500.0
2006-07-07 10:00:00	IWM	ETF	71.11	71.48	71.03	71.19	5621100.0
2006-07-07 11:00:00	IWM	ETF	71.19	71.6	71.11	71.44	5367700.0
2006-07-07 12:00:00	IWM	ETF	71.44	71.64	71.32	71.36	5745800.0
2006-07-07 13:00:00	IWM	ETF	71.36	71.44	71.06	71.15	5064800.0
2006-07-07 14:00:00	IWM	ETF	71.16	71.37	70.59	70.6	5469700.0
2006-07-07 15:00:00	IWM	ETF	70.61	70.64	70.35	70.44	8860600.0
2006-07-07 16:00:00	IWM	ETF	70.45	70.52	70.41	70.51	506000.0
2006-07-07 17:00:00	IWM	ETF	70.51	70.51	70.51	70.51	200.0
2006-07-07 18:00:00	IWM	ETF	70.49	70.51	70.49	70.51	400.0
2006-07-07 08:00:00	DIA	ETF	112.32	112.78	112.32	112.43	48800.0
2006-07-07 09:00:00	DIA	ETF	112.27	112.4	111.3	111.42	1573400.0
2006-07-07 10:00:00	DIA	ETF	111.4	111.75	111.33	111.44	579100.0
2006-07-07 11:00:00	DIA	ETF	111.47	111.72	111.36	111.55	485100.0
2006-07-07 12:00:00	DIA	ETF	111.56	111.69	111.41	111.44	668500.0
2006-07-07 13:00:00	DIA	ETF	111.41	111.47	111.06	111.19	1704700.0
2006-07-07 14:00:00	DIA	ETF	111.19	111.3	110.69	110.76	780900.0
2006-07-07 15:00:00	DIA	ETF	110.74	111.02	110.69	110.95	1221200.0
2006-07-07 16:00:00	DIA	ETF	110.95	111.05	110.9	111.04	9300.0
2006-07-07 17:00:00	DIA	ETF	111.05	111.05	111.05	111.05	300.0
2006-07-07 18:00:00	DIA	ETF	111.06	111.06	110.97	110.98	900.0
2006-07-07 07:00:00	GLD	ETF	62.78	62.85	62.78	62.85	6600.0
2006-07-07 08:00:00	GLD	ETF	62.85	63.46	62.75	63.08	761600.0
2006-07-07 09:00:00	GLD	ETF	63.08	63.15	62.46	62.77	1370800.0
2006-07-07 10:00:00	GLD	ETF	62.771	62.97	62.57	62.84	731900.0
2006-07-07 11:00:00	GLD	ETF	62.82	62.95	62.58	62.83	753800.0
2006-07-07 12:00:00	GLD	ETF	62.85	62.9	62.68	62.711	366000.0
2006-07-07 13:00:00	GLD	ETF	62.71	62.98	62.71	62.93	346300.0

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

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