PREVIEW / etf_1hour / 2006-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-20.parquet
  size:    56 KB
  rows:    1,783

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-20 04:00:00	SPY	ETF	140.0	140.0	139.91	139.91	2200.0
2006-11-20 06:00:00	SPY	ETF	140.13	140.13	140.13	140.13	500.0
2006-11-20 07:00:00	SPY	ETF	140.13	140.21	140.01	140.21	326600.0
2006-11-20 08:00:00	SPY	ETF	140.11	140.35	139.92	140.26	5119500.0
2006-11-20 09:00:00	SPY	ETF	140.26	140.39	140.09	140.34	8285500.0
2006-11-20 10:00:00	SPY	ETF	140.34	140.68	140.19	140.65	11764800.0
2006-11-20 11:00:00	SPY	ETF	140.65	140.74	140.5	140.62	6354000.0
2006-11-20 12:00:00	SPY	ETF	140.62	140.7	140.43	140.6	5257600.0
2006-11-20 13:00:00	SPY	ETF	140.6	140.66	140.45	140.54	4706600.0
2006-11-20 14:00:00	SPY	ETF	140.54	140.7	140.1	140.33	10764000.0
2006-11-20 15:00:00	SPY	ETF	140.32	140.4	140.15	140.37	9448000.0
2006-11-20 16:00:00	SPY	ETF	140.37	140.53	140.34	140.4	1380900.0
2006-11-20 17:00:00	SPY	ETF	140.42	140.44	140.38	140.38	58000.0
2006-11-20 18:00:00	SPY	ETF	140.42	140.44	140.41	140.44	11800.0
2006-11-20 19:00:00	SPY	ETF	140.42	140.42	140.37	140.37	4900.0
2006-11-20 09:00:00	QQQ	ETF	44.16	44.23	44.01	44.19	23450300.0
2006-11-20 10:00:00	QQQ	ETF	44.19	44.42	44.12	44.39	18864900.0
2006-11-20 11:00:00	QQQ	ETF	44.38	44.41	44.3	44.36	7073500.0
2006-11-20 12:00:00	QQQ	ETF	44.36	44.4	44.3	44.37	5659800.0
2006-11-20 13:00:00	QQQ	ETF	44.36	44.41	44.32	44.38	3608300.0
2006-11-20 14:00:00	QQQ	ETF	44.38	44.48	44.13	44.27	20149300.0
2006-11-20 15:00:00	QQQ	ETF	44.28	44.38	44.21	44.38	11073300.0
2006-11-20 07:00:00	IWM	ETF	78.34	78.34	78.34	78.34	100.0
2006-11-20 08:00:00	IWM	ETF	78.33	78.4	78.28	78.28	865200.0
2006-11-20 09:00:00	IWM	ETF	78.34	78.5	78.11	78.41	6234000.0
2006-11-20 10:00:00	IWM	ETF	78.41	78.83	78.33	78.77	8365400.0
2006-11-20 11:00:00	IWM	ETF	78.78	78.83	78.406	78.67	4130800.0
2006-11-20 12:00:00	IWM	ETF	78.67	78.79	78.51	78.63	8618900.0
2006-11-20 13:00:00	IWM	ETF	78.63	78.69	78.56	78.61	2547700.0
2006-11-20 14:00:00	IWM	ETF	78.61	78.77	78.24	78.43	6876400.0
2006-11-20 15:00:00	IWM	ETF	78.43	78.69	78.35	78.68	7521600.0
2006-11-20 16:00:00	IWM	ETF	78.68	78.78	78.64	78.65	471900.0
2006-11-20 18:00:00	IWM	ETF	78.65	78.65	78.65	78.65	1100.0
2006-11-20 19:00:00	IWM	ETF	78.63	78.65	78.63	78.65	800.0
2006-11-20 07:00:00	DIA	ETF	123.07	123.07	123.07	123.07	200.0
2006-11-20 08:00:00	DIA	ETF	123.11	123.2	123.03	123.15	10100.0
2006-11-20 09:00:00	DIA	ETF	123.16	123.25	123.0	123.21	608300.0
2006-11-20 10:00:00	DIA	ETF	123.22	123.33	123.06	123.31	1497300.0
2006-11-20 11:00:00	DIA	ETF	123.3092	123.45	123.24	123.35	503300.0
2006-11-20 12:00:00	DIA	ETF	123.33	123.39	123.2	123.29	337200.0
2006-11-20 13:00:00	DIA	ETF	123.29	123.34	123.22	123.27	246300.0
2006-11-20 14:00:00	DIA	ETF	123.2699	123.37	122.9	123.05	1046900.0
2006-11-20 15:00:00	DIA	ETF	123.04	123.1199	122.9	123.06	535500.0
2006-11-20 16:00:00	DIA	ETF	123.07	123.16	123.06	123.08	57200.0
2006-11-20 17:00:00	DIA	ETF	123.15	123.15	123.15	123.15	300.0
2006-11-20 08:00:00	GLD	ETF	61.9	62.04	61.9	62.0	27600.0
2006-11-20 09:00:00	GLD	ETF	61.96	62.25	61.91	62.0901	930400.0
2006-11-20 10:00:00	GLD	ETF	62.1	62.17	61.93	62.06	400600.0
2006-11-20 11:00:00	GLD	ETF	62.05	62.08	61.87	61.96	634500.0
2006-11-20 12:00:00	GLD	ETF	61.98	61.99	61.56	61.6899	402400.0

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

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