PREVIEW / etf_1hour / 2016-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-09.parquet
  size:    252 KB
  rows:    8,050

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-09 04:00:00	SPY	ETF	218.0	218.05	217.95	217.99	1000.0
2016-08-09 05:00:00	SPY	ETF	217.99	218.05	217.99	218.04	740.0
2016-08-09 06:00:00	SPY	ETF	218.02	218.19	217.99	218.12	35515.0
2016-08-09 07:00:00	SPY	ETF	218.12	218.25	218.12	218.22	43410.0
2016-08-09 08:00:00	SPY	ETF	218.2	218.33	218.05	218.15	299722.0
2016-08-09 09:00:00	SPY	ETF	218.15	218.43	218.03	218.41	5173472.0
2016-08-09 10:00:00	SPY	ETF	218.41	218.66	218.17	218.55	7579414.0
2016-08-09 11:00:00	SPY	ETF	218.55	218.76	218.54	218.58	5593675.0
2016-08-09 12:00:00	SPY	ETF	218.589	218.68	218.175	218.235	5464048.0
2016-08-09 13:00:00	SPY	ETF	218.239	218.34	218.02	218.12	4853959.0
2016-08-09 14:00:00	SPY	ETF	218.12	218.16	217.8	218.03	6618001.0
2016-08-09 15:00:00	SPY	ETF	218.035	218.21	217.91	218.17	11111946.0
2016-08-09 16:00:00	SPY	ETF	218.17	218.26	218.0522	218.22	2290594.0
2016-08-09 17:00:00	SPY	ETF	218.21	218.23	218.18	218.2	82683.0
2016-08-09 18:00:00	SPY	ETF	218.22	218.22	218.02	218.06	120902.0
2016-08-09 19:00:00	SPY	ETF	218.06	218.1379	218.01	218.01	535483.0
2016-08-09 04:00:00	QQQ	ETF	116.64	116.69	116.63	116.63	500.0
2016-08-09 06:00:00	QQQ	ETF	116.64	116.73	116.64	116.73	2633.0
2016-08-09 07:00:00	QQQ	ETF	116.72	116.78	116.72	116.76	14192.0
2016-08-09 08:00:00	QQQ	ETF	116.78	116.83	116.71	116.76	37085.0
2016-08-09 09:00:00	QQQ	ETF	116.75	117.06	116.67	116.97	1406807.0
2016-08-09 10:00:00	QQQ	ETF	116.98	117.23	116.86	117.14	1452983.0
2016-08-09 11:00:00	QQQ	ETF	117.14	117.29	117.1274	117.181	1236458.0
2016-08-09 12:00:00	QQQ	ETF	117.18	117.26	116.91	116.965	1420021.0
2016-08-09 13:00:00	QQQ	ETF	116.97	117.06	116.868	116.95	1682799.0
2016-08-09 14:00:00	QQQ	ETF	116.9444	117.01	116.76	116.91	2330937.0
2016-08-09 15:00:00	QQQ	ETF	116.91	116.945	116.825	116.91	2407381.0
2016-08-09 16:00:00	QQQ	ETF	116.91	116.95	116.88	116.94	211933.0
2016-08-09 17:00:00	QQQ	ETF	116.92	116.95	116.87	116.92	3302.0
2016-08-09 18:00:00	QQQ	ETF	116.91	116.91	116.7	116.86	27275.0
2016-08-09 19:00:00	QQQ	ETF	116.82	116.82	116.79	116.79	1927.0
2016-08-09 07:00:00	IWM	ETF	122.36	122.36	122.34	122.34	2186.0
2016-08-09 08:00:00	IWM	ETF	122.37	122.41	122.18	122.24	34117.0
2016-08-09 09:00:00	IWM	ETF	122.28	122.51	122.17	122.3	1282219.0
2016-08-09 10:00:00	IWM	ETF	122.31	122.63	122.14	122.42	2807296.0
2016-08-09 11:00:00	IWM	ETF	122.42	122.57	122.4	122.51	1216556.0
2016-08-09 12:00:00	IWM	ETF	122.503	122.56	122.15	122.2734	835001.0
2016-08-09 13:00:00	IWM	ETF	122.28	122.45	122.25	122.35	989423.0
2016-08-09 14:00:00	IWM	ETF	122.345	122.41	122.2	122.39	1019679.0
2016-08-09 15:00:00	IWM	ETF	122.4	122.45	122.285	122.38	2453017.0
2016-08-09 16:00:00	IWM	ETF	122.37	122.41	122.33	122.38	385460.0
2016-08-09 17:00:00	IWM	ETF	122.35	122.35	122.35	122.35	800.0
2016-08-09 18:00:00	IWM	ETF	122.33	122.33	122.28	122.28	1850.0
2016-08-09 07:00:00	DIA	ETF	185.47	185.47	185.47	185.47	100.0
2016-08-09 08:00:00	DIA	ETF	185.5	185.55	185.5	185.5	5800.0
2016-08-09 09:00:00	DIA	ETF	185.42	185.7599	185.37	185.68	237451.0
2016-08-09 10:00:00	DIA	ETF	185.7	185.79	185.5	185.7001	447233.0
2016-08-09 11:00:00	DIA	ETF	185.7	185.86	185.69	185.715	248968.0
2016-08-09 12:00:00	DIA	ETF	185.72	185.81	185.35	185.41	232669.0
2016-08-09 13:00:00	DIA	ETF	185.41	185.47	185.23	185.31	132500.0

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

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