PREVIEW / etf_1hour / 2017-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-05.parquet
  size:    277 KB
  rows:    8,941

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-05 04:00:00	SPY	ETF	226.3	226.44	226.1	226.44	22102.0
2017-01-05 05:00:00	SPY	ETF	226.42	226.46	226.15	226.42	18519.0
2017-01-05 06:00:00	SPY	ETF	226.4	226.4	226.29	226.35	34368.0
2017-01-05 07:00:00	SPY	ETF	226.36	226.37	225.98	226.02	126538.0
2017-01-05 08:00:00	SPY	ETF	226.03	226.37	226.01	226.25	2635104.0
2017-01-05 09:00:00	SPY	ETF	226.27	226.55	226.11	226.36	5599404.0
2017-01-05 10:00:00	SPY	ETF	226.37	226.58	226.18	226.34	10533659.0
2017-01-05 11:00:00	SPY	ETF	226.34	226.37	225.48	225.69	12965826.0
2017-01-05 12:00:00	SPY	ETF	225.69	225.9901	225.59	225.93	6686927.0
2017-01-05 13:00:00	SPY	ETF	225.93	226.15	225.89	226.02	7624843.0
2017-01-05 14:00:00	SPY	ETF	226.02	226.3	226.01	226.01	4671756.0
2017-01-05 15:00:00	SPY	ETF	226.01	226.49	225.98	226.36	10282467.0
2017-01-05 16:00:00	SPY	ETF	226.39	226.52	226.2472	226.51	10916699.0
2017-01-05 17:00:00	SPY	ETF	226.5261	226.5261	226.44	226.45	543900.0
2017-01-05 18:00:00	SPY	ETF	226.45	226.52	226.41	226.43	57295.0
2017-01-05 19:00:00	SPY	ETF	226.41	226.44	226.34	226.43	24395.0
2017-01-05 04:00:00	QQQ	ETF	120.03	120.03	120.03	120.03	300.0
2017-01-05 06:00:00	QQQ	ETF	120.07	120.07	120.07	120.07	400.0
2017-01-05 07:00:00	QQQ	ETF	120.08	120.09	119.87	119.91	33604.0
2017-01-05 08:00:00	QQQ	ETF	119.9	120.1	119.89	120.07	44899.0
2017-01-05 09:00:00	QQQ	ETF	120.02	120.78	120.02	120.65	2322961.0
2017-01-05 10:00:00	QQQ	ETF	120.66	120.82	120.52	120.6993	2760468.0
2017-01-05 11:00:00	QQQ	ETF	120.69	120.75	120.35	120.5657	1985452.0
2017-01-05 12:00:00	QQQ	ETF	120.57	120.72	120.49	120.68	925995.0
2017-01-05 13:00:00	QQQ	ETF	120.68	120.75	120.63	120.65	1495559.0
2017-01-05 14:00:00	QQQ	ETF	120.65	120.79	120.64	120.6953	1621850.0
2017-01-05 15:00:00	QQQ	ETF	120.69	120.95	120.6701	120.87	4220614.0
2017-01-05 16:00:00	QQQ	ETF	120.84	120.94	120.83	120.94	524378.0
2017-01-05 17:00:00	QQQ	ETF	120.95	120.98	120.9	120.95	7570.0
2017-01-05 18:00:00	QQQ	ETF	120.91	120.94	120.9	120.91	15639.0
2017-01-05 19:00:00	QQQ	ETF	120.88	120.9	120.85	120.9	8205.0
2017-01-05 05:00:00	IWM	ETF	137.57	137.57	137.43	137.43	1200.0
2017-01-05 06:00:00	IWM	ETF	137.54	137.54	137.54	137.54	2500.0
2017-01-05 07:00:00	IWM	ETF	137.55	137.55	137.25	137.37	10525.0
2017-01-05 08:00:00	IWM	ETF	137.34	137.51	137.34	137.41	45053.0
2017-01-05 09:00:00	IWM	ETF	137.45	137.76	136.99	137.3	2869501.0
2017-01-05 10:00:00	IWM	ETF	137.29	137.54	137.02	137.03	2762087.0
2017-01-05 11:00:00	IWM	ETF	137.02	137.08	135.51	135.88	6101557.0
2017-01-05 12:00:00	IWM	ETF	135.88	136.21	135.61	136.09	2989066.0
2017-01-05 13:00:00	IWM	ETF	136.0858	136.36	135.98	136.17	1735722.0
2017-01-05 14:00:00	IWM	ETF	136.17	136.5682	136.15	136.205	2422195.0
2017-01-05 15:00:00	IWM	ETF	136.2	136.54	136.14	136.15	4658133.0
2017-01-05 16:00:00	IWM	ETF	136.15	137.17	136.08	136.25	1219242.0
2017-01-05 17:00:00	IWM	ETF	136.2415	136.25	136.07	136.1979	1255971.0
2017-01-05 18:00:00	IWM	ETF	136.15	136.18	136.14	136.18	300.0
2017-01-05 19:00:00	IWM	ETF	136.12	136.14	136.1	136.14	4153.0
2017-01-05 08:00:00	DIA	ETF	198.98	198.98	198.98	198.98	240.0
2017-01-05 09:00:00	DIA	ETF	198.79	199.265	198.79	199.19	684541.0
2017-01-05 10:00:00	DIA	ETF	199.21	199.235	198.85	198.98	571942.0
2017-01-05 11:00:00	DIA	ETF	198.95	198.98	197.895	198.14	677137.0

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

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