PREVIEW / etf_1hour / 2016-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-26.parquet
  size:    255 KB
  rows:    8,286

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-26 04:00:00	SPY	ETF	215.2	215.2	214.77	215.01	20809.0
2016-09-26 05:00:00	SPY	ETF	214.98	215.08	214.84	214.87	44422.0
2016-09-26 06:00:00	SPY	ETF	214.91	215.21	214.91	215.09	65274.0
2016-09-26 07:00:00	SPY	ETF	215.09	215.25	215.02	215.2	209041.0
2016-09-26 08:00:00	SPY	ETF	215.19	215.25	214.94	215.09	613684.0
2016-09-26 09:00:00	SPY	ETF	215.08	215.21	214.42	214.61	10109406.0
2016-09-26 10:00:00	SPY	ETF	214.6	215.23	214.47	214.9	10529587.0
2016-09-26 11:00:00	SPY	ETF	214.895	214.96	214.3	214.515	9239579.0
2016-09-26 12:00:00	SPY	ETF	214.51	214.82	214.41	214.66	5270970.0
2016-09-26 13:00:00	SPY	ETF	214.66	214.67	214.084	214.29	8311273.0
2016-09-26 14:00:00	SPY	ETF	214.29	214.49	214.1	214.21	7929338.0
2016-09-26 15:00:00	SPY	ETF	214.205	214.52	214.01	214.21	20910095.0
2016-09-26 16:00:00	SPY	ETF	214.21	214.56	214.1379	214.27	7441482.0
2016-09-26 17:00:00	SPY	ETF	214.26	214.28	214.19	214.2	1062648.0
2016-09-26 18:00:00	SPY	ETF	214.2	214.39	214.16	214.19	84609.0
2016-09-26 19:00:00	SPY	ETF	214.25	214.29	214.13	214.16	23864.0
2016-09-26 04:00:00	QQQ	ETF	117.82	117.82	117.47	117.53	52443.0
2016-09-26 05:00:00	QQQ	ETF	117.64	117.68	117.56	117.56	47498.0
2016-09-26 06:00:00	QQQ	ETF	117.64	117.72	117.64	117.67	27409.0
2016-09-26 07:00:00	QQQ	ETF	117.69	117.75	117.65	117.74	64120.0
2016-09-26 08:00:00	QQQ	ETF	117.73	117.75	117.63	117.67	27325.0
2016-09-26 09:00:00	QQQ	ETF	117.65	117.7	117.27	117.4	2592026.0
2016-09-26 10:00:00	QQQ	ETF	117.4	117.8	117.3	117.51	1716963.0
2016-09-26 11:00:00	QQQ	ETF	117.51	117.538	117.2	117.35	1960891.0
2016-09-26 12:00:00	QQQ	ETF	117.35	117.54	117.285	117.46	1419936.0
2016-09-26 13:00:00	QQQ	ETF	117.455	117.47	117.17	117.285	1418529.0
2016-09-26 14:00:00	QQQ	ETF	117.28	117.43	117.26	117.32	1563029.0
2016-09-26 15:00:00	QQQ	ETF	117.32	117.48	117.25	117.33	3708727.0
2016-09-26 16:00:00	QQQ	ETF	117.33	117.42	117.32	117.35	469248.0
2016-09-26 17:00:00	QQQ	ETF	117.4	117.4	117.35	117.35	1522.0
2016-09-26 18:00:00	QQQ	ETF	117.34	117.4	117.34	117.35	7244.0
2016-09-26 19:00:00	QQQ	ETF	117.33	117.34	117.28	117.28	4500.0
2016-09-26 04:00:00	IWM	ETF	123.84	123.87	123.61	123.71	16578.0
2016-09-26 05:00:00	IWM	ETF	123.7	123.7	123.7	123.7	200.0
2016-09-26 06:00:00	IWM	ETF	123.71	123.87	123.7	123.79	11500.0
2016-09-26 07:00:00	IWM	ETF	123.84	123.93	123.84	123.93	41030.0
2016-09-26 08:00:00	IWM	ETF	123.95	123.95	123.75	123.78	34607.0
2016-09-26 09:00:00	IWM	ETF	123.82	124.04	123.57	123.67	2728304.0
2016-09-26 10:00:00	IWM	ETF	123.67	124.17	123.57	124.01	2277959.0
2016-09-26 11:00:00	IWM	ETF	124.01	124.1	123.63	123.72	2119028.0
2016-09-26 12:00:00	IWM	ETF	123.72	123.92	123.65	123.801	1186970.0
2016-09-26 13:00:00	IWM	ETF	123.8	123.82	123.4	123.55	2019805.0
2016-09-26 14:00:00	IWM	ETF	123.55	123.69	123.42	123.49	1697948.0
2016-09-26 15:00:00	IWM	ETF	123.49	123.6	123.1	123.25	4226164.0
2016-09-26 16:00:00	IWM	ETF	123.23	123.75	123.11	123.23	1106330.0
2016-09-26 17:00:00	IWM	ETF	123.23	123.23	123.21	123.21	2992.0
2016-09-26 18:00:00	IWM	ETF	123.27	123.28	123.19	123.28	4170.0
2016-09-26 19:00:00	IWM	ETF	123.14	123.23	123.14	123.23	2265.0
2016-09-26 04:00:00	DIA	ETF	181.5	181.5	181.5	181.5	100.0
2016-09-26 05:00:00	DIA	ETF	181.5	181.5	181.5	181.5	100.0

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

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