PREVIEW / etf_1hour / 2017-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-10.parquet
  size:    277 KB
  rows:    8,909

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-02-10 04:00:00	SPY	ETF	230.85	230.94	230.83	230.9	17091.0
2017-02-10 05:00:00	SPY	ETF	230.94	230.94	230.94	230.94	1700.0
2017-02-10 06:00:00	SPY	ETF	230.76	230.84	230.75	230.76	49710.0
2017-02-10 07:00:00	SPY	ETF	230.7	230.94	230.7	230.9	52414.0
2017-02-10 08:00:00	SPY	ETF	230.92	230.94	230.791	230.87	150437.0
2017-02-10 09:00:00	SPY	ETF	230.88	231.2	230.88	231.09	7516813.0
2017-02-10 10:00:00	SPY	ETF	231.09	231.355	230.915	231.21	8050020.0
2017-02-10 11:00:00	SPY	ETF	231.21	231.25	231.065	231.25	5741557.0
2017-02-10 12:00:00	SPY	ETF	231.24	231.53	231.18	231.47	5444220.0
2017-02-10 13:00:00	SPY	ETF	231.47	231.77	231.45	231.585	6272519.0
2017-02-10 14:00:00	SPY	ETF	231.59	231.7	231.38	231.4	6511139.0
2017-02-10 15:00:00	SPY	ETF	231.41	231.62	231.4072	231.48	12777687.0
2017-02-10 16:00:00	SPY	ETF	231.47	231.6	231.42	231.49	12070145.0
2017-02-10 17:00:00	SPY	ETF	231.49	231.56	231.47	231.55	246809.0
2017-02-10 18:00:00	SPY	ETF	231.53	231.54	231.5	231.52	10618.0
2017-02-10 19:00:00	SPY	ETF	231.51	231.54	231.45	231.47	29742.0
2017-02-10 05:00:00	QQQ	ETF	127.26	127.26	127.18	127.18	500.0
2017-02-10 06:00:00	QQQ	ETF	127.19	127.2	127.15	127.19	20400.0
2017-02-10 07:00:00	QQQ	ETF	127.18	127.26	127.18	127.26	13600.0
2017-02-10 08:00:00	QQQ	ETF	127.19	127.25	127.18	127.21	81106.0
2017-02-10 09:00:00	QQQ	ETF	127.2	127.3	127.07	127.1	1900332.0
2017-02-10 10:00:00	QQQ	ETF	127.09	127.37	127.02	127.3	2129078.0
2017-02-10 11:00:00	QQQ	ETF	127.3	127.36	127.19	127.33	1245188.0
2017-02-10 12:00:00	QQQ	ETF	127.33	127.47	127.26	127.435	1101506.0
2017-02-10 13:00:00	QQQ	ETF	127.43	127.56	127.4151	127.44	1475401.0
2017-02-10 14:00:00	QQQ	ETF	127.44	127.49	127.36	127.375	880310.0
2017-02-10 15:00:00	QQQ	ETF	127.37	127.47	127.34	127.36	3091871.0
2017-02-10 16:00:00	QQQ	ETF	127.38	127.44	127.35	127.42	609978.0
2017-02-10 17:00:00	QQQ	ETF	127.43	127.44	127.38	127.38	122400.0
2017-02-10 18:00:00	QQQ	ETF	127.38	127.43	127.35	127.35	16385.0
2017-02-10 19:00:00	QQQ	ETF	127.35	127.38	127.33	127.38	9574.0
2017-02-10 05:00:00	IWM	ETF	137.38	137.38	137.32	137.32	900.0
2017-02-10 06:00:00	IWM	ETF	137.21	137.21	137.2	137.2	3400.0
2017-02-10 07:00:00	IWM	ETF	137.18	137.48	137.18	137.48	90771.0
2017-02-10 08:00:00	IWM	ETF	137.49	137.59	137.4	137.46	94535.0
2017-02-10 09:00:00	IWM	ETF	137.47	137.94	137.31	137.36	3022470.0
2017-02-10 10:00:00	IWM	ETF	137.36	137.8401	137.2	137.72	3227569.0
2017-02-10 11:00:00	IWM	ETF	137.73	137.76	137.56	137.701	1663105.0
2017-02-10 12:00:00	IWM	ETF	137.7	137.86	137.545	137.83	1506618.0
2017-02-10 13:00:00	IWM	ETF	137.83	138.37	137.825	138.1701	3771336.0
2017-02-10 14:00:00	IWM	ETF	138.17	138.26	137.8	137.86	2627375.0
2017-02-10 15:00:00	IWM	ETF	137.8601	138.12	137.85	137.97	3836412.0
2017-02-10 16:00:00	IWM	ETF	137.97	138.1	137.94	138.1	2723645.0
2017-02-10 17:00:00	IWM	ETF	138.04	138.04	138.0	138.04	1726.0
2017-02-10 18:00:00	IWM	ETF	138.05	138.08	138.05	138.08	10000.0
2017-02-10 19:00:00	IWM	ETF	138.03	138.07	138.0284	138.07	538579.0
2017-02-10 06:00:00	DIA	ETF	201.98	201.98	201.98	201.98	300.0
2017-02-10 08:00:00	DIA	ETF	202.26	202.31	201.9	201.9	110277.0
2017-02-10 09:00:00	DIA	ETF	202.16	202.41	202.0675	202.36	403339.0
2017-02-10 10:00:00	DIA	ETF	202.33	202.67	202.165	202.5	435036.0

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

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