PREVIEW / etf_1hour / 2016-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-13.parquet
  size:    257 KB
  rows:    8,179

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-07-13 04:00:00	SPY	ETF	214.75	215.0	214.75	214.99	17838.0
2016-07-13 05:00:00	SPY	ETF	214.95	215.16	214.95	215.15	14273.0
2016-07-13 06:00:00	SPY	ETF	215.1	215.27	215.08	215.21	30533.0
2016-07-13 07:00:00	SPY	ETF	215.16	215.16	215.0	215.12	104577.0
2016-07-13 08:00:00	SPY	ETF	215.12	215.61	214.594	215.55	790344.0
2016-07-13 09:00:00	SPY	ETF	215.53	215.57	214.75	214.87	10947168.0
2016-07-13 10:00:00	SPY	ETF	214.87	215.18	214.77	215.08	12788191.0
2016-07-13 11:00:00	SPY	ETF	215.0789	215.17	214.35	214.56	12127892.0
2016-07-13 12:00:00	SPY	ETF	214.56	214.77	214.52	214.75	12093250.0
2016-07-13 13:00:00	SPY	ETF	214.75	214.95	214.6	214.7	7690507.0
2016-07-13 14:00:00	SPY	ETF	214.7	215.13	214.6	215.02	8643711.0
2016-07-13 15:00:00	SPY	ETF	215.02	215.16	214.84	214.92	14083254.0
2016-07-13 16:00:00	SPY	ETF	214.91	215.02	214.9	214.94	6477671.0
2016-07-13 17:00:00	SPY	ETF	214.96	215.0	214.91	214.92	293959.0
2016-07-13 18:00:00	SPY	ETF	214.91	214.91	214.72	214.76	86811.0
2016-07-13 19:00:00	SPY	ETF	214.81	214.85	214.77	214.8	34954.0
2016-07-13 04:00:00	QQQ	ETF	111.5	111.51	111.5	111.51	3000.0
2016-07-13 05:00:00	QQQ	ETF	111.51	111.64	111.51	111.62	5900.0
2016-07-13 06:00:00	QQQ	ETF	111.62	111.72	111.62	111.72	2805.0
2016-07-13 07:00:00	QQQ	ETF	111.64	111.66	111.59	111.64	13140.0
2016-07-13 08:00:00	QQQ	ETF	111.64	111.84	111.62	111.83	281576.0
2016-07-13 09:00:00	QQQ	ETF	111.81	111.83	111.41	111.59	2770089.0
2016-07-13 10:00:00	QQQ	ETF	111.6	111.82	111.52	111.75	1963950.0
2016-07-13 11:00:00	QQQ	ETF	111.74	111.79	111.22	111.38	3221974.0
2016-07-13 12:00:00	QQQ	ETF	111.375	111.47	111.31	111.439	1549452.0
2016-07-13 13:00:00	QQQ	ETF	111.43	111.55	111.34	111.37	1497475.0
2016-07-13 14:00:00	QQQ	ETF	111.37	111.56	111.31	111.42	1538326.0
2016-07-13 15:00:00	QQQ	ETF	111.42	111.5368	111.23	111.23	2776373.0
2016-07-13 16:00:00	QQQ	ETF	111.23	111.3	111.21	111.26	488973.0
2016-07-13 17:00:00	QQQ	ETF	111.27	111.27	111.2	111.26	2012.0
2016-07-13 18:00:00	QQQ	ETF	111.26	111.26	111.09	111.14	67107.0
2016-07-13 19:00:00	QQQ	ETF	111.14	111.15	111.11	111.11	31499.0
2016-07-13 05:00:00	IWM	ETF	119.93	119.98	119.93	119.98	900.0
2016-07-13 06:00:00	IWM	ETF	120.0	120.1	120.0	120.1	250.0
2016-07-13 07:00:00	IWM	ETF	120.1	120.1	120.01	120.01	15400.0
2016-07-13 08:00:00	IWM	ETF	120.07	120.28	120.07	120.25	59845.0
2016-07-13 09:00:00	IWM	ETF	120.23	120.39	119.54	119.74	4290694.0
2016-07-13 10:00:00	IWM	ETF	119.74	120.27	119.655	119.67	4896311.0
2016-07-13 11:00:00	IWM	ETF	119.68	119.78	118.95	119.24	4329997.0
2016-07-13 12:00:00	IWM	ETF	119.245	119.41	119.16	119.4	1620199.0
2016-07-13 13:00:00	IWM	ETF	119.4	119.66	119.2701	119.325	2163854.0
2016-07-13 14:00:00	IWM	ETF	119.325	119.46	119.2	119.29	1846301.0
2016-07-13 15:00:00	IWM	ETF	119.286	119.4	119.1	119.25	2974180.0
2016-07-13 16:00:00	IWM	ETF	119.24	119.42	119.24	119.39	821215.0
2016-07-13 17:00:00	IWM	ETF	119.39	119.39	119.35	119.39	1107.0
2016-07-13 18:00:00	IWM	ETF	119.3	119.35	119.22	119.22	3550.0
2016-07-13 19:00:00	IWM	ETF	119.25	119.25	119.2	119.23	6250.0
2016-07-13 07:00:00	DIA	ETF	183.44	183.44	183.42	183.42	2200.0
2016-07-13 08:00:00	DIA	ETF	183.53	183.85	183.52	183.85	8600.0
2016-07-13 09:00:00	DIA	ETF	183.75	183.8	183.29	183.36	435678.0

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

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