PREVIEW / etf_1hour / 2015-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-04.parquet
  size:    248 KB
  rows:    7,873

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-12-04 04:00:00	SPY	ETF	206.81	206.9	206.52	206.64	52074.0
2015-12-04 05:00:00	SPY	ETF	206.61	206.79	206.42	206.79	33414.0
2015-12-04 06:00:00	SPY	ETF	206.69	206.81	206.46	206.64	23090.0
2015-12-04 07:00:00	SPY	ETF	206.61	206.61	206.19	206.26	168427.0
2015-12-04 08:00:00	SPY	ETF	206.49	207.23	205.61	206.11	2629293.0
2015-12-04 09:00:00	SPY	ETF	206.1	207.68	205.4	207.295	23997227.0
2015-12-04 10:00:00	SPY	ETF	207.2989	208.39	206.99	208.355	24550969.0
2015-12-04 11:00:00	SPY	ETF	208.35	208.5	207.63	207.78	18628660.0
2015-12-04 12:00:00	SPY	ETF	207.78	209.06	207.58	209.01	19680615.0
2015-12-04 13:00:00	SPY	ETF	209.03	209.56	208.97	209.355	28295081.0
2015-12-04 14:00:00	SPY	ETF	209.36	209.85	209.04	209.8199	21643688.0
2015-12-04 15:00:00	SPY	ETF	209.82	209.97	209.32	209.63	35592484.0
2015-12-04 16:00:00	SPY	ETF	209.63	209.72	208.5673	209.56	15662654.0
2015-12-04 17:00:00	SPY	ETF	209.57	209.61	209.51	209.58	561189.0
2015-12-04 18:00:00	SPY	ETF	209.56	209.61	209.54	209.56	10334.0
2015-12-04 19:00:00	SPY	ETF	209.6	209.62	209.56	209.61	19611.0
2015-12-04 04:00:00	QQQ	ETF	113.1	113.18	113.1	113.1	850.0
2015-12-04 05:00:00	QQQ	ETF	112.95	112.95	112.95	112.95	500.0
2015-12-04 06:00:00	QQQ	ETF	112.96	113.04	112.96	113.04	700.0
2015-12-04 07:00:00	QQQ	ETF	112.89	112.89	112.71	112.77	7084.0
2015-12-04 08:00:00	QQQ	ETF	112.75	113.06	112.51	112.85	433908.0
2015-12-04 09:00:00	QQQ	ETF	112.74	113.86	112.44	113.68	7630914.0
2015-12-04 10:00:00	QQQ	ETF	113.68	114.39	112.6339	114.359	7602829.0
2015-12-04 11:00:00	QQQ	ETF	114.36	114.48	114.01	114.18	4228325.0
2015-12-04 12:00:00	QQQ	ETF	114.17	114.87	114.06	114.85	3644003.0
2015-12-04 13:00:00	QQQ	ETF	114.86	115.08	114.8	115.01	3229463.0
2015-12-04 14:00:00	QQQ	ETF	115.02	115.26	114.84	115.25	3017867.0
2015-12-04 15:00:00	QQQ	ETF	115.25	115.33	115.0	115.12	6897428.0
2015-12-04 16:00:00	QQQ	ETF	115.14	115.19	115.06	115.17	1198088.0
2015-12-04 17:00:00	QQQ	ETF	115.1	115.19	115.1	115.11	550567.0
2015-12-04 18:00:00	QQQ	ETF	115.19	115.19	115.19	115.19	290.0
2015-12-04 19:00:00	QQQ	ETF	115.14	115.14	115.11	115.14	6582.0
2015-12-04 04:00:00	IWM	ETF	117.0	117.2	117.0	117.2	200.0
2015-12-04 07:00:00	IWM	ETF	116.88	116.88	116.86	116.86	200.0
2015-12-04 08:00:00	IWM	ETF	116.72	117.06	116.6	116.65	175426.0
2015-12-04 09:00:00	IWM	ETF	116.6	117.51	116.2	117.02	4832296.0
2015-12-04 10:00:00	IWM	ETF	117.02	117.76	116.72	117.56	5003623.0
2015-12-04 11:00:00	IWM	ETF	117.56	117.65	116.78	116.89	3137420.0
2015-12-04 12:00:00	IWM	ETF	116.8813	117.5863	116.78	117.545	3516539.0
2015-12-04 13:00:00	IWM	ETF	117.55	117.88	117.4	117.63	3343878.0
2015-12-04 14:00:00	IWM	ETF	117.625	117.815	117.41	117.74	2126362.0
2015-12-04 15:00:00	IWM	ETF	117.75	117.93	117.6	117.79	5613935.0
2015-12-04 16:00:00	IWM	ETF	117.78	117.93	117.71	117.93	941979.0
2015-12-04 17:00:00	IWM	ETF	117.91	117.96	117.86	117.9	346600.0
2015-12-04 19:00:00	IWM	ETF	117.91	117.95	117.8	117.8	5508.0
2015-12-04 04:00:00	DIA	ETF	175.25	175.25	175.25	175.25	195.0
2015-12-04 07:00:00	DIA	ETF	175.4	175.4	175.38	175.38	1100.0
2015-12-04 08:00:00	DIA	ETF	175.25	175.9	175.25	175.32	6700.0
2015-12-04 09:00:00	DIA	ETF	174.9	176.87	174.9	176.55	1120355.0
2015-12-04 10:00:00	DIA	ETF	176.57	177.51	176.43	177.47	1236867.0

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

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