PREVIEW / etf_1hour / 2016-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-23.parquet
  size:    257 KB
  rows:    8,427

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
2016-12-23 04:00:00	SPY	ETF	225.58	225.73	225.58	225.71	5213.0
2016-12-23 05:00:00	SPY	ETF	225.67	225.73	225.67	225.69	1504.0
2016-12-23 06:00:00	SPY	ETF	225.69	225.69	225.59	225.59	3102.0
2016-12-23 07:00:00	SPY	ETF	225.61	225.63	225.34	225.47	58780.0
2016-12-23 08:00:00	SPY	ETF	225.61	225.63	225.36	225.43	87879.0
2016-12-23 09:00:00	SPY	ETF	225.43	225.59	225.31	225.525	3929970.0
2016-12-23 10:00:00	SPY	ETF	225.529	225.62	225.33	225.4197	5411208.0
2016-12-23 11:00:00	SPY	ETF	225.415	225.45	225.21	225.4	2226679.0
2016-12-23 12:00:00	SPY	ETF	225.4	225.48	225.35	225.355	1667990.0
2016-12-23 13:00:00	SPY	ETF	225.36	225.47	225.32	225.44	3460552.0
2016-12-23 14:00:00	SPY	ETF	225.43	225.5	225.4	225.5	3319247.0
2016-12-23 15:00:00	SPY	ETF	225.5	225.72	225.45	225.69	9377246.0
2016-12-23 16:00:00	SPY	ETF	225.69	225.83	225.4788	225.67	6334039.0
2016-12-23 17:00:00	SPY	ETF	225.66	225.7	225.59	225.59	29015.0
2016-12-23 18:00:00	SPY	ETF	225.64	225.64	225.58	225.63	10411.0
2016-12-23 19:00:00	SPY	ETF	225.63	225.66	225.63	225.66	4606.0
2016-12-23 06:00:00	QQQ	ETF	120.08	120.08	120.02	120.02	1019.0
2016-12-23 07:00:00	QQQ	ETF	120.04	120.05	119.9	120.0	72602.0
2016-12-23 08:00:00	QQQ	ETF	120.02	120.05	119.98	119.98	13116.0
2016-12-23 09:00:00	QQQ	ETF	119.98	120.24	119.86	120.13	1606824.0
2016-12-23 10:00:00	QQQ	ETF	120.13	120.23	119.9018	119.94	1671507.0
2016-12-23 11:00:00	QQQ	ETF	119.945	119.995	119.81	119.9544	711651.0
2016-12-23 12:00:00	QQQ	ETF	119.955	120.1	119.955	120.0	421255.0
2016-12-23 13:00:00	QQQ	ETF	120.0	120.1	120.0	120.04	455896.0
2016-12-23 14:00:00	QQQ	ETF	120.029	120.11	120.01	120.0701	416441.0
2016-12-23 15:00:00	QQQ	ETF	120.07	120.25	120.055	120.21	1366424.0
2016-12-23 16:00:00	QQQ	ETF	120.2	120.29	120.1719	120.21	333516.0
2016-12-23 17:00:00	QQQ	ETF	119.84	120.23	119.84	120.18	1345.0
2016-12-23 18:00:00	QQQ	ETF	120.2	120.23	120.2	120.23	314.0
2016-12-23 19:00:00	QQQ	ETF	120.2	120.2	120.15	120.2	3018.0
2016-12-23 07:00:00	IWM	ETF	135.34	135.37	135.21	135.37	55425.0
2016-12-23 08:00:00	IWM	ETF	135.37	135.5	135.33	135.5	47480.0
2016-12-23 09:00:00	IWM	ETF	135.5	135.915	135.35	135.37	1358258.0
2016-12-23 10:00:00	IWM	ETF	135.38	136.02	135.27	135.65	3279999.0
2016-12-23 11:00:00	IWM	ETF	135.6625	135.84	135.51	135.58	1440437.0
2016-12-23 12:00:00	IWM	ETF	135.57	135.78	135.51	135.69	1904843.0
2016-12-23 13:00:00	IWM	ETF	135.68	135.86	135.61	135.73	886839.0
2016-12-23 14:00:00	IWM	ETF	135.73	135.9	135.67	135.79	1086789.0
2016-12-23 15:00:00	IWM	ETF	135.8	136.12	135.7697	136.05	2805345.0
2016-12-23 16:00:00	IWM	ETF	136.04	136.19	135.89	135.95	516505.0
2016-12-23 17:00:00	IWM	ETF	135.97	136.04	135.97	136.04	3000.0
2016-12-23 18:00:00	IWM	ETF	136.02	136.02	136.02	136.02	200.0
2016-12-23 19:00:00	IWM	ETF	136.0	136.0	136.0	136.0	200.0
2016-12-23 07:00:00	DIA	ETF	198.8	198.8	198.73	198.73	200.0
2016-12-23 08:00:00	DIA	ETF	198.91	198.96	198.87	198.96	625.0
2016-12-23 09:00:00	DIA	ETF	198.86	198.98	198.79	198.94	164215.0
2016-12-23 10:00:00	DIA	ETF	198.95	199.02	198.8101	198.83	232898.0
2016-12-23 11:00:00	DIA	ETF	198.8201	198.88	198.73	198.82	120489.0
2016-12-23 12:00:00	DIA	ETF	198.82	198.875	198.8	198.825	125978.0
2016-12-23 13:00:00	DIA	ETF	198.8264	198.94	198.79	198.91	126904.0

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

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