PREVIEW / etf_1hour / 2016-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-09.parquet
  size:    276 KB
  rows:    8,865

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-09 04:00:00	SPY	ETF	225.15	225.28	225.07	225.1	11150.0
2016-12-09 05:00:00	SPY	ETF	225.17	225.28	225.16	225.28	14600.0
2016-12-09 06:00:00	SPY	ETF	225.27	225.43	225.27	225.41	59933.0
2016-12-09 07:00:00	SPY	ETF	225.43	225.46	225.35	225.46	112677.0
2016-12-09 08:00:00	SPY	ETF	225.44	225.61	225.28	225.58	587612.0
2016-12-09 09:00:00	SPY	ETF	225.59	225.8507	225.37	225.74	9063920.0
2016-12-09 10:00:00	SPY	ETF	225.75	226.015	225.48	225.804	12999655.0
2016-12-09 11:00:00	SPY	ETF	225.81	225.94	225.6	225.735	7853023.0
2016-12-09 12:00:00	SPY	ETF	225.74	225.99	225.67	225.85	6866479.0
2016-12-09 13:00:00	SPY	ETF	225.86	225.98	225.735	225.915	5127927.0
2016-12-09 14:00:00	SPY	ETF	225.92	226.07	225.85	226.065	6892069.0
2016-12-09 15:00:00	SPY	ETF	226.07	226.5	226.02	226.49	25674351.0
2016-12-09 16:00:00	SPY	ETF	226.5	226.63	226.44	226.63	10769449.0
2016-12-09 17:00:00	SPY	ETF	226.61	226.75	226.51	226.69	426775.0
2016-12-09 18:00:00	SPY	ETF	226.69	226.72	226.63	226.68	60450.0
2016-12-09 19:00:00	SPY	ETF	226.65	226.67	226.63	226.65	28551.0
2016-12-09 04:00:00	QQQ	ETF	118.64	118.64	118.64	118.64	416.0
2016-12-09 05:00:00	QQQ	ETF	118.63	118.79	118.63	118.79	2950.0
2016-12-09 06:00:00	QQQ	ETF	118.79	118.86	118.79	118.86	5100.0
2016-12-09 07:00:00	QQQ	ETF	118.87	118.87	118.84	118.85	3410.0
2016-12-09 08:00:00	QQQ	ETF	118.9	119.07	118.88	119.07	170011.0
2016-12-09 09:00:00	QQQ	ETF	119.08	119.43	119.0	119.4	3813381.0
2016-12-09 10:00:00	QQQ	ETF	119.41	119.5402	119.1	119.26	2575773.0
2016-12-09 11:00:00	QQQ	ETF	119.26	119.48	119.2436	119.4	1821125.0
2016-12-09 12:00:00	QQQ	ETF	119.4	119.44	119.22	119.24	1790646.0
2016-12-09 13:00:00	QQQ	ETF	119.25	119.35	119.1	119.31	1214420.0
2016-12-09 14:00:00	QQQ	ETF	119.3158	119.35	119.14	119.3073	1181870.0
2016-12-09 15:00:00	QQQ	ETF	119.31	119.5	119.27	119.5	3634057.0
2016-12-09 16:00:00	QQQ	ETF	119.5	119.51	119.3498	119.48	703746.0
2016-12-09 17:00:00	QQQ	ETF	119.1384	119.57	119.1384	119.52	222915.0
2016-12-09 18:00:00	QQQ	ETF	119.51	119.55	119.5	119.5	1805.0
2016-12-09 19:00:00	QQQ	ETF	119.5	119.5	119.48	119.48	1813.0
2016-12-09 04:00:00	IWM	ETF	137.98	138.02	137.9	137.95	3960.0
2016-12-09 06:00:00	IWM	ETF	138.2	138.32	138.2	138.32	29238.0
2016-12-09 07:00:00	IWM	ETF	138.36	138.47	138.3	138.37	43757.0
2016-12-09 08:00:00	IWM	ETF	138.37	138.53	138.14	138.45	154710.0
2016-12-09 09:00:00	IWM	ETF	138.46	138.78	138.32	138.62	4071084.0
2016-12-09 10:00:00	IWM	ETF	138.63	138.82	138.31	138.52	4709339.0
2016-12-09 11:00:00	IWM	ETF	138.525	138.57	137.99	138.31	4570419.0
2016-12-09 12:00:00	IWM	ETF	138.31	138.35	137.935	138.025	2753221.0
2016-12-09 13:00:00	IWM	ETF	138.03	138.19	137.75	138.16	2832214.0
2016-12-09 14:00:00	IWM	ETF	138.17	138.32	137.85	138.05	2238262.0
2016-12-09 15:00:00	IWM	ETF	138.0637	138.33	137.98	138.27	5742969.0
2016-12-09 16:00:00	IWM	ETF	138.31	138.38	138.16	138.19	1348165.0
2016-12-09 17:00:00	IWM	ETF	138.22	138.25	138.19	138.25	4827.0
2016-12-09 18:00:00	IWM	ETF	138.29	138.29	138.29	138.29	100.0
2016-12-09 19:00:00	IWM	ETF	138.21	138.21	138.21	138.21	474.0
2016-12-09 06:00:00	DIA	ETF	196.6	196.6	196.6	196.6	400.0
2016-12-09 08:00:00	DIA	ETF	196.78	196.78	196.51	196.65	7126.0
2016-12-09 09:00:00	DIA	ETF	196.61	196.7	196.37	196.57	496468.0

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

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