PREVIEW / etf_1hour / 2016-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-04.parquet
  size:    252 KB
  rows:    8,102

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-05-04 04:00:00	SPY	ETF	206.23	206.24	205.45	205.45	44002.0
2016-05-04 05:00:00	SPY	ETF	205.42	205.45	204.6	204.6	99496.0
2016-05-04 06:00:00	SPY	ETF	204.61	204.84	204.57	204.73	226017.0
2016-05-04 07:00:00	SPY	ETF	204.73	205.03	204.73	204.96	634300.0
2016-05-04 08:00:00	SPY	ETF	204.98	206.249	204.67	204.67	1543668.0
2016-05-04 09:00:00	SPY	ETF	204.69	205.44	204.67	205.35	11867476.0
2016-05-04 10:00:00	SPY	ETF	205.36	205.85	204.92	205.09	18542426.0
2016-05-04 11:00:00	SPY	ETF	205.08	205.285	204.62	204.9286	9593394.0
2016-05-04 12:00:00	SPY	ETF	204.92	205.27	204.67	204.6701	6152959.0
2016-05-04 13:00:00	SPY	ETF	204.68	205.055	204.6	204.67	7019224.0
2016-05-04 14:00:00	SPY	ETF	204.675	205.1	204.42	204.86	10254565.0
2016-05-04 15:00:00	SPY	ETF	204.87	205.33	204.69	204.99	16413269.0
2016-05-04 16:00:00	SPY	ETF	204.99	205.22	204.95	205.15	7047916.0
2016-05-04 17:00:00	SPY	ETF	205.15	205.18	204.96	205.13	108986.0
2016-05-04 18:00:00	SPY	ETF	205.14	205.37	205.14	205.33	156085.0
2016-05-04 19:00:00	SPY	ETF	205.35	205.43	205.32	205.36	53209.0
2016-05-04 04:00:00	QQQ	ETF	105.68	105.68	105.4	105.41	1852.0
2016-05-04 05:00:00	QQQ	ETF	105.37	105.37	105.01	105.01	9455.0
2016-05-04 06:00:00	QQQ	ETF	105.01	105.11	104.99	105.08	4347.0
2016-05-04 07:00:00	QQQ	ETF	105.07	105.11	105.01	105.08	89044.0
2016-05-04 08:00:00	QQQ	ETF	105.1	105.17	104.97	104.99	113027.0
2016-05-04 09:00:00	QQQ	ETF	105.03	105.34	104.97	105.3138	3706456.0
2016-05-04 10:00:00	QQQ	ETF	105.32	105.4811	105.08	105.24	4518990.0
2016-05-04 11:00:00	QQQ	ETF	105.25	105.38	104.905	105.1	2698017.0
2016-05-04 12:00:00	QQQ	ETF	105.11	105.35	104.94	104.94	1787668.0
2016-05-04 13:00:00	QQQ	ETF	104.95	105.185	104.85	105.01	1777462.0
2016-05-04 14:00:00	QQQ	ETF	105.01	105.216	104.7902	105.03	1684963.0
2016-05-04 15:00:00	QQQ	ETF	105.0305	105.25	104.92	105.04	3966050.0
2016-05-04 16:00:00	QQQ	ETF	105.035	105.22	105.035	105.22	1228082.0
2016-05-04 17:00:00	QQQ	ETF	105.15	105.17	105.12	105.17	4100.0
2016-05-04 18:00:00	QQQ	ETF	105.21	105.32	105.21	105.27	50418.0
2016-05-04 19:00:00	QQQ	ETF	105.28	105.32	105.28	105.28	31700.0
2016-05-04 04:00:00	IWM	ETF	111.42	111.42	111.19	111.19	9600.0
2016-05-04 05:00:00	IWM	ETF	111.05	111.07	110.93	110.93	1400.0
2016-05-04 06:00:00	IWM	ETF	110.81	110.86	110.74	110.86	3049.0
2016-05-04 07:00:00	IWM	ETF	110.85	111.0	110.85	110.9	109899.0
2016-05-04 08:00:00	IWM	ETF	110.97	111.01	110.75	110.8	185666.0
2016-05-04 09:00:00	IWM	ETF	110.88	111.89	110.88	111.77	3866746.0
2016-05-04 10:00:00	IWM	ETF	111.77	111.99	110.85	110.97	5189904.0
2016-05-04 11:00:00	IWM	ETF	110.97	111.09	110.45	110.7899	3588818.0
2016-05-04 12:00:00	IWM	ETF	110.78	110.97	110.43	110.43	2120762.0
2016-05-04 13:00:00	IWM	ETF	110.435	110.82	110.37	110.59	2097276.0
2016-05-04 14:00:00	IWM	ETF	110.59	110.84	110.37	110.71	2250521.0
2016-05-04 15:00:00	IWM	ETF	110.715	111.1	110.59	110.7	4828437.0
2016-05-04 16:00:00	IWM	ETF	110.7	111.6444	110.69	110.78	2970760.0
2016-05-04 17:00:00	IWM	ETF	110.79	110.82	110.76	110.76	16222.0
2016-05-04 18:00:00	IWM	ETF	110.82	110.82	110.82	110.82	195.0
2016-05-04 19:00:00	IWM	ETF	110.81	110.87	110.81	110.82	4500.0
2016-05-04 05:00:00	DIA	ETF	176.22	176.22	176.22	176.22	1400.0
2016-05-04 06:00:00	DIA	ETF	176.34	176.34	176.29	176.29	2700.0

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

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