PREVIEW / etf_1hour / 2017-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-27.parquet
  size:    275 KB
  rows:    8,919

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-27 04:00:00	SPY	ETF	236.8	237.12	236.7	236.7	3461.0
2017-02-27 05:00:00	SPY	ETF	236.77	236.77	236.65	236.65	9829.0
2017-02-27 06:00:00	SPY	ETF	236.7	236.8	236.62	236.8	13631.0
2017-02-27 07:00:00	SPY	ETF	236.74	236.76	236.57	236.64	161176.0
2017-02-27 08:00:00	SPY	ETF	236.61	236.77	236.44	236.63	431588.0
2017-02-27 09:00:00	SPY	ETF	236.63	236.85	236.35	236.849	6295130.0
2017-02-27 10:00:00	SPY	ETF	236.84	237.09	236.46	236.84	8752422.0
2017-02-27 11:00:00	SPY	ETF	236.84	237.03	236.67	236.68	5478861.0
2017-02-27 12:00:00	SPY	ETF	236.68	236.9	236.62	236.73	4369975.0
2017-02-27 13:00:00	SPY	ETF	236.735	237.07	236.73	237.01	5304771.0
2017-02-27 14:00:00	SPY	ETF	237.02	237.2	236.93	237.12	4581651.0
2017-02-27 15:00:00	SPY	ETF	237.12	237.31	237.04	237.13	11581295.0
2017-02-27 16:00:00	SPY	ETF	237.13	237.135	236.74	236.79	7950772.0
2017-02-27 17:00:00	SPY	ETF	236.79	236.87	236.75	236.81	114076.0
2017-02-27 18:00:00	SPY	ETF	236.82	236.9	236.81	236.82	19913.0
2017-02-27 19:00:00	SPY	ETF	236.82	236.93	236.79	236.87	25760.0
2017-02-27 04:00:00	QQQ	ETF	130.28	130.3	130.19	130.19	6162.0
2017-02-27 05:00:00	QQQ	ETF	130.14	130.14	130.08	130.1	1501.0
2017-02-27 06:00:00	QQQ	ETF	130.1	130.21	130.1	130.2	27096.0
2017-02-27 07:00:00	QQQ	ETF	130.17	130.17	130.04	130.06	45466.0
2017-02-27 08:00:00	QQQ	ETF	130.06	130.07	129.98	129.99	182097.0
2017-02-27 09:00:00	QQQ	ETF	130.05	130.11	129.8	130.11	1760983.0
2017-02-27 10:00:00	QQQ	ETF	130.101	130.1757	129.88	130.09	2049297.0
2017-02-27 11:00:00	QQQ	ETF	130.09	130.26	130.09	130.1035	1265135.0
2017-02-27 12:00:00	QQQ	ETF	130.1	130.18	130.07	130.08	939130.0
2017-02-27 13:00:00	QQQ	ETF	130.09	130.27	130.0782	130.255	1022029.0
2017-02-27 14:00:00	QQQ	ETF	130.251	130.33	130.2	130.29	893410.0
2017-02-27 15:00:00	QQQ	ETF	130.2868	130.43	130.28	130.43	2645917.0
2017-02-27 16:00:00	QQQ	ETF	130.42	130.43	130.26	130.26	343927.0
2017-02-27 17:00:00	QQQ	ETF	130.32	130.32	130.28	130.31	3875.0
2017-02-27 18:00:00	QQQ	ETF	130.34	130.34	130.31	130.31	4211.0
2017-02-27 19:00:00	QQQ	ETF	130.33	130.34	130.33	130.34	800.0
2017-02-27 04:00:00	IWM	ETF	138.59	138.59	138.55	138.55	750.0
2017-02-27 06:00:00	IWM	ETF	138.53	138.53	138.53	138.53	300.0
2017-02-27 07:00:00	IWM	ETF	138.58	138.59	138.49	138.49	12000.0
2017-02-27 08:00:00	IWM	ETF	138.49	138.5	138.29	138.43	151255.0
2017-02-27 09:00:00	IWM	ETF	138.5	139.34	138.21	139.275	3501907.0
2017-02-27 10:00:00	IWM	ETF	139.28	139.8	139.035	139.45	4913796.0
2017-02-27 11:00:00	IWM	ETF	139.46	139.6399	139.07	139.14	2156428.0
2017-02-27 12:00:00	IWM	ETF	139.14	139.51	139.11	139.46	1351328.0
2017-02-27 13:00:00	IWM	ETF	139.45	139.68	139.39	139.56	1172987.0
2017-02-27 14:00:00	IWM	ETF	139.56	139.87	139.55	139.83	1976797.0
2017-02-27 15:00:00	IWM	ETF	139.83	139.98	139.63	139.97	5921307.0
2017-02-27 16:00:00	IWM	ETF	139.97	140.0	139.59	139.59	823715.0
2017-02-27 17:00:00	IWM	ETF	139.63	139.68	139.56	139.66	3015.0
2017-02-27 18:00:00	IWM	ETF	139.73	139.74	139.72	139.72	2000.0
2017-02-27 19:00:00	IWM	ETF	139.7	139.74	139.7	139.74	3067.0
2017-02-27 06:00:00	DIA	ETF	207.88	207.88	207.88	207.88	500.0
2017-02-27 08:00:00	DIA	ETF	207.67	207.7	207.62	207.7	1570.0
2017-02-27 09:00:00	DIA	ETF	207.72	207.97	207.61	207.97	346217.0

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

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