PREVIEW / etf_1hour / 2016-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-18.parquet
  size:    254 KB
  rows:    8,141

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-04-18 04:00:00	SPY	ETF	207.21	207.45	206.92	207.38	36519.0
2016-04-18 05:00:00	SPY	ETF	207.47	207.55	207.25	207.47	24660.0
2016-04-18 06:00:00	SPY	ETF	207.46	207.73	207.25	207.3	65260.0
2016-04-18 07:00:00	SPY	ETF	207.29	207.38	207.18	207.23	154996.0
2016-04-18 08:00:00	SPY	ETF	207.24	207.52	206.44	207.16	1242288.0
2016-04-18 09:00:00	SPY	ETF	207.17	208.09	207.0	207.81	8301791.0
2016-04-18 10:00:00	SPY	ETF	207.805	208.84	207.79	208.654	14016711.0
2016-04-18 11:00:00	SPY	ETF	208.65	208.83	208.57	208.71	9397579.0
2016-04-18 12:00:00	SPY	ETF	208.71	209.115	208.68	208.93	7561378.0
2016-04-18 13:00:00	SPY	ETF	208.92	209.005	208.68	208.96	5682570.0
2016-04-18 14:00:00	SPY	ETF	208.95	209.27	208.75	209.1	8724926.0
2016-04-18 15:00:00	SPY	ETF	209.1	209.28	208.96	209.28	14167577.0
2016-04-18 16:00:00	SPY	ETF	209.26	209.26	207.8588	209.03	8891871.0
2016-04-18 17:00:00	SPY	ETF	209.05	209.07	208.96	208.96	88842.0
2016-04-18 18:00:00	SPY	ETF	208.97	209.05	208.93	209.03	180298.0
2016-04-18 19:00:00	SPY	ETF	209.05	209.25	209.03	209.19	96621.0
2016-04-18 04:00:00	QQQ	ETF	110.24	110.47	110.24	110.4	11200.0
2016-04-18 05:00:00	QQQ	ETF	110.52	110.52	110.45	110.51	2600.0
2016-04-18 06:00:00	QQQ	ETF	110.49	110.61	110.49	110.57	1848.0
2016-04-18 07:00:00	QQQ	ETF	110.4	110.44	110.35	110.35	61651.0
2016-04-18 08:00:00	QQQ	ETF	110.35	110.46	110.28	110.29	51476.0
2016-04-18 09:00:00	QQQ	ETF	110.31	110.65	110.25	110.63	1821811.0
2016-04-18 10:00:00	QQQ	ETF	110.625	111.265	110.625	111.17	3428727.0
2016-04-18 11:00:00	QQQ	ETF	111.17	111.19	110.74	110.802	2201375.0
2016-04-18 12:00:00	QQQ	ETF	110.81	111.14	110.8	111.02	1558356.0
2016-04-18 13:00:00	QQQ	ETF	111.01	111.11	110.84	111.08	1732883.0
2016-04-18 14:00:00	QQQ	ETF	111.0763	111.19	110.97	111.08	1658954.0
2016-04-18 15:00:00	QQQ	ETF	111.08	111.235	110.98	111.21	2725960.0
2016-04-18 16:00:00	QQQ	ETF	111.23	111.24	110.85	110.9	1095495.0
2016-04-18 17:00:00	QQQ	ETF	110.85	110.98	110.85	110.96	41312.0
2016-04-18 18:00:00	QQQ	ETF	110.92	110.98	110.86	110.98	21853.0
2016-04-18 19:00:00	QQQ	ETF	111.0	111.1	111.0	111.09	12750.0
2016-04-18 04:00:00	IWM	ETF	111.86	111.86	111.86	111.86	600.0
2016-04-18 05:00:00	IWM	ETF	112.09	112.09	111.98	112.07	2400.0
2016-04-18 06:00:00	IWM	ETF	112.22	112.22	112.2	112.21	20100.0
2016-04-18 07:00:00	IWM	ETF	112.05	112.05	111.94	111.94	51498.0
2016-04-18 08:00:00	IWM	ETF	111.99	112.11	111.9	112.0	55444.0
2016-04-18 09:00:00	IWM	ETF	112.0	112.48	111.87	112.42	1819847.0
2016-04-18 10:00:00	IWM	ETF	112.4	112.97	112.4	112.8263	2818695.0
2016-04-18 11:00:00	IWM	ETF	112.825	113.06	112.73	113.0	2009182.0
2016-04-18 12:00:00	IWM	ETF	113.0	113.25	112.93	113.105	1841654.0
2016-04-18 13:00:00	IWM	ETF	113.11	113.21	113.02	113.2	1037399.0
2016-04-18 14:00:00	IWM	ETF	113.2	113.39	113.02	113.31	2051113.0
2016-04-18 15:00:00	IWM	ETF	113.3	113.37	113.16	113.3	3785326.0
2016-04-18 16:00:00	IWM	ETF	113.3	113.35	112.8	113.3	2413412.0
2016-04-18 17:00:00	IWM	ETF	113.31	113.31	113.27	113.28	7781.0
2016-04-18 18:00:00	IWM	ETF	113.28	113.28	113.25	113.25	300.0
2016-04-18 19:00:00	IWM	ETF	113.22	113.37	113.2	113.37	13600.0
2016-04-18 07:00:00	DIA	ETF	178.33	178.33	178.31	178.31	830.0
2016-04-18 08:00:00	DIA	ETF	178.18	178.26	178.1	178.16	2200.0

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

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