PREVIEW / etf_1hour / 2016-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-19.parquet
  size:    248 KB
  rows:    7,984

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-08-19 04:00:00	SPY	ETF	218.43	218.43	218.0	218.06	24330.0
2016-08-19 05:00:00	SPY	ETF	218.05	218.23	218.05	218.18	4304.0
2016-08-19 06:00:00	SPY	ETF	218.23	218.37	218.17	218.17	19986.0
2016-08-19 07:00:00	SPY	ETF	218.16	218.27	218.08	218.11	111342.0
2016-08-19 08:00:00	SPY	ETF	218.11	218.3	218.03	218.29	867974.0
2016-08-19 09:00:00	SPY	ETF	218.27	218.38	217.74	217.86	11722379.0
2016-08-19 10:00:00	SPY	ETF	217.855	218.58	217.84	218.39	14080569.0
2016-08-19 11:00:00	SPY	ETF	218.38	218.5409	218.31	218.5	4084012.0
2016-08-19 12:00:00	SPY	ETF	218.51	218.5925	218.055	218.122	5647710.0
2016-08-19 13:00:00	SPY	ETF	218.12	218.42	218.08	218.315	8222439.0
2016-08-19 14:00:00	SPY	ETF	218.32	218.685	218.31	218.61	6566207.0
2016-08-19 15:00:00	SPY	ETF	218.61	218.75	218.53	218.57	16331371.0
2016-08-19 16:00:00	SPY	ETF	218.57	218.67	218.53	218.66	4532587.0
2016-08-19 17:00:00	SPY	ETF	218.66	218.75	218.54	218.67	865203.0
2016-08-19 18:00:00	SPY	ETF	218.68	218.7	218.62	218.7	16107.0
2016-08-19 19:00:00	SPY	ETF	218.69	218.77	218.69	218.76	21024.0
2016-08-19 04:00:00	QQQ	ETF	117.12	117.12	116.88	116.88	12000.0
2016-08-19 05:00:00	QQQ	ETF	116.97	117.0	116.97	117.0	400.0
2016-08-19 06:00:00	QQQ	ETF	117.0	117.03	117.0	117.03	7200.0
2016-08-19 07:00:00	QQQ	ETF	117.02	117.02	116.94	116.95	12789.0
2016-08-19 08:00:00	QQQ	ETF	116.95	117.09	116.92	117.07	109149.0
2016-08-19 09:00:00	QQQ	ETF	117.05	117.13	116.76	116.92	2958506.0
2016-08-19 10:00:00	QQQ	ETF	116.92	117.52	116.8462	117.38	2809722.0
2016-08-19 11:00:00	QQQ	ETF	117.38	117.51	117.33	117.45	1146259.0
2016-08-19 12:00:00	QQQ	ETF	117.4472	117.49	116.99	117.045	1512606.0
2016-08-19 13:00:00	QQQ	ETF	117.04	117.125	116.95	117.08	1195760.0
2016-08-19 14:00:00	QQQ	ETF	117.07	117.28	117.06	117.2425	1156952.0
2016-08-19 15:00:00	QQQ	ETF	117.25	117.335	117.205	117.25	2810775.0
2016-08-19 16:00:00	QQQ	ETF	117.27	117.34	117.25	117.33	1247020.0
2016-08-19 17:00:00	QQQ	ETF	117.3	117.33	117.25	117.28	258387.0
2016-08-19 18:00:00	QQQ	ETF	117.28	117.29	117.27	117.29	8700.0
2016-08-19 19:00:00	QQQ	ETF	117.29	117.3	117.27	117.3	7672.0
2016-08-19 04:00:00	IWM	ETF	122.42	122.42	122.38	122.38	5000.0
2016-08-19 05:00:00	IWM	ETF	122.47	122.55	122.47	122.55	10200.0
2016-08-19 06:00:00	IWM	ETF	122.5	122.5	122.48	122.48	4000.0
2016-08-19 07:00:00	IWM	ETF	122.5	122.62	122.48	122.51	30756.0
2016-08-19 08:00:00	IWM	ETF	122.52	122.67	122.49	122.66	72023.0
2016-08-19 09:00:00	IWM	ETF	122.63	122.79	122.28	122.49	2227145.0
2016-08-19 10:00:00	IWM	ETF	122.5	123.07	122.49	122.798	2058548.0
2016-08-19 11:00:00	IWM	ETF	122.79	123.03	122.63	122.92	944937.0
2016-08-19 12:00:00	IWM	ETF	122.92	122.95	122.43	122.52	1239841.0
2016-08-19 13:00:00	IWM	ETF	122.51	122.78	122.48	122.75	1026992.0
2016-08-19 14:00:00	IWM	ETF	122.75	122.96	122.71	122.95	1163395.0
2016-08-19 15:00:00	IWM	ETF	122.95	123.02	122.82	122.93	3624464.0
2016-08-19 16:00:00	IWM	ETF	122.91	122.98	122.8	122.82	493192.0
2016-08-19 17:00:00	IWM	ETF	122.82	122.87	122.82	122.82	462885.0
2016-08-19 04:00:00	DIA	ETF	185.79	185.79	185.14	185.14	11500.0
2016-08-19 06:00:00	DIA	ETF	185.08	185.08	185.08	185.08	208.0
2016-08-19 07:00:00	DIA	ETF	185.14	185.14	185.1	185.1	3800.0
2016-08-19 08:00:00	DIA	ETF	185.15	185.2	185.1	185.2	2600.0

> showing 50 of 7,984 rows — these rows as CSV

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