PREVIEW / etf_1hour / 2016-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-05.parquet
  size:    251 KB
  rows:    8,027

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-05 04:00:00	SPY	ETF	216.8	216.81	216.59	216.72	22449.0
2016-08-05 05:00:00	SPY	ETF	216.7	216.89	216.68	216.82	11243.0
2016-08-05 06:00:00	SPY	ETF	216.82	216.91	216.76	216.88	46345.0
2016-08-05 07:00:00	SPY	ETF	216.85	216.89	216.67	216.69	96545.0
2016-08-05 08:00:00	SPY	ETF	216.81	217.23	216.55	217.15	2319756.0
2016-08-05 09:00:00	SPY	ETF	217.15	217.86	217.03	217.86	10509504.0
2016-08-05 10:00:00	SPY	ETF	217.86	217.98	217.681	217.95	9941271.0
2016-08-05 11:00:00	SPY	ETF	217.945	218.14	217.92	218.01	7087110.0
2016-08-05 12:00:00	SPY	ETF	218.01	218.2	218.0	218.06	4747646.0
2016-08-05 13:00:00	SPY	ETF	218.0799	218.14	217.98	218.11	3866175.0
2016-08-05 14:00:00	SPY	ETF	218.11	218.13	217.9	217.98	6683059.0
2016-08-05 15:00:00	SPY	ETF	217.98	218.23	217.975	218.17	16802913.0
2016-08-05 16:00:00	SPY	ETF	218.17	218.2445	218.06	218.16	6060536.0
2016-08-05 17:00:00	SPY	ETF	218.15	218.25	218.11	218.11	144952.0
2016-08-05 18:00:00	SPY	ETF	218.12	218.21	218.11	218.21	34908.0
2016-08-05 19:00:00	SPY	ETF	218.2	218.22	218.16	218.2	25885.0
2016-08-05 04:00:00	QQQ	ETF	116.01	116.05	116.0	116.0	5405.0
2016-08-05 06:00:00	QQQ	ETF	115.98	115.98	115.98	115.98	600.0
2016-08-05 07:00:00	QQQ	ETF	115.99	116.0	115.93	115.93	13687.0
2016-08-05 08:00:00	QQQ	ETF	115.96	116.27	115.84	116.21	376877.0
2016-08-05 09:00:00	QQQ	ETF	116.23	116.79	116.13	116.79	3107894.0
2016-08-05 10:00:00	QQQ	ETF	116.79	117.0	116.79	116.979	2397657.0
2016-08-05 11:00:00	QQQ	ETF	116.97	117.04	116.87	116.9	1916901.0
2016-08-05 12:00:00	QQQ	ETF	116.91	117.02	116.89	116.94	1338132.0
2016-08-05 13:00:00	QQQ	ETF	116.94	116.985	116.85	116.97	1260528.0
2016-08-05 14:00:00	QQQ	ETF	116.97	116.98	116.74	116.78	1320722.0
2016-08-05 15:00:00	QQQ	ETF	116.79	116.875	116.7	116.78	3684857.0
2016-08-05 16:00:00	QQQ	ETF	116.77	116.8141	116.67	116.71	2009635.0
2016-08-05 17:00:00	QQQ	ETF	116.7	116.74	116.7	116.74	1556694.0
2016-08-05 18:00:00	QQQ	ETF	116.71	116.73	116.71	116.71	2236.0
2016-08-05 19:00:00	QQQ	ETF	116.68	116.8024	116.68	116.71	622655.0
2016-08-05 04:00:00	IWM	ETF	120.76	120.77	120.75	120.75	4663.0
2016-08-05 07:00:00	IWM	ETF	120.9	120.9	120.78	120.8	31924.0
2016-08-05 08:00:00	IWM	ETF	120.78	121.16	120.69	121.09	162511.0
2016-08-05 09:00:00	IWM	ETF	121.1	121.96	120.97	121.95	3423889.0
2016-08-05 10:00:00	IWM	ETF	121.95	122.1	121.8	122.03	2775005.0
2016-08-05 11:00:00	IWM	ETF	122.02	122.45	122.01	122.3035	2268391.0
2016-08-05 12:00:00	IWM	ETF	122.305	122.53	122.28	122.485	2493217.0
2016-08-05 13:00:00	IWM	ETF	122.49	122.58	122.38	122.45	2072309.0
2016-08-05 14:00:00	IWM	ETF	122.45	122.53	122.33	122.34	1378329.0
2016-08-05 15:00:00	IWM	ETF	122.35	122.47	122.21	122.33	5005486.0
2016-08-05 16:00:00	IWM	ETF	122.33	122.45	122.2	122.27	3886581.0
2016-08-05 17:00:00	IWM	ETF	122.21	122.34	122.21	122.31	19394.0
2016-08-05 18:00:00	IWM	ETF	122.3	122.3	122.3	122.3	500.0
2016-08-05 19:00:00	IWM	ETF	122.3	122.32	122.3	122.3	2925.0
2016-08-05 05:00:00	DIA	ETF	183.68	183.72	183.68	183.72	800.0
2016-08-05 07:00:00	DIA	ETF	183.6	183.6	183.6	183.6	1200.0
2016-08-05 08:00:00	DIA	ETF	183.7	184.47	183.7	184.43	9871.0
2016-08-05 09:00:00	DIA	ETF	184.4	184.93	184.37	184.91	545487.0
2016-08-05 10:00:00	DIA	ETF	184.9263	185.01	184.77	184.94	398325.0

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

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