PREVIEW / etf_1hour / 2006-08-29

all etf 1-hour files

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

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-29 07:00:00	SPY	ETF	130.66	130.68	130.55	130.62	76000.0
2006-08-29 08:00:00	SPY	ETF	130.6	130.66	130.4	130.57	461300.0
2006-08-29 09:00:00	SPY	ETF	130.54	130.59	130.31	130.49	6395700.0
2006-08-29 10:00:00	SPY	ETF	130.5	130.51	129.98	130.11	11642300.0
2006-08-29 11:00:00	SPY	ETF	130.11	130.17	129.85	129.91	5436800.0
2006-08-29 12:00:00	SPY	ETF	129.92	130.09	129.88	129.97	3037400.0
2006-08-29 13:00:00	SPY	ETF	129.97	130.09	129.89	130.02	2384000.0
2006-08-29 14:00:00	SPY	ETF	130.01	130.54	129.81	130.38	18675400.0
2006-08-29 15:00:00	SPY	ETF	130.38	130.83	130.27	130.76	9650900.0
2006-08-29 16:00:00	SPY	ETF	130.75	130.77	130.57	130.59	1508100.0
2006-08-29 17:00:00	SPY	ETF	130.59	130.59	130.56	130.57	10600.0
2006-08-29 18:00:00	SPY	ETF	130.57	130.64	130.56	130.64	21700.0
2006-08-29 19:00:00	SPY	ETF	130.63	130.63	130.63	130.63	800.0
2006-08-29 09:00:00	QQQ	ETF	38.58	38.63	38.47	38.62	8799600.0
2006-08-29 10:00:00	QQQ	ETF	38.62	38.62	38.23	38.34	21444100.0
2006-08-29 11:00:00	QQQ	ETF	38.33	38.36	38.18	38.21	9632200.0
2006-08-29 12:00:00	QQQ	ETF	38.21	38.3	38.19	38.26	4335500.0
2006-08-29 13:00:00	QQQ	ETF	38.26	38.31	38.24	38.29	4153100.0
2006-08-29 14:00:00	QQQ	ETF	38.29	38.52	38.18	38.47	27465400.0
2006-08-29 15:00:00	QQQ	ETF	38.46	38.76	38.41	38.72	24149200.0
2006-08-29 08:00:00	IWM	ETF	70.58	70.61	70.51	70.55	477100.0
2006-08-29 09:00:00	IWM	ETF	70.55	70.61	70.36	70.6	3799500.0
2006-08-29 10:00:00	IWM	ETF	70.59	70.59	70.0	70.13	8016500.0
2006-08-29 11:00:00	IWM	ETF	70.13	70.2	69.88	69.93	3127500.0
2006-08-29 12:00:00	IWM	ETF	69.94	70.11	69.92	70.03	1136000.0
2006-08-29 13:00:00	IWM	ETF	70.03	70.25	70.02	70.16	1711300.0
2006-08-29 14:00:00	IWM	ETF	70.17	70.92	69.98	70.83	12230800.0
2006-08-29 15:00:00	IWM	ETF	70.82	71.22	70.64	71.17	14704200.0
2006-08-29 16:00:00	IWM	ETF	71.17	71.22	70.9874	70.9874	5913900.0
2006-08-29 17:00:00	IWM	ETF	71.2	71.2	71.2	71.2	700.0
2006-08-29 07:00:00	DIA	ETF	113.57	113.57	113.57	113.57	400.0
2006-08-29 08:00:00	DIA	ETF	113.62	113.62	113.52	113.54	3500.0
2006-08-29 09:00:00	DIA	ETF	113.52	113.54	113.32	113.54	417500.0
2006-08-29 10:00:00	DIA	ETF	113.52	113.53	113.1	113.25	875400.0
2006-08-29 11:00:00	DIA	ETF	113.2481	113.3	113.02	113.09	356300.0
2006-08-29 12:00:00	DIA	ETF	113.09	113.17	113.04	113.11	150400.0
2006-08-29 13:00:00	DIA	ETF	113.09	113.18	113.06	113.15	206000.0
2006-08-29 14:00:00	DIA	ETF	113.15	113.53	112.93	113.43	1450300.0
2006-08-29 15:00:00	DIA	ETF	113.43	113.76	113.33	113.66	1002400.0
2006-08-29 16:00:00	DIA	ETF	113.62	113.63	113.48	113.5	211800.0
2006-08-29 07:00:00	GLD	ETF	61.19	61.19	61.19	61.19	500.0
2006-08-29 08:00:00	GLD	ETF	61.14	61.32	60.89	60.93	74800.0
2006-08-29 09:00:00	GLD	ETF	61.0	61.13	60.9	61.02	457100.0
2006-08-29 10:00:00	GLD	ETF	61.04	61.09	60.32	60.54	1113300.0
2006-08-29 11:00:00	GLD	ETF	60.54	60.77	60.45	60.7	519700.0
2006-08-29 12:00:00	GLD	ETF	60.7	60.81	60.62	60.74	229700.0
2006-08-29 13:00:00	GLD	ETF	60.75	60.9	60.62	60.72	306000.0
2006-08-29 14:00:00	GLD	ETF	60.7	61.01	60.67	60.97	431100.0
2006-08-29 15:00:00	GLD	ETF	60.97	61.03	60.97	61.0	402400.0
2006-08-29 16:00:00	GLD	ETF	61.0	61.0	60.9	60.92	2900.0

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

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