PREVIEW / etf_1hour / 2016-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-16.parquet
  size:    249 KB
  rows:    8,044

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-09-16 04:00:00	SPY	ETF	213.74	213.74	213.21	213.39	47785.0
2016-09-16 05:00:00	SPY	ETF	213.43	213.62	213.39	213.56	6272.0
2016-09-16 06:00:00	SPY	ETF	213.43	213.47	212.91	213.17	268796.0
2016-09-16 07:00:00	SPY	ETF	213.15	213.27	213.0	213.15	470602.0
2016-09-16 08:00:00	SPY	ETF	213.15	214.1979	213.06	213.72	2320841.0
2016-09-16 09:00:00	SPY	ETF	213.75	213.93	212.97	213.23	19838919.0
2016-09-16 10:00:00	SPY	ETF	213.22	213.52	212.61	213.04	38215571.0
2016-09-16 11:00:00	SPY	ETF	213.03	213.39	212.84	213.2	15502003.0
2016-09-16 12:00:00	SPY	ETF	213.2	213.46	213.09	213.09	10853806.0
2016-09-16 13:00:00	SPY	ETF	213.08	213.23	212.57	212.79	12063712.0
2016-09-16 14:00:00	SPY	ETF	212.78	213.37	212.64	213.03	19198763.0
2016-09-16 15:00:00	SPY	ETF	213.03	213.69	212.99	213.34	23553720.0
2016-09-16 16:00:00	SPY	ETF	213.34	213.59	213.3	213.5	8718514.0
2016-09-16 17:00:00	SPY	ETF	213.51	213.6	213.37	213.57	384737.0
2016-09-16 18:00:00	SPY	ETF	213.57	213.57	213.37	213.53	44855.0
2016-09-16 19:00:00	SPY	ETF	213.51	213.59	213.5	213.57	22772.0
2016-09-16 04:00:00	QQQ	ETF	117.03	117.03	116.98	116.99	6400.0
2016-09-16 05:00:00	QQQ	ETF	117.1	117.1	117.08	117.09	4496.0
2016-09-16 06:00:00	QQQ	ETF	117.02	117.05	116.8	116.87	38677.0
2016-09-16 07:00:00	QQQ	ETF	116.94	116.99	116.87	116.9	49077.0
2016-09-16 08:00:00	QQQ	ETF	116.9	117.15	116.84	117.13	213383.0
2016-09-16 09:00:00	QQQ	ETF	117.15	117.44	116.94	117.0499	4695736.0
2016-09-16 10:00:00	QQQ	ETF	117.05	117.3	116.71	117.0	3674149.0
2016-09-16 11:00:00	QQQ	ETF	117.0001	117.185	116.85	117.065	1797860.0
2016-09-16 12:00:00	QQQ	ETF	117.07	117.289	117.02	117.05	1194231.0
2016-09-16 13:00:00	QQQ	ETF	117.04	117.14	116.78	116.9093	1836976.0
2016-09-16 14:00:00	QQQ	ETF	116.89	117.23	116.81	117.06	1582696.0
2016-09-16 15:00:00	QQQ	ETF	117.05	117.412	117.03	117.3	4293923.0
2016-09-16 16:00:00	QQQ	ETF	117.29	117.36	117.26	117.35	1108078.0
2016-09-16 17:00:00	QQQ	ETF	117.34	117.36	117.34	117.36	4374.0
2016-09-16 18:00:00	QQQ	ETF	117.31	117.35	117.31	117.35	250.0
2016-09-16 19:00:00	QQQ	ETF	117.35	117.39	117.31	117.39	3514.0
2016-09-16 04:00:00	IWM	ETF	121.54	121.54	121.54	121.54	130.0
2016-09-16 06:00:00	IWM	ETF	121.3	121.35	121.3	121.31	7200.0
2016-09-16 07:00:00	IWM	ETF	121.32	121.42	121.25	121.29	122789.0
2016-09-16 08:00:00	IWM	ETF	121.39	121.68	121.36	121.47	151416.0
2016-09-16 09:00:00	IWM	ETF	121.58	121.75	121.255	121.47	4243850.0
2016-09-16 10:00:00	IWM	ETF	121.46	121.82	121.095	121.55	4412282.0
2016-09-16 11:00:00	IWM	ETF	121.56	121.86	121.44	121.75	1727641.0
2016-09-16 12:00:00	IWM	ETF	121.75	121.97	121.65	121.71	2653986.0
2016-09-16 13:00:00	IWM	ETF	121.71	121.88	121.375	121.625	2082170.0
2016-09-16 14:00:00	IWM	ETF	121.62	121.7625	121.45	121.62	2037102.0
2016-09-16 15:00:00	IWM	ETF	121.605	121.965	121.59	121.84	6172028.0
2016-09-16 16:00:00	IWM	ETF	121.86	121.96	121.77	121.83	1808198.0
2016-09-16 17:00:00	IWM	ETF	121.8	122.0	121.75	122.0	1260062.0
2016-09-16 18:00:00	IWM	ETF	122.0	122.1	121.91	121.91	12158.0
2016-09-16 19:00:00	IWM	ETF	121.92	122.0	121.92	122.0	284.0
2016-09-16 06:00:00	DIA	ETF	181.15	181.15	181.0	181.12	16064.0
2016-09-16 07:00:00	DIA	ETF	181.12	181.12	181.12	181.12	200.0
2016-09-16 08:00:00	DIA	ETF	181.35	181.51	181.3	181.5	4893.0

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

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