PREVIEW / etf_1hour / 2015-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-14.parquet
  size:    239 KB
  rows:    7,561

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
2015-10-14 04:00:00	SPY	ETF	200.1	200.3	199.68	199.83	11216.0
2015-10-14 05:00:00	SPY	ETF	199.81	200.07	199.81	200.07	4183.0
2015-10-14 06:00:00	SPY	ETF	200.02	200.13	199.88	199.99	63183.0
2015-10-14 07:00:00	SPY	ETF	199.98	200.31	199.98	200.26	208167.0
2015-10-14 08:00:00	SPY	ETF	200.25	200.55	199.95	200.04	1216968.0
2015-10-14 09:00:00	SPY	ETF	200.03	200.87	199.89	200.7311	9603754.0
2015-10-14 10:00:00	SPY	ETF	200.75	200.79	199.34	199.55	17620693.0
2015-10-14 11:00:00	SPY	ETF	199.56	199.84	199.23	199.74	11997545.0
2015-10-14 12:00:00	SPY	ETF	199.74	200.53	199.34	200.27	10614262.0
2015-10-14 13:00:00	SPY	ETF	200.26	200.38	199.83	200.005	7505323.0
2015-10-14 14:00:00	SPY	ETF	200.005	200.24	198.97	199.15	13366876.0
2015-10-14 15:00:00	SPY	ETF	199.14	199.65	198.94	199.27	18594748.0
2015-10-14 16:00:00	SPY	ETF	199.28	200.6655	198.95	199.21	6086981.0
2015-10-14 17:00:00	SPY	ETF	199.18	199.43	199.14	199.26	341327.0
2015-10-14 18:00:00	SPY	ETF	199.25	199.58	199.24	199.48	146764.0
2015-10-14 19:00:00	SPY	ETF	199.47	199.5	199.42	199.47	65792.0
2015-10-14 04:00:00	QQQ	ETF	105.89	105.91	105.7	105.7	6500.0
2015-10-14 05:00:00	QQQ	ETF	105.8	105.8	105.8	105.8	100.0
2015-10-14 06:00:00	QQQ	ETF	105.86	105.96	105.84	105.88	3191.0
2015-10-14 07:00:00	QQQ	ETF	105.97	105.98	105.94	105.97	9729.0
2015-10-14 08:00:00	QQQ	ETF	105.9	106.26	105.86	106.02	61675.0
2015-10-14 09:00:00	QQQ	ETF	105.96	106.6	105.94	106.51	3597153.0
2015-10-14 10:00:00	QQQ	ETF	106.505	106.54	105.49	105.7	6818792.0
2015-10-14 11:00:00	QQQ	ETF	105.705	105.96	105.595	105.92	3162104.0
2015-10-14 12:00:00	QQQ	ETF	105.92	106.63	105.69	106.49	3639450.0
2015-10-14 13:00:00	QQQ	ETF	106.49	106.57	106.24	106.37	2186241.0
2015-10-14 14:00:00	QQQ	ETF	106.37	106.521	105.78	105.88	3373452.0
2015-10-14 15:00:00	QQQ	ETF	105.89	106.19	105.69	105.92	5377240.0
2015-10-14 16:00:00	QQQ	ETF	105.93	106.01	105.58	105.79	1087556.0
2015-10-14 17:00:00	QQQ	ETF	105.77	105.89	105.73	105.85	50447.0
2015-10-14 18:00:00	QQQ	ETF	105.85	106.03	105.85	106.0	27306.0
2015-10-14 19:00:00	QQQ	ETF	105.98	106.09	105.98	106.08	33575.0
2015-10-14 04:00:00	IWM	ETF	114.1	114.1	114.07	114.07	600.0
2015-10-14 05:00:00	IWM	ETF	113.85	113.85	113.85	113.85	1000.0
2015-10-14 07:00:00	IWM	ETF	114.04	114.15	114.04	114.14	10282.0
2015-10-14 08:00:00	IWM	ETF	114.11	114.29	113.93	114.03	31186.0
2015-10-14 09:00:00	IWM	ETF	114.01	114.75	113.88	114.62	3421324.0
2015-10-14 10:00:00	IWM	ETF	114.615	114.67	113.34	113.43	6521893.0
2015-10-14 11:00:00	IWM	ETF	113.44	113.66	113.06	113.39	4275145.0
2015-10-14 12:00:00	IWM	ETF	113.395	114.27	113.1475	114.081	3567516.0
2015-10-14 13:00:00	IWM	ETF	114.09	114.21	113.71	113.93	2783185.0
2015-10-14 14:00:00	IWM	ETF	113.93	114.08	112.96	113.12	4665706.0
2015-10-14 15:00:00	IWM	ETF	113.12	113.255	112.71	112.89	9337737.0
2015-10-14 16:00:00	IWM	ETF	112.88	112.92	112.65	112.74	1314401.0
2015-10-14 17:00:00	IWM	ETF	112.78	112.85	112.55	112.64	25313.0
2015-10-14 18:00:00	IWM	ETF	112.72	112.99	112.72	112.99	5459.0
2015-10-14 04:00:00	DIA	ETF	170.55	170.55	170.55	170.55	100.0
2015-10-14 07:00:00	DIA	ETF	170.52	170.59	170.52	170.59	700.0
2015-10-14 08:00:00	DIA	ETF	170.64	170.73	170.64	170.73	700.0
2015-10-14 09:00:00	DIA	ETF	170.44	170.95	170.27	170.83	399530.0

> showing 50 of 7,561 rows — these rows as CSV

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