PREVIEW / etf_1hour / 2006-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-31.parquet
  size:    48 KB
  rows:    1,563

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-31 06:00:00	SPY	ETF	127.7	127.7	127.7	127.7	100.0
2006-07-31 07:00:00	SPY	ETF	127.66	127.79	127.66	127.79	37400.0
2006-07-31 08:00:00	SPY	ETF	127.63	127.84	127.61	127.61	477300.0
2006-07-31 09:00:00	SPY	ETF	127.64	127.72	126.55	127.6	8393300.0
2006-07-31 10:00:00	SPY	ETF	127.61	127.9	127.47	127.76	11262500.0
2006-07-31 11:00:00	SPY	ETF	127.75	127.87	127.57	127.65	4620600.0
2006-07-31 12:00:00	SPY	ETF	127.64	127.74	127.53	127.56	6092800.0
2006-07-31 13:00:00	SPY	ETF	127.57	127.89	127.54	127.82	4376900.0
2006-07-31 14:00:00	SPY	ETF	127.83	127.9	127.65	127.73	3312400.0
2006-07-31 15:00:00	SPY	ETF	127.72	127.96	127.67	127.67	7133100.0
2006-07-31 16:00:00	SPY	ETF	127.67	127.85	127.64	127.74	2315000.0
2006-07-31 17:00:00	SPY	ETF	127.74	127.75	127.73	127.75	33100.0
2006-07-31 18:00:00	SPY	ETF	127.8	127.8	127.76	127.76	200.0
2006-07-31 19:00:00	SPY	ETF	127.75	127.75	127.75	127.75	4000.0
2006-07-31 09:00:00	QQQ	ETF	37.08	37.08	36.89	37.01	13716600.0
2006-07-31 10:00:00	QQQ	ETF	37.01	37.32	36.92	37.22	19118600.0
2006-07-31 11:00:00	QQQ	ETF	37.23	37.27	36.91	37.1	6254100.0
2006-07-31 12:00:00	QQQ	ETF	37.1	37.13	37.0	37.02	6585500.0
2006-07-31 13:00:00	QQQ	ETF	37.02	37.23	37.0	37.14	9634400.0
2006-07-31 14:00:00	QQQ	ETF	37.13	37.18	37.04	37.07	6511700.0
2006-07-31 15:00:00	QQQ	ETF	37.07	37.17	37.04	37.09	10620100.0
2006-07-31 08:00:00	IWM	ETF	69.66	69.66	69.5	69.51	101900.0
2006-07-31 09:00:00	IWM	ETF	69.54	69.54	69.11	69.3	4858000.0
2006-07-31 10:00:00	IWM	ETF	69.3	69.58	69.09	69.48	5646000.0
2006-07-31 11:00:00	IWM	ETF	69.49	69.56	69.17	69.36	5519300.0
2006-07-31 12:00:00	IWM	ETF	69.35	69.41	69.16	69.19	2411800.0
2006-07-31 13:00:00	IWM	ETF	69.19	69.58	69.06	69.49	5570900.0
2006-07-31 14:00:00	IWM	ETF	69.49	69.6	69.41	69.48	3476800.0
2006-07-31 15:00:00	IWM	ETF	69.48	69.83	69.4405	69.55	7654000.0
2006-07-31 16:00:00	IWM	ETF	69.55	69.72	69.54	69.61	815100.0
2006-07-31 17:00:00	IWM	ETF	69.62	69.8	69.62	69.7	6600.0
2006-07-31 18:00:00	IWM	ETF	69.7	69.73	69.7	69.73	45500.0
2006-07-31 19:00:00	IWM	ETF	69.74	69.74	69.74	69.74	500.0
2006-07-31 07:00:00	DIA	ETF	111.97	111.97	111.97	111.97	200.0
2006-07-31 08:00:00	DIA	ETF	111.94	111.94	111.84	111.84	16500.0
2006-07-31 09:00:00	DIA	ETF	111.83	111.87	111.66	111.84	566600.0
2006-07-31 10:00:00	DIA	ETF	111.83	112.05	111.77	111.94	535300.0
2006-07-31 11:00:00	DIA	ETF	111.92	112.0	111.79	111.85	614200.0
2006-07-31 12:00:00	DIA	ETF	111.84	111.92	111.74	111.78	210900.0
2006-07-31 13:00:00	DIA	ETF	111.78	111.98	111.76	111.91	209900.0
2006-07-31 14:00:00	DIA	ETF	111.9	111.94	111.72	111.75	233400.0
2006-07-31 15:00:00	DIA	ETF	111.75	111.9	111.69	111.69	1108300.0
2006-07-31 16:00:00	DIA	ETF	111.68	111.9	111.67	111.87	86600.0
2006-07-31 17:00:00	DIA	ETF	111.89	111.9	111.89	111.9	700.0
2006-07-31 08:00:00	GLD	ETF	63.21	63.33	63.09	63.21	125400.0
2006-07-31 09:00:00	GLD	ETF	63.23	63.26	62.75	62.7988	599900.0
2006-07-31 10:00:00	GLD	ETF	62.8	62.96	62.44	62.83	803700.0
2006-07-31 11:00:00	GLD	ETF	62.83	63.17	62.71	63.15	541300.0
2006-07-31 12:00:00	GLD	ETF	63.13	63.23	62.9	62.91	359500.0
2006-07-31 13:00:00	GLD	ETF	62.93	63.17	62.9	63.08	215400.0

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

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