PREVIEW / etf_1hour / 2017-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-09.parquet
  size:    275 KB
  rows:    8,899

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
2017-01-09 04:00:00	SPY	ETF	227.21	227.23	227.12	227.18	10214.0
2017-01-09 05:00:00	SPY	ETF	227.21	227.21	227.04	227.08	6152.0
2017-01-09 06:00:00	SPY	ETF	227.08	227.08	226.83	226.96	29185.0
2017-01-09 07:00:00	SPY	ETF	226.95	227.06	226.9	227.06	47671.0
2017-01-09 08:00:00	SPY	ETF	226.91	227.11	226.84	226.92	279753.0
2017-01-09 09:00:00	SPY	ETF	226.91	226.93	226.4163	226.68	6081579.0
2017-01-09 10:00:00	SPY	ETF	226.685	227.02	226.47	226.979	8280455.0
2017-01-09 11:00:00	SPY	ETF	226.97	227.0701	226.73	226.84	3824158.0
2017-01-09 12:00:00	SPY	ETF	226.84	227.02	226.71	226.96	2952713.0
2017-01-09 13:00:00	SPY	ETF	226.96	226.98	226.65	226.77	4595107.0
2017-01-09 14:00:00	SPY	ETF	226.775	226.81	226.431	226.57	6453049.0
2017-01-09 15:00:00	SPY	ETF	226.57	226.81	226.44	226.49	8477552.0
2017-01-09 16:00:00	SPY	ETF	226.49	226.63	226.4105	226.48	4983639.0
2017-01-09 17:00:00	SPY	ETF	226.5	226.57	226.46	226.56	75639.0
2017-01-09 18:00:00	SPY	ETF	226.53	226.58	226.28	226.29	169528.0
2017-01-09 19:00:00	SPY	ETF	226.32	226.35	226.27	226.3	30388.0
2017-01-09 04:00:00	QQQ	ETF	122.04	122.05	121.99	122.05	21545.0
2017-01-09 05:00:00	QQQ	ETF	121.98	122.0	121.97	121.98	2099.0
2017-01-09 06:00:00	QQQ	ETF	121.96	121.96	121.89	121.92	1763.0
2017-01-09 07:00:00	QQQ	ETF	121.93	122.0	121.92	122.0	7044.0
2017-01-09 08:00:00	QQQ	ETF	121.97	122.01	121.92	121.96	21252.0
2017-01-09 09:00:00	QQQ	ETF	121.96	122.305	121.93	122.19	3208395.0
2017-01-09 10:00:00	QQQ	ETF	122.19	122.33	121.95	122.23	2111714.0
2017-01-09 11:00:00	QQQ	ETF	122.22	122.4	122.13	122.3	1336727.0
2017-01-09 12:00:00	QQQ	ETF	122.29	122.46	122.24	122.43	1777716.0
2017-01-09 13:00:00	QQQ	ETF	122.439	122.48	122.34	122.3861	1660212.0
2017-01-09 14:00:00	QQQ	ETF	122.38	122.395	122.21	122.3625	1174473.0
2017-01-09 15:00:00	QQQ	ETF	122.36	122.55	122.32	122.33	3021941.0
2017-01-09 16:00:00	QQQ	ETF	122.33	122.4	122.29	122.36	928102.0
2017-01-09 17:00:00	QQQ	ETF	122.28	122.4194	122.26	122.36	99933.0
2017-01-09 18:00:00	QQQ	ETF	122.4	122.4	122.23	122.23	12853.0
2017-01-09 19:00:00	QQQ	ETF	122.25	122.28	122.23	122.23	12725.0
2017-01-09 05:00:00	IWM	ETF	135.37	135.37	135.37	135.37	200.0
2017-01-09 06:00:00	IWM	ETF	135.4	135.4	135.28	135.29	1314.0
2017-01-09 07:00:00	IWM	ETF	135.26	135.32	135.24	135.32	15665.0
2017-01-09 08:00:00	IWM	ETF	135.31	135.48	135.3	135.32	74499.0
2017-01-09 09:00:00	IWM	ETF	135.35	135.72	134.5	135.09	3020554.0
2017-01-09 10:00:00	IWM	ETF	135.1	135.52	134.65	135.4836	3745702.0
2017-01-09 11:00:00	IWM	ETF	135.48	135.7	135.23	135.61	2752103.0
2017-01-09 12:00:00	IWM	ETF	135.61	135.65	135.26	135.475	1507628.0
2017-01-09 13:00:00	IWM	ETF	135.49	135.53	134.89	135.01	3085304.0
2017-01-09 14:00:00	IWM	ETF	135.0	135.0499	134.75	134.98	2326162.0
2017-01-09 15:00:00	IWM	ETF	134.97	135.09	134.73	134.78	3164524.0
2017-01-09 16:00:00	IWM	ETF	134.8	134.8934	134.65	134.66	1846271.0
2017-01-09 17:00:00	IWM	ETF	134.72	134.72	134.66	134.67	761.0
2017-01-09 18:00:00	IWM	ETF	134.75	134.8	134.68	134.68	2929.0
2017-01-09 19:00:00	IWM	ETF	134.69	134.69	134.63	134.65	7336.0
2017-01-09 08:00:00	DIA	ETF	199.23	199.23	199.08	199.13	11450.0
2017-01-09 09:00:00	DIA	ETF	199.13	199.13	198.75	198.94	440608.0
2017-01-09 10:00:00	DIA	ETF	198.94	199.21	198.8	199.185	283006.0

> showing 50 of 8,899 rows — these rows as CSV

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