PREVIEW / etf_1hour / 2016-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-02.parquet
  size:    246 KB
  rows:    7,819

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-06-02 04:00:00	SPY	ETF	209.87	210.1	209.78	210.06	6784.0
2016-06-02 05:00:00	SPY	ETF	210.03	210.23	210.03	210.23	7119.0
2016-06-02 06:00:00	SPY	ETF	210.22	210.25	210.09	210.23	7905.0
2016-06-02 07:00:00	SPY	ETF	210.26	210.27	210.15	210.2	37333.0
2016-06-02 08:00:00	SPY	ETF	210.18	210.22	209.75	209.81	536600.0
2016-06-02 09:00:00	SPY	ETF	209.82	209.91	209.2399	209.41	8836132.0
2016-06-02 10:00:00	SPY	ETF	209.41	209.92	209.35	209.82	8531636.0
2016-06-02 11:00:00	SPY	ETF	209.82	210.19	209.75	210.12	7593156.0
2016-06-02 12:00:00	SPY	ETF	210.1111	210.2	209.78	210.17	5636378.0
2016-06-02 13:00:00	SPY	ETF	210.1601	210.41	210.12	210.39	4897360.0
2016-06-02 14:00:00	SPY	ETF	210.39	210.67	210.385	210.5765	6893546.0
2016-06-02 15:00:00	SPY	ETF	210.57	210.91	210.42	210.91	14064615.0
2016-06-02 16:00:00	SPY	ETF	210.91	211.04	210.6143	210.97	5041867.0
2016-06-02 17:00:00	SPY	ETF	210.97	210.98	210.9	210.97	104903.0
2016-06-02 18:00:00	SPY	ETF	210.95	210.95	210.85	210.87	51956.0
2016-06-02 19:00:00	SPY	ETF	210.87	211.04	210.85	211.02	53546.0
2016-06-02 04:00:00	QQQ	ETF	110.12	110.12	110.12	110.12	200.0
2016-06-02 05:00:00	QQQ	ETF	110.31	110.31	110.31	110.31	1500.0
2016-06-02 06:00:00	QQQ	ETF	110.28	110.34	110.28	110.31	5400.0
2016-06-02 07:00:00	QQQ	ETF	110.31	110.33	110.3	110.32	14698.0
2016-06-02 08:00:00	QQQ	ETF	110.29	110.35	110.12	110.15	43575.0
2016-06-02 09:00:00	QQQ	ETF	110.12	110.16	109.53	109.67	2196316.0
2016-06-02 10:00:00	QQQ	ETF	109.67	110.16	109.644	110.05	2536587.0
2016-06-02 11:00:00	QQQ	ETF	110.06	110.27	110.01	110.1	1681201.0
2016-06-02 12:00:00	QQQ	ETF	110.11	110.16	109.86	110.155	948285.0
2016-06-02 13:00:00	QQQ	ETF	110.16	110.301	110.09	110.28	1124940.0
2016-06-02 14:00:00	QQQ	ETF	110.28	110.46	110.28	110.42	1892262.0
2016-06-02 15:00:00	QQQ	ETF	110.42	110.59	110.35	110.58	2188412.0
2016-06-02 16:00:00	QQQ	ETF	110.58	110.65	110.57	110.61	387444.0
2016-06-02 17:00:00	QQQ	ETF	110.6	110.67	110.6	110.6	24074.0
2016-06-02 18:00:00	QQQ	ETF	110.6	110.6	110.56	110.56	37776.0
2016-06-02 19:00:00	QQQ	ETF	110.56	110.7	110.56	110.7	4943.0
2016-06-02 04:00:00	IWM	ETF	115.47	115.47	115.44	115.44	200.0
2016-06-02 05:00:00	IWM	ETF	115.59	115.59	115.59	115.59	400.0
2016-06-02 06:00:00	IWM	ETF	115.64	115.64	115.64	115.64	200.0
2016-06-02 07:00:00	IWM	ETF	115.65	115.68	115.65	115.67	1500.0
2016-06-02 08:00:00	IWM	ETF	115.58	115.61	115.44	115.5	31836.0
2016-06-02 09:00:00	IWM	ETF	115.47	115.79	115.37	115.53	2853477.0
2016-06-02 10:00:00	IWM	ETF	115.53	115.87	115.45	115.69	2955522.0
2016-06-02 11:00:00	IWM	ETF	115.69	116.01	115.63	115.93	2333667.0
2016-06-02 12:00:00	IWM	ETF	115.94	115.95	115.77	115.935	1384970.0
2016-06-02 13:00:00	IWM	ETF	115.94	116.22	115.88	116.2	2488735.0
2016-06-02 14:00:00	IWM	ETF	116.2	116.42	116.16	116.37	2553916.0
2016-06-02 15:00:00	IWM	ETF	116.38	116.66	116.27	116.66	4623148.0
2016-06-02 16:00:00	IWM	ETF	116.65	116.82	116.62	116.78	1555730.0
2016-06-02 17:00:00	IWM	ETF	116.74	116.81	116.74	116.77	7809.0
2016-06-02 18:00:00	IWM	ETF	116.73	116.78	116.73	116.78	2800.0
2016-06-02 19:00:00	IWM	ETF	116.78	116.87	116.74	116.87	8099.0
2016-06-02 08:00:00	DIA	ETF	177.45	177.45	177.45	177.45	500.0
2016-06-02 09:00:00	DIA	ETF	177.37	177.46	176.98	177.12	310010.0

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

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