PREVIEW / etf_1hour / 2016-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-14.parquet
  size:    260 KB
  rows:    8,372

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-14 04:00:00	SPY	ETF	216.0	216.43	215.2	216.28	147127.0
2016-07-14 05:00:00	SPY	ETF	216.3	217.15	216.27	217.06	171504.0
2016-07-14 06:00:00	SPY	ETF	217.06	217.06	216.41	216.62	420743.0
2016-07-14 07:00:00	SPY	ETF	216.58	216.89	216.0	216.77	895554.0
2016-07-14 08:00:00	SPY	ETF	216.78	216.83	214.789	216.67	1171536.0
2016-07-14 09:00:00	SPY	ETF	216.68	216.68	215.93	216.26	14394509.0
2016-07-14 10:00:00	SPY	ETF	216.27	216.67	216.14	216.2651	14920943.0
2016-07-14 11:00:00	SPY	ETF	216.269	216.55	216.09	216.15	8492208.0
2016-07-14 12:00:00	SPY	ETF	216.15	216.33	216.01	216.11	7279272.0
2016-07-14 13:00:00	SPY	ETF	216.115	216.12	215.66	215.82	7804565.0
2016-07-14 14:00:00	SPY	ETF	215.8199	216.22	215.75	216.11	7875630.0
2016-07-14 15:00:00	SPY	ETF	216.113	216.44	216.06	216.07	19231441.0
2016-07-14 16:00:00	SPY	ETF	216.08	216.25	215.92	216.14	5376049.0
2016-07-14 17:00:00	SPY	ETF	216.17	216.25	216.07	216.07	311935.0
2016-07-14 18:00:00	SPY	ETF	216.07	216.11	215.77	215.82	232883.0
2016-07-14 19:00:00	SPY	ETF	215.82	215.82	215.66	215.74	233907.0
2016-07-14 04:00:00	QQQ	ETF	111.85	112.03	111.85	111.96	10150.0
2016-07-14 05:00:00	QQQ	ETF	111.98	112.3	111.98	112.3	10089.0
2016-07-14 06:00:00	QQQ	ETF	112.3	112.3	112.0	112.05	8999.0
2016-07-14 07:00:00	QQQ	ETF	111.95	112.11	111.73	112.11	122348.0
2016-07-14 08:00:00	QQQ	ETF	112.07	112.09	111.95	112.07	104268.0
2016-07-14 09:00:00	QQQ	ETF	112.06	112.07	111.72	111.84	2264041.0
2016-07-14 10:00:00	QQQ	ETF	111.84	112.19	111.84	111.98	3992182.0
2016-07-14 11:00:00	QQQ	ETF	111.98	112.11	111.82	111.895	1884965.0
2016-07-14 12:00:00	QQQ	ETF	111.9	112.0	111.85	111.92	1287282.0
2016-07-14 13:00:00	QQQ	ETF	111.92	111.93	111.7	111.7696	1846713.0
2016-07-14 14:00:00	QQQ	ETF	111.775	111.97	111.71	111.935	1028162.0
2016-07-14 15:00:00	QQQ	ETF	111.935	112.12	111.9	111.96	2523633.0
2016-07-14 16:00:00	QQQ	ETF	111.97	112.04	111.8	111.98	330514.0
2016-07-14 17:00:00	QQQ	ETF	111.92	112.0	111.92	111.96	1295.0
2016-07-14 18:00:00	QQQ	ETF	111.88	111.94	111.79	111.79	60663.0
2016-07-14 19:00:00	QQQ	ETF	111.79	111.79	111.76	111.76	38386.0
2016-07-14 04:00:00	IWM	ETF	120.19	120.32	120.17	120.2	63316.0
2016-07-14 05:00:00	IWM	ETF	120.2	120.32	120.2	120.32	15600.0
2016-07-14 06:00:00	IWM	ETF	120.57	120.64	120.29	120.3	20050.0
2016-07-14 07:00:00	IWM	ETF	120.3	120.54	120.0	120.54	100292.0
2016-07-14 08:00:00	IWM	ETF	120.48	120.5	120.3	120.4	138660.0
2016-07-14 09:00:00	IWM	ETF	120.4	120.4	119.43	119.65	2670759.0
2016-07-14 10:00:00	IWM	ETF	119.66	120.22	119.561	119.98	4120574.0
2016-07-14 11:00:00	IWM	ETF	119.98	120.25	119.695	119.78	1790057.0
2016-07-14 12:00:00	IWM	ETF	119.785	119.99	119.63	119.7	1884268.0
2016-07-14 13:00:00	IWM	ETF	119.7	119.7	119.4389	119.6074	1490702.0
2016-07-14 14:00:00	IWM	ETF	119.6	119.684	119.51	119.5501	1061884.0
2016-07-14 15:00:00	IWM	ETF	119.56	119.73	119.3	119.37	2802151.0
2016-07-14 16:00:00	IWM	ETF	119.37	119.52	119.23	119.46	2177525.0
2016-07-14 17:00:00	IWM	ETF	119.4	119.45	119.35	119.35	40966.0
2016-07-14 18:00:00	IWM	ETF	119.31	119.31	119.19	119.25	3400.0
2016-07-14 19:00:00	IWM	ETF	119.25	119.25	119.13	119.25	16850.0
2016-07-14 06:00:00	DIA	ETF	185.26	185.26	185.1	185.1	750.0
2016-07-14 07:00:00	DIA	ETF	185.0	185.27	184.67	185.19	5156.0

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

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