PREVIEW / etf_1hour / 2016-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-01.parquet
  size:    251 KB
  rows:    8,045

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-01 04:00:00	SPY	ETF	210.09	210.09	209.55	209.55	1706.0
2016-06-01 05:00:00	SPY	ETF	209.53	210.37	209.41	209.59	96371.0
2016-06-01 06:00:00	SPY	ETF	209.46	209.47	209.33	209.41	85751.0
2016-06-01 07:00:00	SPY	ETF	209.47	209.47	209.24	209.39	158930.0
2016-06-01 08:00:00	SPY	ETF	209.3	210.08	209.25	209.28	499901.0
2016-06-01 09:00:00	SPY	ETF	209.28	209.29	208.89	209.09	8425293.0
2016-06-01 10:00:00	SPY	ETF	209.1	209.77	208.97	209.68	13067491.0
2016-06-01 11:00:00	SPY	ETF	209.68	210.05	209.61	209.78	9909640.0
2016-06-01 12:00:00	SPY	ETF	209.78	210.14	209.76	210.13	5493398.0
2016-06-01 13:00:00	SPY	ETF	210.13	210.19	209.69	209.955	4708676.0
2016-06-01 14:00:00	SPY	ETF	209.955	210.34	209.75	210.335	7945125.0
2016-06-01 15:00:00	SPY	ETF	210.35	210.48	210.14	210.27	13646589.0
2016-06-01 16:00:00	SPY	ETF	210.26	210.4	210.1767	210.28	3913591.0
2016-06-01 17:00:00	SPY	ETF	210.27	210.32	210.26	210.26	78489.0
2016-06-01 18:00:00	SPY	ETF	210.25	210.34	210.24	210.33	96257.0
2016-06-01 19:00:00	SPY	ETF	210.33	210.37	210.31	210.35	53435.0
2016-06-01 04:00:00	QQQ	ETF	110.3	110.3	110.3	110.3	400.0
2016-06-01 05:00:00	QQQ	ETF	110.18	110.18	110.18	110.18	498.0
2016-06-01 06:00:00	QQQ	ETF	110.16	110.2	110.12	110.18	4190.0
2016-06-01 07:00:00	QQQ	ETF	110.19	110.19	110.04	110.13	20120.0
2016-06-01 08:00:00	QQQ	ETF	110.11	110.2	110.04	110.08	93665.0
2016-06-01 09:00:00	QQQ	ETF	110.1	110.11	109.93	109.999	1754063.0
2016-06-01 10:00:00	QQQ	ETF	109.995	110.49	109.91	110.44	3607289.0
2016-06-01 11:00:00	QQQ	ETF	110.44	110.59	110.21	110.39	2114659.0
2016-06-01 12:00:00	QQQ	ETF	110.4	110.55	110.33	110.5468	1145067.0
2016-06-01 13:00:00	QQQ	ETF	110.55	110.56	110.23	110.34	932237.0
2016-06-01 14:00:00	QQQ	ETF	110.349	110.6	110.24	110.49	1698529.0
2016-06-01 15:00:00	QQQ	ETF	110.5	110.52	110.2	110.34	3451552.0
2016-06-01 16:00:00	QQQ	ETF	110.34	110.4	110.32	110.4	772629.0
2016-06-01 17:00:00	QQQ	ETF	110.43	110.43	110.35	110.35	3918.0
2016-06-01 18:00:00	QQQ	ETF	110.34	110.4	110.34	110.4	4274.0
2016-06-01 19:00:00	QQQ	ETF	110.4	110.4	110.38	110.38	4950.0
2016-06-01 04:00:00	IWM	ETF	114.82	114.9	114.82	114.9	200.0
2016-06-01 05:00:00	IWM	ETF	114.8	114.8	114.8	114.8	100.0
2016-06-01 06:00:00	IWM	ETF	114.78	114.78	114.78	114.78	100.0
2016-06-01 07:00:00	IWM	ETF	114.78	114.79	114.62	114.79	12600.0
2016-06-01 08:00:00	IWM	ETF	114.82	115.0	114.75	114.98	16197.0
2016-06-01 09:00:00	IWM	ETF	114.71	114.74	114.42	114.66	2940844.0
2016-06-01 10:00:00	IWM	ETF	114.67	114.99	114.47	114.93	3999957.0
2016-06-01 11:00:00	IWM	ETF	114.93	115.37	114.925	115.21	3034162.0
2016-06-01 12:00:00	IWM	ETF	115.2	115.62	115.2	115.608	2305643.0
2016-06-01 13:00:00	IWM	ETF	115.61	115.68	115.43	115.6	2221069.0
2016-06-01 14:00:00	IWM	ETF	115.6	115.76	115.42	115.75	2594875.0
2016-06-01 15:00:00	IWM	ETF	115.77	115.95	115.67	115.79	4936435.0
2016-06-01 16:00:00	IWM	ETF	115.81	115.87	115.71	115.73	967053.0
2016-06-01 17:00:00	IWM	ETF	115.73	115.75	115.72	115.73	10465.0
2016-06-01 18:00:00	IWM	ETF	115.75	115.75	115.75	115.75	1000.0
2016-06-01 19:00:00	IWM	ETF	115.74	115.76	115.73	115.76	10318.0
2016-06-01 06:00:00	DIA	ETF	177.26	177.26	177.26	177.26	400.0
2016-06-01 07:00:00	DIA	ETF	177.16	177.16	177.1	177.1	300.0

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

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