PREVIEW / etf_1hour / 2016-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-04.parquet
  size:    252 KB
  rows:    8,098

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-04 04:00:00	SPY	ETF	191.77	192.42	191.54	192.42	40579.0
2016-02-04 05:00:00	SPY	ETF	192.43	192.52	191.83	192.02	244087.0
2016-02-04 06:00:00	SPY	ETF	191.96	192.08	191.47	191.55	59796.0
2016-02-04 07:00:00	SPY	ETF	191.57	191.86	190.72	190.93	357907.0
2016-02-04 08:00:00	SPY	ETF	190.91	191.8	189.62	190.08	3935622.0
2016-02-04 09:00:00	SPY	ETF	190.07	191.37	189.96	191.02	19191927.0
2016-02-04 10:00:00	SPY	ETF	191.02	192.75	190.155	192.685	27679087.0
2016-02-04 11:00:00	SPY	ETF	192.67	192.7	190.3	190.64	21900927.0
2016-02-04 12:00:00	SPY	ETF	190.64	191.86	190.5	191.29	14609684.0
2016-02-04 13:00:00	SPY	ETF	191.3	192.0	190.87	191.07	11646844.0
2016-02-04 14:00:00	SPY	ETF	191.08	191.17	190.36	191.12	13574449.0
2016-02-04 15:00:00	SPY	ETF	191.13	191.63	190.62	191.55	18982191.0
2016-02-04 16:00:00	SPY	ETF	191.56	191.61	190.95	191.13	6294174.0
2016-02-04 17:00:00	SPY	ETF	191.12	191.18	191.01	191.08	218148.0
2016-02-04 18:00:00	SPY	ETF	191.05	191.07	190.76	190.94	118512.0
2016-02-04 19:00:00	SPY	ETF	190.9	191.09	190.81	190.85	58157.0
2016-02-04 20:00:00	SPY	ETF	191.5132	191.5132	191.5132	191.5132	228000.0
2016-02-04 04:00:00	QQQ	ETF	101.97	102.33	101.88	102.33	3510.0
2016-02-04 05:00:00	QQQ	ETF	102.17	102.39	102.17	102.22	3200.0
2016-02-04 06:00:00	QQQ	ETF	102.21	102.26	102.01	102.01	5900.0
2016-02-04 07:00:00	QQQ	ETF	101.95	102.09	101.57	101.61	60259.0
2016-02-04 08:00:00	QQQ	ETF	101.57	101.75	100.82	101.06	309744.0
2016-02-04 09:00:00	QQQ	ETF	101.07	101.65	100.44	101.04	8690641.0
2016-02-04 10:00:00	QQQ	ETF	101.02	102.455	100.54	102.29	11049517.0
2016-02-04 11:00:00	QQQ	ETF	102.28	102.31	100.87	100.96	5854795.0
2016-02-04 12:00:00	QQQ	ETF	101.01	101.75	100.87	101.38	4130424.0
2016-02-04 13:00:00	QQQ	ETF	101.38	101.8879	101.1	101.25	3518796.0
2016-02-04 14:00:00	QQQ	ETF	101.26	101.32	100.735	101.3	4734751.0
2016-02-04 15:00:00	QQQ	ETF	101.319	101.71	100.955	101.64	5480422.0
2016-02-04 16:00:00	QQQ	ETF	101.65	101.68	101.27	101.29	555251.0
2016-02-04 17:00:00	QQQ	ETF	101.3	101.35	101.14	101.23	47280.0
2016-02-04 18:00:00	QQQ	ETF	101.19	101.23	101.09	101.22	25275.0
2016-02-04 19:00:00	QQQ	ETF	101.19	101.28	101.16	101.22	18744.0
2016-02-04 04:00:00	IWM	ETF	100.78	100.88	100.78	100.88	2000.0
2016-02-04 05:00:00	IWM	ETF	101.02	101.02	100.8	100.8	460.0
2016-02-04 06:00:00	IWM	ETF	100.75	100.75	100.55	100.55	1400.0
2016-02-04 07:00:00	IWM	ETF	100.55	100.65	100.0	100.1	27700.0
2016-02-04 08:00:00	IWM	ETF	100.05	100.41	99.38	99.6	308673.0
2016-02-04 09:00:00	IWM	ETF	99.7	101.06	99.7	100.97	8966265.0
2016-02-04 10:00:00	IWM	ETF	100.94	101.96	100.38	101.93	10223924.0
2016-02-04 11:00:00	IWM	ETF	101.92	101.97	100.42	100.62	6847607.0
2016-02-04 12:00:00	IWM	ETF	100.64	101.37	100.53	100.71	4694330.0
2016-02-04 13:00:00	IWM	ETF	100.71	101.1	100.19	100.43	4786292.0
2016-02-04 14:00:00	IWM	ETF	100.45	100.59	100.12	100.53	5005341.0
2016-02-04 15:00:00	IWM	ETF	100.52	100.96	100.27	100.81	6420638.0
2016-02-04 16:00:00	IWM	ETF	100.81	101.0781	100.48	100.51	605730.0
2016-02-04 17:00:00	IWM	ETF	100.47	100.5	100.47	100.5	1407.0
2016-02-04 18:00:00	IWM	ETF	100.41	100.44	100.26	100.4	19796.0
2016-02-04 07:00:00	DIA	ETF	163.7	163.7	163.7	163.7	200.0
2016-02-04 08:00:00	DIA	ETF	162.61	162.61	162.01	162.31	4300.0

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

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