PREVIEW / etf_1hour / 2017-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-23.parquet
  size:    276 KB
  rows:    8,827

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-01-23 04:00:00	SPY	ETF	226.28	226.35	226.08	226.31	19376.0
2017-01-23 05:00:00	SPY	ETF	226.33	226.34	226.25	226.26	6106.0
2017-01-23 06:00:00	SPY	ETF	226.24	226.41	226.23	226.23	63109.0
2017-01-23 07:00:00	SPY	ETF	226.25	226.33	226.13	226.2	104174.0
2017-01-23 08:00:00	SPY	ETF	226.2	226.41	226.15	226.33	393036.0
2017-01-23 09:00:00	SPY	ETF	226.33	226.805	226.21	226.38	7110047.0
2017-01-23 10:00:00	SPY	ETF	226.38	226.49	225.6	225.75	10453577.0
2017-01-23 11:00:00	SPY	ETF	225.75	225.93	225.27	225.53	9075343.0
2017-01-23 12:00:00	SPY	ETF	225.53	225.82	225.32	225.74	6989358.0
2017-01-23 13:00:00	SPY	ETF	225.73	226.24	225.7	225.88	9912257.0
2017-01-23 14:00:00	SPY	ETF	225.87	226.7311	225.695	226.02	8239754.0
2017-01-23 15:00:00	SPY	ETF	226.025	226.33	225.85	226.18	12611398.0
2017-01-23 16:00:00	SPY	ETF	226.18	226.29	216.15	226.2	8429994.0
2017-01-23 17:00:00	SPY	ETF	226.19	226.22	226.15	226.15	798413.0
2017-01-23 18:00:00	SPY	ETF	226.15	226.25	226.13	226.22	66436.0
2017-01-23 19:00:00	SPY	ETF	226.2	226.28	226.19	226.24	60468.0
2017-01-23 04:00:00	QQQ	ETF	122.96	122.96	122.82	122.82	2873.0
2017-01-23 05:00:00	QQQ	ETF	122.99	122.99	122.96	122.96	2577.0
2017-01-23 06:00:00	QQQ	ETF	123.0	123.01	122.96	123.0	1580.0
2017-01-23 07:00:00	QQQ	ETF	122.99	123.05	122.94	122.98	81395.0
2017-01-23 08:00:00	QQQ	ETF	122.99	123.08	122.98	123.08	48826.0
2017-01-23 09:00:00	QQQ	ETF	123.06	123.53	123.04	123.18	2447363.0
2017-01-23 10:00:00	QQQ	ETF	123.1741	123.27	122.76	122.8359	2525728.0
2017-01-23 11:00:00	QQQ	ETF	122.83	122.97	122.57	122.8027	3181190.0
2017-01-23 12:00:00	QQQ	ETF	122.8	123.09	122.73	123.045	1618209.0
2017-01-23 13:00:00	QQQ	ETF	123.05	123.37	123.03	123.19	1785961.0
2017-01-23 14:00:00	QQQ	ETF	123.18	123.28	123.06	123.25	1002306.0
2017-01-23 15:00:00	QQQ	ETF	123.25	123.431	123.1835	123.34	2793659.0
2017-01-23 16:00:00	QQQ	ETF	123.34	123.44	123.31	123.4	735333.0
2017-01-23 17:00:00	QQQ	ETF	123.38	123.41	123.35	123.37	17461.0
2017-01-23 18:00:00	QQQ	ETF	123.36	123.41	123.35	123.41	21897.0
2017-01-23 19:00:00	QQQ	ETF	123.42	123.44	123.4	123.41	6899.0
2017-01-23 04:00:00	IWM	ETF	133.74	134.05	133.7	134.02	6640.0
2017-01-23 06:00:00	IWM	ETF	134.09	134.09	133.97	133.98	7239.0
2017-01-23 07:00:00	IWM	ETF	133.94	133.96	133.87	133.88	26650.0
2017-01-23 08:00:00	IWM	ETF	133.9	134.05	133.84	134.01	74387.0
2017-01-23 09:00:00	IWM	ETF	133.97	134.68	133.87	134.22	2588815.0
2017-01-23 10:00:00	IWM	ETF	134.215	134.35	133.46	133.54	3415059.0
2017-01-23 11:00:00	IWM	ETF	133.54	133.725	133.12	133.29	2504993.0
2017-01-23 12:00:00	IWM	ETF	133.31	133.49	133.1675	133.44	2174274.0
2017-01-23 13:00:00	IWM	ETF	133.44	133.89	133.42	133.64	1539968.0
2017-01-23 14:00:00	IWM	ETF	133.64	133.81	133.465	133.78	1392347.0
2017-01-23 15:00:00	IWM	ETF	133.78	134.07	133.67	133.89	3364484.0
2017-01-23 16:00:00	IWM	ETF	133.88	133.96	133.86	133.93	1035202.0
2017-01-23 17:00:00	IWM	ETF	133.88	133.92	133.88	133.92	1670.0
2017-01-23 18:00:00	IWM	ETF	133.9	133.92	133.9	133.92	3144.0
2017-01-23 19:00:00	IWM	ETF	133.92	133.98	133.92	133.98	2826.0
2017-01-23 04:00:00	DIA	ETF	197.87	197.87	197.77	197.77	300.0
2017-01-23 07:00:00	DIA	ETF	197.86	197.86	197.73	197.73	500.0
2017-01-23 08:00:00	DIA	ETF	197.67	197.71	197.6	197.71	1600.0

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

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