PREVIEW / etf_1hour / 2015-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-06.parquet
  size:    242 KB
  rows:    7,712

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-10-06 04:00:00	SPY	ETF	197.35	198.02	197.13	197.96	65343.0
2015-10-06 05:00:00	SPY	ETF	197.95	198.03	197.66	197.66	38094.0
2015-10-06 06:00:00	SPY	ETF	197.68	198.0	197.62	197.69	106879.0
2015-10-06 07:00:00	SPY	ETF	197.7	197.93	197.5	197.91	479182.0
2015-10-06 08:00:00	SPY	ETF	197.9	198.12	197.61	198.11	961026.0
2015-10-06 09:00:00	SPY	ETF	198.11	198.98	198.0	198.91	11813325.0
2015-10-06 10:00:00	SPY	ETF	198.91	198.93	197.69	197.89	17267557.0
2015-10-06 11:00:00	SPY	ETF	197.88	198.43	197.14	197.33	16281422.0
2015-10-06 12:00:00	SPY	ETF	197.33	197.74	197.0	197.48	11645632.0
2015-10-06 13:00:00	SPY	ETF	197.48	198.095	197.35	197.63	11125517.0
2015-10-06 14:00:00	SPY	ETF	197.62	198.27	197.47	197.7761	13616456.0
2015-10-06 15:00:00	SPY	ETF	197.77	198.2	197.54	197.82	18221746.0
2015-10-06 16:00:00	SPY	ETF	197.84	198.0	197.02	197.19	7225890.0
2015-10-06 17:00:00	SPY	ETF	197.2	197.9122	196.8	196.83	327291.0
2015-10-06 18:00:00	SPY	ETF	196.82	197.12	196.79	197.02	114195.0
2015-10-06 19:00:00	SPY	ETF	197.02	197.3	197.02	197.2	93377.0
2015-10-06 04:00:00	QQQ	ETF	104.81	105.1	104.65	105.1	8280.0
2015-10-06 05:00:00	QQQ	ETF	105.04	105.13	104.95	104.95	2645.0
2015-10-06 06:00:00	QQQ	ETF	104.95	105.12	104.94	105.12	8400.0
2015-10-06 07:00:00	QQQ	ETF	105.0	105.03	104.89	105.03	23739.0
2015-10-06 08:00:00	QQQ	ETF	105.03	105.22	104.94	105.2	118074.0
2015-10-06 09:00:00	QQQ	ETF	105.24	105.6	105.06	105.57	4000976.0
2015-10-06 10:00:00	QQQ	ETF	105.56	105.58	104.67	104.75	5630101.0
2015-10-06 11:00:00	QQQ	ETF	104.7501	104.971	104.27	104.39	4720565.0
2015-10-06 12:00:00	QQQ	ETF	104.39	104.6501	104.18	104.505	3675407.0
2015-10-06 13:00:00	QQQ	ETF	104.5	104.99	104.44	104.79	2708806.0
2015-10-06 14:00:00	QQQ	ETF	104.79	105.16	104.65	104.85	3068305.0
2015-10-06 15:00:00	QQQ	ETF	104.84	105.16	104.68	105.0	4966921.0
2015-10-06 16:00:00	QQQ	ETF	105.0	105.05	104.56	104.62	448698.0
2015-10-06 17:00:00	QQQ	ETF	104.62	104.62	104.48	104.53	19990.0
2015-10-06 18:00:00	QQQ	ETF	104.4	104.57	104.4	104.51	14729.0
2015-10-06 19:00:00	QQQ	ETF	104.58	104.62	104.53	104.6	27089.0
2015-10-06 04:00:00	IWM	ETF	112.66	112.66	112.66	112.66	100.0
2015-10-06 05:00:00	IWM	ETF	112.9	112.9	112.9	112.9	1000.0
2015-10-06 06:00:00	IWM	ETF	112.9	112.95	112.9	112.94	3000.0
2015-10-06 07:00:00	IWM	ETF	112.9	112.95	112.9	112.95	4800.0
2015-10-06 08:00:00	IWM	ETF	112.84	113.06	112.84	113.06	78904.0
2015-10-06 09:00:00	IWM	ETF	113.07	113.674	112.89	113.64	4102087.0
2015-10-06 10:00:00	IWM	ETF	113.64	113.66	112.73	112.96	5172106.0
2015-10-06 11:00:00	IWM	ETF	112.97	113.41	112.02	112.11	6298119.0
2015-10-06 12:00:00	IWM	ETF	112.12	112.411	111.78	112.27	3827149.0
2015-10-06 13:00:00	IWM	ETF	112.26	112.7	112.14	112.37	2487011.0
2015-10-06 14:00:00	IWM	ETF	112.37	112.91	112.27	112.46	3454148.0
2015-10-06 15:00:00	IWM	ETF	112.46	112.84	112.36	112.51	4632659.0
2015-10-06 16:00:00	IWM	ETF	112.51	112.58	111.95	112.01	1541125.0
2015-10-06 17:00:00	IWM	ETF	111.91	111.99	111.78	111.81	3724.0
2015-10-06 18:00:00	IWM	ETF	111.78	111.97	111.78	111.97	800.0
2015-10-06 19:00:00	IWM	ETF	111.97	112.01	111.86	112.01	825.0
2015-10-06 04:00:00	DIA	ETF	167.31	167.31	167.31	167.31	1350.0
2015-10-06 05:00:00	DIA	ETF	167.25	167.25	167.25	167.25	800.0

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

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