PREVIEW / etf_1hour / 2006-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-09.parquet
  size:    51 KB
  rows:    1,578

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-09 05:00:00	SPY	ETF	127.55	127.7	127.55	127.7	50000.0
2006-08-09 06:00:00	SPY	ETF	127.7	127.82	127.7	127.82	75100.0
2006-08-09 07:00:00	SPY	ETF	127.86	127.99	127.86	127.94	338000.0
2006-08-09 08:00:00	SPY	ETF	127.94	128.18	127.77	128.06	3893900.0
2006-08-09 09:00:00	SPY	ETF	128.08	128.45	128.02	128.05	10882800.0
2006-08-09 10:00:00	SPY	ETF	128.05	128.16	127.83	128.02	8837900.0
2006-08-09 11:00:00	SPY	ETF	128.02	128.6	128.02	128.31	10317700.0
2006-08-09 12:00:00	SPY	ETF	128.31	128.34	127.86	127.93	5019500.0
2006-08-09 13:00:00	SPY	ETF	127.93	127.99	127.57	127.64	8362100.0
2006-08-09 14:00:00	SPY	ETF	127.65	127.93	127.24	127.28	9074500.0
2006-08-09 15:00:00	SPY	ETF	127.27	127.44	126.61	126.78	19173700.0
2006-08-09 16:00:00	SPY	ETF	126.79	126.99	126.73	126.89	1444000.0
2006-08-09 17:00:00	SPY	ETF	126.87	126.93	126.82	126.9	93100.0
2006-08-09 18:00:00	SPY	ETF	126.9	126.9	126.81	126.87	5000.0
2006-08-09 19:00:00	SPY	ETF	126.93	126.93	126.89	126.89	2000.0
2006-08-09 09:00:00	QQQ	ETF	37.01	37.07	36.92	36.98	20539800.0
2006-08-09 10:00:00	QQQ	ETF	36.98	36.99	36.83	36.93	22185800.0
2006-08-09 11:00:00	QQQ	ETF	36.93	37.31	36.92	37.22	28845800.0
2006-08-09 12:00:00	QQQ	ETF	37.23	37.23	37.04	37.07	9215200.0
2006-08-09 13:00:00	QQQ	ETF	37.07	37.1	36.91	36.94	11867000.0
2006-08-09 14:00:00	QQQ	ETF	36.95	37.01	36.76	36.77	14713700.0
2006-08-09 15:00:00	QQQ	ETF	36.77	36.77	36.43	36.53	27457900.0
2006-08-09 07:00:00	IWM	ETF	68.6	68.7	68.6	68.7	3000.0
2006-08-09 08:00:00	IWM	ETF	68.7	68.95	68.7	68.93	582400.0
2006-08-09 09:00:00	IWM	ETF	68.93	69.28	68.77	68.82	8791000.0
2006-08-09 10:00:00	IWM	ETF	68.82	68.89	68.4	68.61	7522600.0
2006-08-09 11:00:00	IWM	ETF	68.61	69.19	68.61	68.99	5264600.0
2006-08-09 12:00:00	IWM	ETF	68.99	69.08	68.66	68.75	4562000.0
2006-08-09 13:00:00	IWM	ETF	68.74	68.85	68.48	68.55	3879900.0
2006-08-09 14:00:00	IWM	ETF	68.53	68.69	67.89	67.97	9445200.0
2006-08-09 15:00:00	IWM	ETF	67.96	68.61	67.6	67.7599	13095400.0
2006-08-09 16:00:00	IWM	ETF	67.76	68.91	67.67	67.77	790100.0
2006-08-09 17:00:00	IWM	ETF	67.76	67.79	67.69	67.79	22400.0
2006-08-09 18:00:00	IWM	ETF	67.72	67.72	67.72	67.72	100.0
2006-08-09 07:00:00	DIA	ETF	112.21	112.21	112.21	112.21	500.0
2006-08-09 08:00:00	DIA	ETF	112.2	112.36	112.19	112.23	186000.0
2006-08-09 09:00:00	DIA	ETF	112.39	112.51	112.15	112.18	988100.0
2006-08-09 10:00:00	DIA	ETF	112.17	112.19	111.91	112.07	726800.0
2006-08-09 11:00:00	DIA	ETF	112.08	112.37	112.06	112.21	955200.0
2006-08-09 12:00:00	DIA	ETF	112.22	112.23	111.74	111.8	423600.0
2006-08-09 13:00:00	DIA	ETF	111.78	111.84	111.53	111.53	895500.0
2006-08-09 14:00:00	DIA	ETF	111.55	111.74	111.12	111.13	1376700.0
2006-08-09 15:00:00	DIA	ETF	111.13	111.14	110.72	110.8	2163700.0
2006-08-09 16:00:00	DIA	ETF	110.82	110.96	110.79	110.95	622400.0
2006-08-09 17:00:00	DIA	ETF	110.95	110.95	110.95	110.95	100.0
2006-08-09 19:00:00	DIA	ETF	110.94	110.98	110.94	110.98	2300.0
2006-08-09 07:00:00	GLD	ETF	64.19	64.25	64.19	64.25	700.0
2006-08-09 08:00:00	GLD	ETF	64.25	64.7	64.1	64.67	100100.0
2006-08-09 09:00:00	GLD	ETF	64.67	64.76	64.54	64.55	504300.0
2006-08-09 10:00:00	GLD	ETF	64.55	65.02	64.39	64.99	861000.0

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

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