PREVIEW / etf_1hour / 2015-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-12.parquet
  size:    252 KB
  rows:    7,953

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-08-12 04:00:00	SPY	ETF	206.88	206.95	206.11	206.2	143556.0
2015-08-12 05:00:00	SPY	ETF	206.18	206.54	206.12	206.21	152591.0
2015-08-12 06:00:00	SPY	ETF	206.23	207.14	206.23	206.91	235019.0
2015-08-12 07:00:00	SPY	ETF	206.92	207.2	206.76	207.11	448788.0
2015-08-12 08:00:00	SPY	ETF	207.11	207.4	205.9	207.22	1323705.0
2015-08-12 09:00:00	SPY	ETF	207.23	207.45	206.36	206.59	21325837.0
2015-08-12 10:00:00	SPY	ETF	206.6	206.64	205.36	205.74	39562823.0
2015-08-12 11:00:00	SPY	ETF	205.74	206.36	205.7375	205.87	21760014.0
2015-08-12 12:00:00	SPY	ETF	205.87	207.12	205.675	206.873	15260829.0
2015-08-12 13:00:00	SPY	ETF	206.88	208.105	206.875	207.94	15793182.0
2015-08-12 14:00:00	SPY	ETF	207.94	208.54	207.45	208.51	18576058.0
2015-08-12 15:00:00	SPY	ETF	208.5	209.14	208.33	208.89	29505127.0
2015-08-12 16:00:00	SPY	ETF	208.88	209.12	208.75	209.04	5651384.0
2015-08-12 17:00:00	SPY	ETF	209.02	209.02	208.91	208.93	159347.0
2015-08-12 18:00:00	SPY	ETF	208.93	209.0	208.82	208.88	134084.0
2015-08-12 19:00:00	SPY	ETF	208.88	208.9	208.82	208.9	55727.0
2015-08-12 04:00:00	QQQ	ETF	109.29	109.29	109.0	109.0	14310.0
2015-08-12 05:00:00	QQQ	ETF	109.0	109.0	108.85	108.85	14350.0
2015-08-12 06:00:00	QQQ	ETF	108.86	109.32	108.82	109.19	38344.0
2015-08-12 07:00:00	QQQ	ETF	109.21	109.32	109.11	109.31	330867.0
2015-08-12 08:00:00	QQQ	ETF	109.3	109.43	109.17	109.4	241631.0
2015-08-12 09:00:00	QQQ	ETF	109.42	109.44	108.6451	108.86	6549068.0
2015-08-12 10:00:00	QQQ	ETF	108.87	108.97	108.22	108.395	7240036.0
2015-08-12 11:00:00	QQQ	ETF	108.4	109.099	108.3875	108.55	4785353.0
2015-08-12 12:00:00	QQQ	ETF	108.55	109.44	108.444	109.34	3382833.0
2015-08-12 13:00:00	QQQ	ETF	109.345	110.31	109.344	110.19	4371774.0
2015-08-12 14:00:00	QQQ	ETF	110.19	110.47	109.88	110.44	4708276.0
2015-08-12 15:00:00	QQQ	ETF	110.44	110.735	110.31	110.51	5536458.0
2015-08-12 16:00:00	QQQ	ETF	110.5	110.69	110.46	110.65	1040371.0
2015-08-12 17:00:00	QQQ	ETF	110.66	110.67	110.62	110.64	13517.0
2015-08-12 18:00:00	QQQ	ETF	110.62	110.65	110.53	110.56	9563.0
2015-08-12 19:00:00	QQQ	ETF	110.57	110.6	110.54	110.6	13045.0
2015-08-12 04:00:00	IWM	ETF	119.25	119.25	118.73	118.73	1500.0
2015-08-12 05:00:00	IWM	ETF	118.87	118.87	118.75	118.75	10200.0
2015-08-12 06:00:00	IWM	ETF	118.8	119.26	118.8	119.14	14600.0
2015-08-12 07:00:00	IWM	ETF	119.0	119.27	119.0	119.27	18194.0
2015-08-12 08:00:00	IWM	ETF	119.27	119.43	119.25	119.39	277838.0
2015-08-12 09:00:00	IWM	ETF	119.39	119.59	118.9	119.09	4805153.0
2015-08-12 10:00:00	IWM	ETF	119.09	119.11	117.965	118.16	8543669.0
2015-08-12 11:00:00	IWM	ETF	118.16	118.7756	118.13	118.35	5115397.0
2015-08-12 12:00:00	IWM	ETF	118.35	119.09	118.24	118.945	3115514.0
2015-08-12 13:00:00	IWM	ETF	118.96	119.94	118.935	119.895	3601245.0
2015-08-12 14:00:00	IWM	ETF	119.89	120.05	119.13	120.02	4262996.0
2015-08-12 15:00:00	IWM	ETF	120.01	120.34	119.8	120.01	6079257.0
2015-08-12 16:00:00	IWM	ETF	120.02	120.11	119.9	120.0	2203494.0
2015-08-12 17:00:00	IWM	ETF	119.97	119.97	119.94	119.94	4500.0
2015-08-12 18:00:00	IWM	ETF	119.99	119.99	119.99	119.99	833402.0
2015-08-12 04:00:00	DIA	ETF	172.32	172.4	172.19	172.19	1000.0
2015-08-12 06:00:00	DIA	ETF	172.7	172.73	172.7	172.73	1200.0
2015-08-12 07:00:00	DIA	ETF	172.7	172.86	172.5	172.85	6000.0

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

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