PREVIEW / etf_1hour / 2015-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-02.parquet
  size:    248 KB
  rows:    7,910

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-11-02 04:00:00	SPY	ETF	207.51	208.21	207.43	208.15	31916.0
2015-11-02 05:00:00	SPY	ETF	208.11	208.16	207.91	208.06	16078.0
2015-11-02 06:00:00	SPY	ETF	208.13	208.29	208.1	208.11	40580.0
2015-11-02 07:00:00	SPY	ETF	208.08	208.11	207.92	208.0	192827.0
2015-11-02 08:00:00	SPY	ETF	208.03	208.36	207.35	208.34	378814.0
2015-11-02 09:00:00	SPY	ETF	208.33	209.03	207.93	208.96	10216942.0
2015-11-02 10:00:00	SPY	ETF	208.96	209.3	208.83	209.14	13519576.0
2015-11-02 11:00:00	SPY	ETF	209.14	209.47	209.07	209.285	9594552.0
2015-11-02 12:00:00	SPY	ETF	209.29	209.63	209.2001	209.59	6083819.0
2015-11-02 13:00:00	SPY	ETF	209.58	209.73	209.43	209.73	6362123.0
2015-11-02 14:00:00	SPY	ETF	209.725	210.38	209.71	210.35	10208725.0
2015-11-02 15:00:00	SPY	ETF	210.35	210.62	210.21	210.37	20120182.0
2015-11-02 16:00:00	SPY	ETF	210.38	210.4	209.6014	209.93	5782568.0
2015-11-02 17:00:00	SPY	ETF	209.93	210.03	209.93	209.95	1634523.0
2015-11-02 18:00:00	SPY	ETF	209.96	210.09	209.88	210.07	110509.0
2015-11-02 19:00:00	SPY	ETF	210.01	210.33	210.01	210.28	84052.0
2015-11-02 04:00:00	QQQ	ETF	113.54	113.54	113.54	113.54	500.0
2015-11-02 05:00:00	QQQ	ETF	113.45	113.5	113.4	113.5	2900.0
2015-11-02 06:00:00	QQQ	ETF	113.5	113.55	113.48	113.51	6395.0
2015-11-02 07:00:00	QQQ	ETF	113.48	113.54	113.43	113.54	5238.0
2015-11-02 08:00:00	QQQ	ETF	113.51	113.68	113.51	113.68	65857.0
2015-11-02 09:00:00	QQQ	ETF	113.69	113.86	113.39	113.83	2814285.0
2015-11-02 10:00:00	QQQ	ETF	113.83	114.1	113.76	114.06	4194705.0
2015-11-02 11:00:00	QQQ	ETF	114.06	114.28	114.0201	114.22	2404983.0
2015-11-02 12:00:00	QQQ	ETF	114.22	114.3301	114.13	114.3	1408279.0
2015-11-02 13:00:00	QQQ	ETF	114.3	114.38	114.23	114.38	1551024.0
2015-11-02 14:00:00	QQQ	ETF	114.38	114.6	114.37	114.57	3157471.0
2015-11-02 15:00:00	QQQ	ETF	114.565	114.745	114.455	114.62	4203900.0
2015-11-02 16:00:00	QQQ	ETF	114.62	114.62	114.48	114.49	341857.0
2015-11-02 17:00:00	QQQ	ETF	114.53	114.53	114.49	114.51	2567.0
2015-11-02 18:00:00	QQQ	ETF	114.49	114.57	114.45	114.57	13473.0
2015-11-02 19:00:00	QQQ	ETF	114.58	114.71	114.58	114.68	39820.0
2015-11-02 04:00:00	IWM	ETF	115.04	115.04	115.0	115.0	200.0
2015-11-02 06:00:00	IWM	ETF	115.43	115.43	115.43	115.43	1000.0
2015-11-02 07:00:00	IWM	ETF	115.35	115.37	115.31	115.34	12400.0
2015-11-02 08:00:00	IWM	ETF	115.35	115.53	115.33	115.53	22228.0
2015-11-02 09:00:00	IWM	ETF	115.34	116.19	115.34	116.19	3345929.0
2015-11-02 10:00:00	IWM	ETF	116.19	116.49	116.03	116.34	3341970.0
2015-11-02 11:00:00	IWM	ETF	116.34	116.7	116.29	116.52	3272971.0
2015-11-02 12:00:00	IWM	ETF	116.52	116.99	116.46	116.97	3258926.0
2015-11-02 13:00:00	IWM	ETF	116.97	117.54	116.91	117.54	3300864.0
2015-11-02 14:00:00	IWM	ETF	117.53	118.0711	117.52	117.98	4533458.0
2015-11-02 15:00:00	IWM	ETF	117.98	118.03	117.59	117.76	7226998.0
2015-11-02 16:00:00	IWM	ETF	117.76	117.84	117.47	117.54	1172526.0
2015-11-02 17:00:00	IWM	ETF	117.47	117.6	117.46	117.48	1400.0
2015-11-02 18:00:00	IWM	ETF	117.57	117.57	117.57	117.57	100.0
2015-11-02 19:00:00	IWM	ETF	117.61	117.69	117.58	117.67	3200.0
2015-11-02 04:00:00	DIA	ETF	176.21	176.21	176.21	176.21	141.0
2015-11-02 08:00:00	DIA	ETF	176.65	176.81	176.55	176.81	3100.0
2015-11-02 09:00:00	DIA	ETF	176.85	177.3	176.73	177.23	439638.0

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

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