PREVIEW / etf_1hour / 2015-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-22.parquet
  size:    249 KB
  rows:    7,933

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
2015-12-22 04:00:00	SPY	ETF	202.12	202.22	201.25	201.47	152792.0
2015-12-22 05:00:00	SPY	ETF	201.43	202.12	201.43	202.1	22139.0
2015-12-22 06:00:00	SPY	ETF	201.95	202.36	201.95	202.01	33595.0
2015-12-22 07:00:00	SPY	ETF	202.03	202.46	201.76	202.43	352609.0
2015-12-22 08:00:00	SPY	ETF	202.41	202.45	202.09	202.28	428913.0
2015-12-22 09:00:00	SPY	ETF	202.32	202.83	201.65	201.92	13091652.0
2015-12-22 10:00:00	SPY	ETF	201.9289	202.4	201.55	202.1	13946713.0
2015-12-22 11:00:00	SPY	ETF	202.1	202.67	201.8	202.48	10022783.0
2015-12-22 12:00:00	SPY	ETF	202.49	202.95	202.13	202.95	7258186.0
2015-12-22 13:00:00	SPY	ETF	202.95	203.27	202.65	203.24	10051544.0
2015-12-22 14:00:00	SPY	ETF	203.24	203.39	203.0601	203.34	13381524.0
2015-12-22 15:00:00	SPY	ETF	203.34	203.85	202.99	203.51	29080201.0
2015-12-22 16:00:00	SPY	ETF	203.51	204.03	203.39	203.82	10775644.0
2015-12-22 17:00:00	SPY	ETF	203.82	203.9	203.82	203.85	154685.0
2015-12-22 18:00:00	SPY	ETF	203.81	203.98	203.46	203.81	460046.0
2015-12-22 19:00:00	SPY	ETF	203.82	203.82	203.66	203.72	107539.0
2015-12-22 04:00:00	QQQ	ETF	111.33	111.36	110.85	110.85	9100.0
2015-12-22 05:00:00	QQQ	ETF	110.95	111.15	110.95	111.15	2600.0
2015-12-22 06:00:00	QQQ	ETF	111.3	111.42	111.2	111.2	1100.0
2015-12-22 07:00:00	QQQ	ETF	111.15	111.47	111.1	111.45	115798.0
2015-12-22 08:00:00	QQQ	ETF	111.45	111.46	111.19	111.33	85193.0
2015-12-22 09:00:00	QQQ	ETF	111.39	111.67	111.09	111.24	2969485.0
2015-12-22 10:00:00	QQQ	ETF	111.232	111.5799	111.11	111.241	3140505.0
2015-12-22 11:00:00	QQQ	ETF	111.2496	111.53	111.05	111.361	2341200.0
2015-12-22 12:00:00	QQQ	ETF	111.38	111.52	111.0782	111.5015	2560717.0
2015-12-22 13:00:00	QQQ	ETF	111.51	111.61	111.25	111.58	3990810.0
2015-12-22 14:00:00	QQQ	ETF	111.58	111.72	111.52	111.7156	2016688.0
2015-12-22 15:00:00	QQQ	ETF	111.72	111.94	111.49	111.76	4932348.0
2015-12-22 16:00:00	QQQ	ETF	111.76	112.06	111.0825	111.96	2183734.0
2015-12-22 17:00:00	QQQ	ETF	112.0	112.0	111.93	111.93	6404.0
2015-12-22 18:00:00	QQQ	ETF	111.97	112.01	111.9	111.93	20404.0
2015-12-22 19:00:00	QQQ	ETF	111.95	111.95	111.86	111.87	3200.0
2015-12-22 04:00:00	IWM	ETF	112.2	112.2	112.2	112.2	100.0
2015-12-22 05:00:00	IWM	ETF	112.24	112.24	112.24	112.24	300.0
2015-12-22 07:00:00	IWM	ETF	112.54	112.54	112.54	112.54	130.0
2015-12-22 08:00:00	IWM	ETF	112.47	112.47	112.3	112.36	16106.0
2015-12-22 09:00:00	IWM	ETF	112.4	112.65	112.01	112.06	2870126.0
2015-12-22 10:00:00	IWM	ETF	112.06	112.401	111.79	112.1	3539410.0
2015-12-22 11:00:00	IWM	ETF	112.1	112.52	112.02	112.34	2501757.0
2015-12-22 12:00:00	IWM	ETF	112.35	112.74	112.04	112.72	2120469.0
2015-12-22 13:00:00	IWM	ETF	112.73	113.04	112.6	113.0	2031646.0
2015-12-22 14:00:00	IWM	ETF	113.0	113.35	112.91	113.2	2792369.0
2015-12-22 15:00:00	IWM	ETF	113.205	113.52	113.0	113.36	5796700.0
2015-12-22 16:00:00	IWM	ETF	113.35	113.7	112.81	113.42	2906710.0
2015-12-22 17:00:00	IWM	ETF	113.4	113.4	113.4	113.4	354.0
2015-12-22 18:00:00	IWM	ETF	113.38	113.38	113.38	113.38	200.0
2015-12-22 19:00:00	IWM	ETF	113.41	113.41	113.41	113.41	100.0
2015-12-22 04:00:00	DIA	ETF	172.3	172.3	172.3	172.3	200.0
2015-12-22 07:00:00	DIA	ETF	172.61	172.61	172.61	172.61	1100.0
2015-12-22 08:00:00	DIA	ETF	172.75	172.75	172.65	172.65	400.0

> showing 50 of 7,933 rows — these rows as CSV

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