PREVIEW / etf_1hour / 2006-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-17.parquet
  size:    57 KB
  rows:    1,777

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-11-17 07:00:00	SPY	ETF	140.25	140.26	140.18	140.23	50800.0
2006-11-17 08:00:00	SPY	ETF	140.25	140.26	139.93	140.0	764200.0
2006-11-17 09:00:00	SPY	ETF	140.05	140.06	139.73	140.03	7404700.0
2006-11-17 10:00:00	SPY	ETF	140.03	140.13	139.82	139.97	10410100.0
2006-11-17 11:00:00	SPY	ETF	139.97	140.09	139.83	139.97	5752500.0
2006-11-17 12:00:00	SPY	ETF	139.99	140.42	139.97	140.21	8441700.0
2006-11-17 13:00:00	SPY	ETF	140.19	140.37	140.12	140.13	2809100.0
2006-11-17 14:00:00	SPY	ETF	140.13	140.35	139.97	140.31	5391100.0
2006-11-17 15:00:00	SPY	ETF	140.31	140.4	140.14	140.38	9722100.0
2006-11-17 16:00:00	SPY	ETF	140.37	140.5	140.2	140.42	1496500.0
2006-11-17 17:00:00	SPY	ETF	140.42	140.45	140.35	140.45	399300.0
2006-11-17 18:00:00	SPY	ETF	140.39	140.39	140.39	140.39	800.0
2006-11-17 19:00:00	SPY	ETF	140.43	140.44	140.43	140.44	900.0
2006-11-17 09:00:00	QQQ	ETF	44.07	44.2	44.03	44.19	8925400.0
2006-11-17 10:00:00	QQQ	ETF	44.2	44.2	44.0	44.02	22942500.0
2006-11-17 11:00:00	QQQ	ETF	44.03	44.09	43.95	44.07	10907300.0
2006-11-17 12:00:00	QQQ	ETF	44.08	44.25	44.06	44.2	10329600.0
2006-11-17 13:00:00	QQQ	ETF	44.2	44.23	44.15	44.15	3881300.0
2006-11-17 14:00:00	QQQ	ETF	44.15	44.25	44.1	44.21	8162300.0
2006-11-17 15:00:00	QQQ	ETF	44.21	44.29	44.17	44.28	11446300.0
2006-11-17 08:00:00	IWM	ETF	78.5	78.5	78.33	78.36	211100.0
2006-11-17 09:00:00	IWM	ETF	78.38	78.43	78.14	78.36	5604800.0
2006-11-17 10:00:00	IWM	ETF	78.37	78.39	78.02	78.09	4342500.0
2006-11-17 11:00:00	IWM	ETF	78.09	78.15	77.84	78.13	6504200.0
2006-11-17 12:00:00	IWM	ETF	78.14	78.36	78.11	78.24	2496300.0
2006-11-17 13:00:00	IWM	ETF	78.23	78.28	78.08	78.11	2230900.0
2006-11-17 14:00:00	IWM	ETF	78.11	78.44	78.09	78.3625	4576900.0
2006-11-17 15:00:00	IWM	ETF	78.36	78.4	78.26	78.38	3961800.0
2006-11-17 16:00:00	IWM	ETF	78.37	78.7	78.28	78.65	4504100.0
2006-11-17 17:00:00	IWM	ETF	78.65	78.65	78.6	78.6	390200.0
2006-11-17 18:00:00	IWM	ETF	78.6	78.6	78.59	78.59	700.0
2006-11-17 07:00:00	DIA	ETF	123.23	123.23	123.11	123.11	2000.0
2006-11-17 08:00:00	DIA	ETF	123.08	123.12	122.8	122.81	77300.0
2006-11-17 09:00:00	DIA	ETF	122.85	122.87	122.67	122.86	798900.0
2006-11-17 10:00:00	DIA	ETF	122.86	122.95	122.7	122.85	1411600.0
2006-11-17 11:00:00	DIA	ETF	122.85	122.94	122.72	122.85	872000.0
2006-11-17 12:00:00	DIA	ETF	122.86	123.2	122.86	123.1	766300.0
2006-11-17 13:00:00	DIA	ETF	123.09	123.12	122.96	122.98	388600.0
2006-11-17 14:00:00	DIA	ETF	122.97	123.18	122.85	123.15	760600.0
2006-11-17 15:00:00	DIA	ETF	123.16	123.27	123.04	123.25	1026400.0
2006-11-17 16:00:00	DIA	ETF	123.24	123.31	123.15	123.17	94700.0
2006-11-17 17:00:00	DIA	ETF	123.17	123.17	123.17	123.17	400.0
2006-11-17 19:00:00	DIA	ETF	123.17	123.17	123.17	123.17	100.0
2006-11-17 07:00:00	GLD	ETF	61.11	61.11	61.08	61.08	4700.0
2006-11-17 08:00:00	GLD	ETF	61.12	61.37	60.97	61.1	113900.0
2006-11-17 09:00:00	GLD	ETF	61.11	61.54	61.11	61.45	738600.0
2006-11-17 10:00:00	GLD	ETF	61.46	61.78	61.4	61.48	848300.0
2006-11-17 11:00:00	GLD	ETF	61.48	61.69	61.42	61.6598	426100.0
2006-11-17 12:00:00	GLD	ETF	61.6488	61.76	61.5	61.61	622300.0
2006-11-17 13:00:00	GLD	ETF	61.61	61.78	61.6	61.75	182300.0

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

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