PREVIEW / etf_1hour / 2017-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-15.parquet
  size:    276 KB
  rows:    9,074

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
2017-05-15 04:00:00	SPY	ETF	239.4	239.45	239.36	239.36	14429.0
2017-05-15 05:00:00	SPY	ETF	239.38	239.4	239.12	239.16	18700.0
2017-05-15 06:00:00	SPY	ETF	239.2	239.38	239.2	239.34	25760.0
2017-05-15 07:00:00	SPY	ETF	239.31	239.44	239.29	239.39	177155.0
2017-05-15 08:00:00	SPY	ETF	239.3	239.56	239.3	239.46	555788.0
2017-05-15 09:00:00	SPY	ETF	239.46	240.05	239.44	240.03	6039514.0
2017-05-15 10:00:00	SPY	ETF	240.03	240.39	240.01	240.32	7630736.0
2017-05-15 11:00:00	SPY	ETF	240.33	240.44	240.125	240.19	6989668.0
2017-05-15 12:00:00	SPY	ETF	240.19	240.23	240.09	240.1237	3240392.0
2017-05-15 13:00:00	SPY	ETF	240.125	240.34	240.07	240.295	3554752.0
2017-05-15 14:00:00	SPY	ETF	240.29	240.3	239.93	239.995	7063961.0
2017-05-15 15:00:00	SPY	ETF	240.0	240.33	239.97	240.245	15284732.0
2017-05-15 16:00:00	SPY	ETF	240.26	240.3	239.01	240.24	8927993.0
2017-05-15 17:00:00	SPY	ETF	240.18	240.24	240.14	240.19	698681.0
2017-05-15 18:00:00	SPY	ETF	240.18	240.18	239.99	240.06	186354.0
2017-05-15 19:00:00	SPY	ETF	240.06	240.2439	240.04	240.1	225435.0
2017-05-15 04:00:00	QQQ	ETF	138.79	138.79	138.79	138.79	100.0
2017-05-15 05:00:00	QQQ	ETF	138.6	138.6	138.58	138.58	5800.0
2017-05-15 06:00:00	QQQ	ETF	138.62	138.69	138.62	138.69	1800.0
2017-05-15 07:00:00	QQQ	ETF	138.69	138.69	138.65	138.65	11557.0
2017-05-15 08:00:00	QQQ	ETF	138.67	138.71	138.62	138.66	84012.0
2017-05-15 09:00:00	QQQ	ETF	138.68	138.97	138.53	138.92	2938947.0
2017-05-15 10:00:00	QQQ	ETF	138.91	139.12	138.73	139.055	2146683.0
2017-05-15 11:00:00	QQQ	ETF	139.06	139.1	138.74	138.79	2849864.0
2017-05-15 12:00:00	QQQ	ETF	138.79	138.85	138.7	138.77	1485839.0
2017-05-15 13:00:00	QQQ	ETF	138.7704	139.0	138.76	138.97	2558599.0
2017-05-15 14:00:00	QQQ	ETF	138.97	138.98	138.81	138.93	1498220.0
2017-05-15 15:00:00	QQQ	ETF	138.93	139.04	138.85	139.04	3065190.0
2017-05-15 16:00:00	QQQ	ETF	139.03	139.09	138.8912	139.08	763004.0
2017-05-15 17:00:00	QQQ	ETF	139.08	139.1	139.05	139.09	9654.0
2017-05-15 18:00:00	QQQ	ETF	139.06	139.06	138.97	139.01	13103.0
2017-05-15 19:00:00	QQQ	ETF	139.01	139.04	139.01	139.04	6861.0
2017-05-15 04:00:00	IWM	ETF	137.96	137.98	137.96	137.98	2100.0
2017-05-15 05:00:00	IWM	ETF	137.73	137.73	137.66	137.66	2100.0
2017-05-15 06:00:00	IWM	ETF	137.72	137.72	137.71	137.71	600.0
2017-05-15 07:00:00	IWM	ETF	137.77	137.94	137.75	137.93	38324.0
2017-05-15 08:00:00	IWM	ETF	137.92	138.09	137.89	138.01	185730.0
2017-05-15 09:00:00	IWM	ETF	138.0	138.96	137.97	138.83	3461627.0
2017-05-15 10:00:00	IWM	ETF	138.83	139.08	138.7	139.05	3338249.0
2017-05-15 11:00:00	IWM	ETF	139.05	139.25	138.89	138.97	2264006.0
2017-05-15 12:00:00	IWM	ETF	138.97	139.03	138.73	138.9	1239041.0
2017-05-15 13:00:00	IWM	ETF	138.8943	139.06	138.77	138.91	1581241.0
2017-05-15 14:00:00	IWM	ETF	138.91	138.93	138.34	138.44	2522401.0
2017-05-15 15:00:00	IWM	ETF	138.45	138.73	138.375	138.55	4857383.0
2017-05-15 16:00:00	IWM	ETF	138.58	139.2074	138.51	138.77	8523050.0
2017-05-15 17:00:00	IWM	ETF	138.77	138.77	137.51	138.7	66727.0
2017-05-15 18:00:00	IWM	ETF	138.69	138.69	138.54	138.54	1100.0
2017-05-15 19:00:00	IWM	ETF	138.56	138.6	138.56	138.56	723.0
2017-05-15 04:00:00	DIA	ETF	209.22	209.6	209.22	209.44	518.0
2017-05-15 05:00:00	DIA	ETF	209.38	209.38	209.24	209.24	500.0

> showing 50 of 9,074 rows — these rows as CSV

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