PREVIEW / etf_1hour / 2017-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-28.parquet
  size:    278 KB
  rows:    9,049

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-06-28 04:00:00	SPY	ETF	241.32	241.48	241.15	241.45	24300.0
2017-06-28 05:00:00	SPY	ETF	241.48	241.84	241.48	241.82	34838.0
2017-06-28 06:00:00	SPY	ETF	241.87	242.04	241.87	241.9	67588.0
2017-06-28 07:00:00	SPY	ETF	241.9	242.1	241.83	242.05	451111.0
2017-06-28 08:00:00	SPY	ETF	242.05	242.57	241.95	242.35	1266948.0
2017-06-28 09:00:00	SPY	ETF	242.35	242.7	242.23	242.335	7033325.0
2017-06-28 10:00:00	SPY	ETF	242.33	243.29	242.305	243.125	12403765.0
2017-06-28 11:00:00	SPY	ETF	243.125	243.48	243.05	243.3	6952175.0
2017-06-28 12:00:00	SPY	ETF	243.3	243.56	243.23	243.5	5510343.0
2017-06-28 13:00:00	SPY	ETF	243.51	243.71	243.44	243.59	4514662.0
2017-06-28 14:00:00	SPY	ETF	243.59	243.65	243.35	243.49	6056491.0
2017-06-28 15:00:00	SPY	ETF	243.49	243.715	243.33	243.46	15110808.0
2017-06-28 16:00:00	SPY	ETF	243.47	243.88	243.2366	243.86	8558089.0
2017-06-28 17:00:00	SPY	ETF	243.79	243.89	243.79	243.82	151739.0
2017-06-28 18:00:00	SPY	ETF	243.82	244.04	243.79	243.93	93460.0
2017-06-28 19:00:00	SPY	ETF	243.97	243.98	243.88	243.98	40213.0
2017-06-28 04:00:00	QQQ	ETF	137.65	137.65	137.07	137.3	44276.0
2017-06-28 05:00:00	QQQ	ETF	137.34	138.0	137.3	137.85	47559.0
2017-06-28 06:00:00	QQQ	ETF	137.83	137.85	137.56	137.56	19505.0
2017-06-28 07:00:00	QQQ	ETF	137.6	137.99	137.53	137.99	152474.0
2017-06-28 08:00:00	QQQ	ETF	137.7	138.62	137.7	138.42	875714.0
2017-06-28 09:00:00	QQQ	ETF	138.42	138.64	137.74	137.86	8335007.0
2017-06-28 10:00:00	QQQ	ETF	137.85	139.33	137.81	139.18	11689707.0
2017-06-28 11:00:00	QQQ	ETF	139.17	139.3	138.9	139.09	4377750.0
2017-06-28 12:00:00	QQQ	ETF	139.09	139.71	139.06	139.63	4913737.0
2017-06-28 13:00:00	QQQ	ETF	139.62	139.9011	139.57	139.72	4745426.0
2017-06-28 14:00:00	QQQ	ETF	139.73	139.82	139.54	139.8	4214913.0
2017-06-28 15:00:00	QQQ	ETF	139.8	140.14	139.78	140.01	8384822.0
2017-06-28 16:00:00	QQQ	ETF	140.01	140.85	138.2842	140.27	2030385.0
2017-06-28 17:00:00	QQQ	ETF	141.0	141.0	140.15	140.15	55440.0
2017-06-28 18:00:00	QQQ	ETF	140.19	140.47	140.19	140.32	43726.0
2017-06-28 19:00:00	QQQ	ETF	140.32	140.37	140.31	140.35	11750.0
2017-06-28 04:00:00	IWM	ETF	139.8	139.8	139.8	139.8	100.0
2017-06-28 05:00:00	IWM	ETF	140.07	140.35	140.07	140.33	11300.0
2017-06-28 06:00:00	IWM	ETF	140.3	140.3	140.3	140.3	2000.0
2017-06-28 07:00:00	IWM	ETF	140.3	140.57	140.3	140.57	28693.0
2017-06-28 08:00:00	IWM	ETF	140.5	140.83	140.42	140.66	215655.0
2017-06-28 09:00:00	IWM	ETF	140.69	140.9	140.4	140.6	2122553.0
2017-06-28 10:00:00	IWM	ETF	140.59	141.8	140.5699	141.745	5196011.0
2017-06-28 11:00:00	IWM	ETF	141.75	142.19	141.73	142.0301	3828047.0
2017-06-28 12:00:00	IWM	ETF	142.03	142.25	141.95	142.13	2105173.0
2017-06-28 13:00:00	IWM	ETF	142.149	142.26	141.98	142.04	1763449.0
2017-06-28 14:00:00	IWM	ETF	142.04	142.2	141.96	142.0337	1354976.0
2017-06-28 15:00:00	IWM	ETF	142.03	142.19	141.79	142.01	3683658.0
2017-06-28 16:00:00	IWM	ETF	142.0	142.54	141.95	142.51	1231483.0
2017-06-28 17:00:00	IWM	ETF	142.54	142.56	139.8827	142.56	224753.0
2017-06-28 18:00:00	IWM	ETF	142.51	142.55	141.98	142.41	5803.0
2017-06-28 19:00:00	IWM	ETF	142.41	142.5	142.41	142.49	3250.0
2017-06-28 04:00:00	DIA	ETF	213.0	213.0	212.94	212.94	300.0
2017-06-28 08:00:00	DIA	ETF	213.5	213.51	213.34	213.51	210300.0

> showing 50 of 9,049 rows — these rows as CSV

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