PREVIEW / etf_1hour / 2017-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-20.parquet
  size:    283 KB
  rows:    9,246

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-20 04:00:00	SPY	ETF	244.54	244.54	244.45	244.45	510.0
2017-06-20 05:00:00	SPY	ETF	244.44	244.47	244.4	244.4	14100.0
2017-06-20 06:00:00	SPY	ETF	244.4	244.47	244.36	244.41	61797.0
2017-06-20 07:00:00	SPY	ETF	244.42	244.47	244.34	244.4	199544.0
2017-06-20 08:00:00	SPY	ETF	244.42	244.42	244.1	244.15	322737.0
2017-06-20 09:00:00	SPY	ETF	244.16	244.3	243.84	243.84	4641036.0
2017-06-20 10:00:00	SPY	ETF	243.85	244.14	243.75	244.0699	6138124.0
2017-06-20 11:00:00	SPY	ETF	244.06	244.08	243.71	243.7351	5369276.0
2017-06-20 12:00:00	SPY	ETF	243.74	243.85	243.35	243.775	6007646.0
2017-06-20 13:00:00	SPY	ETF	243.775	243.85	243.63	243.705	3835287.0
2017-06-20 14:00:00	SPY	ETF	243.705	243.8	243.35	243.51	5887490.0
2017-06-20 15:00:00	SPY	ETF	243.515	243.72	242.99	243.04	13770568.0
2017-06-20 16:00:00	SPY	ETF	243.04	243.7292	243.01	243.22	7450293.0
2017-06-20 17:00:00	SPY	ETF	243.22	243.5	243.01	243.16	541973.0
2017-06-20 18:00:00	SPY	ETF	243.18	243.26	243.04	243.18	361897.0
2017-06-20 19:00:00	SPY	ETF	243.19	243.24	243.18	243.24	16723.0
2017-06-20 04:00:00	QQQ	ETF	140.57	140.57	140.44	140.44	12886.0
2017-06-20 05:00:00	QQQ	ETF	140.49	140.49	140.41	140.41	7998.0
2017-06-20 06:00:00	QQQ	ETF	140.43	140.51	140.39	140.51	11400.0
2017-06-20 07:00:00	QQQ	ETF	140.52	140.58	140.5	140.58	36565.0
2017-06-20 08:00:00	QQQ	ETF	140.47	140.55	140.12	140.15	147038.0
2017-06-20 09:00:00	QQQ	ETF	140.19	140.4	140.0	140.08	3387502.0
2017-06-20 10:00:00	QQQ	ETF	140.09	140.5	139.87	140.41	3787665.0
2017-06-20 11:00:00	QQQ	ETF	140.42	140.435	139.74	139.91	3293020.0
2017-06-20 12:00:00	QQQ	ETF	139.93	140.08	139.55	139.84	3733360.0
2017-06-20 13:00:00	QQQ	ETF	139.83	140.01	139.79	139.91	1777333.0
2017-06-20 14:00:00	QQQ	ETF	139.91	140.0	139.55	139.811	2051270.0
2017-06-20 15:00:00	QQQ	ETF	139.82	140.0	139.31	139.36	5999195.0
2017-06-20 16:00:00	QQQ	ETF	139.36	139.7272	139.33	139.37	1609282.0
2017-06-20 17:00:00	QQQ	ETF	139.42	139.42	139.36	139.38	538514.0
2017-06-20 18:00:00	QQQ	ETF	139.37	139.43	139.29	139.41	47936.0
2017-06-20 19:00:00	QQQ	ETF	139.37	139.4	139.33	139.4	12428.0
2017-06-20 04:00:00	IWM	ETF	141.23	141.23	141.23	141.23	500.0
2017-06-20 05:00:00	IWM	ETF	141.26	141.26	141.19	141.19	300.0
2017-06-20 06:00:00	IWM	ETF	141.15	141.22	141.15	141.15	2300.0
2017-06-20 07:00:00	IWM	ETF	141.15	141.21	141.07	141.21	18200.0
2017-06-20 08:00:00	IWM	ETF	141.12	141.12	140.79	140.82	151658.0
2017-06-20 09:00:00	IWM	ETF	140.83	141.03	140.43	140.46	1755901.0
2017-06-20 10:00:00	IWM	ETF	140.44	140.65	140.06	140.59	3356145.0
2017-06-20 11:00:00	IWM	ETF	140.59	140.59	140.1	140.28	1836864.0
2017-06-20 12:00:00	IWM	ETF	140.28	140.34	139.78	140.095	2207384.0
2017-06-20 13:00:00	IWM	ETF	140.09	140.3345	140.06	140.2	1468893.0
2017-06-20 14:00:00	IWM	ETF	140.2	140.31	139.91	139.91	1729893.0
2017-06-20 15:00:00	IWM	ETF	139.92	140.05	139.7	139.78	4591152.0
2017-06-20 16:00:00	IWM	ETF	139.78	139.92	139.7533	139.86	785174.0
2017-06-20 17:00:00	IWM	ETF	139.83	139.87	139.78	139.8	48828.0
2017-06-20 18:00:00	IWM	ETF	139.77	139.8	139.77	139.8	4636.0
2017-06-20 19:00:00	IWM	ETF	139.8	139.88	139.76	139.8	5629.0
2017-06-20 07:00:00	DIA	ETF	215.04	215.04	214.87	214.87	400.0
2017-06-20 08:00:00	DIA	ETF	214.83	215.07	214.7	214.75	3988.0

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

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