PREVIEW / etf_1hour / 2016-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-16.parquet
  size:    259 KB
  rows:    8,361

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-02-16 04:00:00	SPY	ETF	189.47	189.49	188.64	188.68	107670.0
2016-02-16 05:00:00	SPY	ETF	188.82	188.89	188.42	188.5	75189.0
2016-02-16 06:00:00	SPY	ETF	188.68	189.04	188.48	189.04	75013.0
2016-02-16 07:00:00	SPY	ETF	189.04	189.12	188.74	188.75	389245.0
2016-02-16 08:00:00	SPY	ETF	188.75	189.962	188.13	188.46	2620327.0
2016-02-16 09:00:00	SPY	ETF	188.4	189.02	188.15	188.29	15332722.0
2016-02-16 10:00:00	SPY	ETF	188.3	188.635	187.84	188.07	14466570.0
2016-02-16 11:00:00	SPY	ETF	188.06	188.94	187.63	188.9	12656627.0
2016-02-16 12:00:00	SPY	ETF	188.89	189.47	188.85	189.45	10540214.0
2016-02-16 13:00:00	SPY	ETF	189.45	189.73	189.29	189.45	10533805.0
2016-02-16 14:00:00	SPY	ETF	189.45	189.78	189.37	189.425	11541227.0
2016-02-16 15:00:00	SPY	ETF	189.43	189.77	189.17	189.77	23616263.0
2016-02-16 16:00:00	SPY	ETF	189.76	189.86	186.6965	189.5	13545670.0
2016-02-16 17:00:00	SPY	ETF	189.48	189.81	189.4	189.45	301043.0
2016-02-16 18:00:00	SPY	ETF	189.43	189.5	189.16	189.5	101337.0
2016-02-16 19:00:00	SPY	ETF	189.53	190.29	189.53	190.22	324232.0
2016-02-16 04:00:00	QQQ	ETF	99.82	99.91	99.46	99.46	13608.0
2016-02-16 05:00:00	QQQ	ETF	99.53	99.53	99.31	99.35	4300.0
2016-02-16 06:00:00	QQQ	ETF	99.46	99.56	99.3	99.56	7055.0
2016-02-16 07:00:00	QQQ	ETF	99.59	99.62	99.41	99.43	66165.0
2016-02-16 08:00:00	QQQ	ETF	99.41	100.17	99.1	99.28	1177574.0
2016-02-16 09:00:00	QQQ	ETF	99.3	99.95	99.24	99.57	6295504.0
2016-02-16 10:00:00	QQQ	ETF	99.55	99.7	99.15	99.21	4664256.0
2016-02-16 11:00:00	QQQ	ETF	99.21	99.63	98.85	99.609	3400221.0
2016-02-16 12:00:00	QQQ	ETF	99.61	99.87	99.49	99.85	3314528.0
2016-02-16 13:00:00	QQQ	ETF	99.85	100.02	99.78	99.915	3049200.0
2016-02-16 14:00:00	QQQ	ETF	99.92	100.12	99.85	99.92	3009346.0
2016-02-16 15:00:00	QQQ	ETF	99.93	100.16	99.76	100.14	5814928.0
2016-02-16 16:00:00	QQQ	ETF	100.15	100.26	99.6097	99.94	3765094.0
2016-02-16 17:00:00	QQQ	ETF	99.95	100.03	99.91	99.93	32766.0
2016-02-16 18:00:00	QQQ	ETF	99.93	99.95	99.8	99.88	18888.0
2016-02-16 19:00:00	QQQ	ETF	100.06	100.34	100.03	100.33	58271.0
2016-02-16 04:00:00	IWM	ETF	98.15	98.15	97.77	97.83	8454.0
2016-02-16 05:00:00	IWM	ETF	97.7	97.83	97.7	97.81	7588.0
2016-02-16 06:00:00	IWM	ETF	97.83	97.89	97.74	97.89	2063.0
2016-02-16 07:00:00	IWM	ETF	97.96	98.0	97.86	97.86	13944.0
2016-02-16 08:00:00	IWM	ETF	97.82	97.89	97.46	97.62	223859.0
2016-02-16 09:00:00	IWM	ETF	97.66	97.91	97.31	97.425	5706135.0
2016-02-16 10:00:00	IWM	ETF	97.42	98.22	97.22	97.87	5200034.0
2016-02-16 11:00:00	IWM	ETF	97.86	98.73	97.455	98.72	4110273.0
2016-02-16 12:00:00	IWM	ETF	98.72	98.86	98.3781	98.8	3126610.0
2016-02-16 13:00:00	IWM	ETF	98.8	99.02	98.59	98.84	3078676.0
2016-02-16 14:00:00	IWM	ETF	98.83	98.96	98.69	98.75	3708022.0
2016-02-16 15:00:00	IWM	ETF	98.76	99.0999	98.58	98.9	7096142.0
2016-02-16 16:00:00	IWM	ETF	98.91	99.07	98.6	98.7	3743385.0
2016-02-16 17:00:00	IWM	ETF	98.71	98.84	98.71	98.83	109974.0
2016-02-16 18:00:00	IWM	ETF	98.74	98.74	98.74	98.74	900.0
2016-02-16 19:00:00	IWM	ETF	98.74	99.0	98.65	98.98	15792.0
2016-02-16 20:00:00	IWM	ETF	99.0023	99.0023	99.0023	99.0023	400000.0
2016-02-16 04:00:00	DIA	ETF	161.71	162.2	161.71	161.78	1750.0

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

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