PREVIEW / etf_1hour / 2006-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-11.parquet
  size:    49 KB
  rows:    1,550

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-11 06:00:00	SPY	ETF	127.35	127.37	127.35	127.37	3000.0
2006-08-11 07:00:00	SPY	ETF	127.29	127.38	127.29	127.3	76200.0
2006-08-11 08:00:00	SPY	ETF	127.29	127.43	126.26	127.28	1332000.0
2006-08-11 09:00:00	SPY	ETF	127.28	127.29	126.83	126.89	6332800.0
2006-08-11 10:00:00	SPY	ETF	126.89	127.1	126.74	126.96	8595800.0
2006-08-11 11:00:00	SPY	ETF	126.97	127.04	126.64	126.68	5943900.0
2006-08-11 12:00:00	SPY	ETF	126.69	126.86	126.55	126.65	4121000.0
2006-08-11 13:00:00	SPY	ETF	126.6499	126.77	126.39	126.7	6404700.0
2006-08-11 14:00:00	SPY	ETF	126.71	126.83	126.49	126.7	3784100.0
2006-08-11 15:00:00	SPY	ETF	126.71	127.0	126.52	126.84	8973300.0
2006-08-11 16:00:00	SPY	ETF	126.85	127.06	126.84	126.95	1109100.0
2006-08-11 17:00:00	SPY	ETF	127.0	127.0	126.95	127.0	9700.0
2006-08-11 18:00:00	SPY	ETF	126.99	126.99	126.9	126.9	7100.0
2006-08-11 19:00:00	SPY	ETF	127.0	127.0	127.0	127.0	1100.0
2006-08-11 09:00:00	QQQ	ETF	36.65	36.69	36.5	36.52	10817100.0
2006-08-11 10:00:00	QQQ	ETF	36.52	36.67	36.47	36.62	16788300.0
2006-08-11 11:00:00	QQQ	ETF	36.61	36.65	36.44	36.47	11918400.0
2006-08-11 12:00:00	QQQ	ETF	36.46	36.53	36.43	36.49	7241800.0
2006-08-11 13:00:00	QQQ	ETF	36.49	36.54	36.37	36.47	12224600.0
2006-08-11 14:00:00	QQQ	ETF	36.47	36.52	36.4	36.46	6643400.0
2006-08-11 15:00:00	QQQ	ETF	36.45	36.54	36.41	36.54	11222000.0
2006-08-11 07:00:00	IWM	ETF	68.25	68.26	68.23	68.23	30100.0
2006-08-11 08:00:00	IWM	ETF	68.28	68.47	68.13	68.17	300000.0
2006-08-11 09:00:00	IWM	ETF	68.15	68.18	67.54	67.59	6854600.0
2006-08-11 10:00:00	IWM	ETF	67.59	67.85	67.45	67.71	5116300.0
2006-08-11 11:00:00	IWM	ETF	67.71	67.79	67.37	67.39	9255500.0
2006-08-11 12:00:00	IWM	ETF	67.39	67.6	67.3	67.46	4611500.0
2006-08-11 13:00:00	IWM	ETF	67.45	67.59	67.23	67.53	5301300.0
2006-08-11 14:00:00	IWM	ETF	67.54	67.66	67.39	67.51	4762300.0
2006-08-11 15:00:00	IWM	ETF	67.51	67.72	67.4	67.56	4980500.0
2006-08-11 16:00:00	IWM	ETF	67.61	67.66	67.5	67.65	334100.0
2006-08-11 17:00:00	IWM	ETF	67.76	67.92	67.63	67.63	6900.0
2006-08-11 18:00:00	IWM	ETF	67.6	67.6	67.6	67.6	100.0
2006-08-11 08:00:00	DIA	ETF	111.25	111.27	111.13	111.18	17200.0
2006-08-11 09:00:00	DIA	ETF	111.18	111.18	110.93	110.98	419300.0
2006-08-11 10:00:00	DIA	ETF	110.98	111.15	110.88	111.06	612500.0
2006-08-11 11:00:00	DIA	ETF	111.06	111.09	110.78	110.78	535700.0
2006-08-11 12:00:00	DIA	ETF	110.79	110.9	110.69	110.72	457900.0
2006-08-11 13:00:00	DIA	ETF	110.73	110.77	110.55	110.76	1094800.0
2006-08-11 14:00:00	DIA	ETF	110.78	110.88	110.62	110.8	1000300.0
2006-08-11 15:00:00	DIA	ETF	110.79	111.06	110.65	110.98	995500.0
2006-08-11 16:00:00	DIA	ETF	110.97	111.07	110.96	111.07	66100.0
2006-08-11 17:00:00	DIA	ETF	111.05	111.05	111.05	111.05	500.0
2006-08-11 18:00:00	DIA	ETF	111.08	111.09	111.07	111.09	1000.0
2006-08-11 07:00:00	GLD	ETF	63.5	63.5	63.5	63.5	500.0
2006-08-11 08:00:00	GLD	ETF	63.52	63.67	63.22	63.41	100600.0
2006-08-11 09:00:00	GLD	ETF	63.43	63.98	63.42	63.92	753800.0
2006-08-11 10:00:00	GLD	ETF	63.93	64.1	63.55	63.55	785300.0
2006-08-11 11:00:00	GLD	ETF	63.55	63.56	62.24	62.51	1799400.0
2006-08-11 12:00:00	GLD	ETF	62.51	62.97	62.46	62.64	1247100.0

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

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