PREVIEW / etf_1hour / 2015-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-28.parquet
  size:    247 KB
  rows:    7,904

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-28 04:00:00	SPY	ETF	198.29	198.6	197.63	197.88	181498.0
2015-08-28 05:00:00	SPY	ETF	197.9	198.47	197.51	198.3	214067.0
2015-08-28 06:00:00	SPY	ETF	198.21	198.43	197.64	197.65	121865.0
2015-08-28 07:00:00	SPY	ETF	197.65	198.4	197.5	198.09	861136.0
2015-08-28 08:00:00	SPY	ETF	198.11	199.8	197.7	198.29	1524592.0
2015-08-28 09:00:00	SPY	ETF	198.3	199.2	197.88	199.09	16693836.0
2015-08-28 10:00:00	SPY	ETF	199.09	199.4	198.36	198.72	21328256.0
2015-08-28 11:00:00	SPY	ETF	198.72	199.835	198.36	198.61	18810828.0
2015-08-28 12:00:00	SPY	ETF	198.6	199.23	198.4	198.91	12952796.0
2015-08-28 13:00:00	SPY	ETF	198.92	199.07	197.92	198.47	15983080.0
2015-08-28 14:00:00	SPY	ETF	198.48	199.15	198.29	199.029	13852592.0
2015-08-28 15:00:00	SPY	ETF	199.02	199.42	197.98	199.28	32951274.0
2015-08-28 16:00:00	SPY	ETF	199.29	199.78	198.806	199.39	19282117.0
2015-08-28 17:00:00	SPY	ETF	199.41	199.59	198.8205	199.54	4764946.0
2015-08-28 18:00:00	SPY	ETF	199.55	199.55	199.4	199.41	38185.0
2015-08-28 19:00:00	SPY	ETF	199.46	199.49	199.38	199.45	29629.0
2015-08-28 04:00:00	QQQ	ETF	105.25	105.25	104.8	104.8	10100.0
2015-08-28 05:00:00	QQQ	ETF	104.73	105.13	104.7	105.12	1700.0
2015-08-28 06:00:00	QQQ	ETF	105.22	105.22	104.71	104.71	5800.0
2015-08-28 07:00:00	QQQ	ETF	104.81	105.09	104.64	104.95	95000.0
2015-08-28 08:00:00	QQQ	ETF	105.0	105.21	104.8	105.05	163642.0
2015-08-28 09:00:00	QQQ	ETF	105.02	105.65	104.83	105.46	6435166.0
2015-08-28 10:00:00	QQQ	ETF	105.47	105.5	104.87	105.25	5541499.0
2015-08-28 11:00:00	QQQ	ETF	105.26	106.0	104.99	105.15	4647192.0
2015-08-28 12:00:00	QQQ	ETF	105.15	105.58	105.03	105.425	2479918.0
2015-08-28 13:00:00	QQQ	ETF	105.42	105.54	104.85	105.1	4087035.0
2015-08-28 14:00:00	QQQ	ETF	105.1	105.5901	105.03	105.5	3456173.0
2015-08-28 15:00:00	QQQ	ETF	105.5	105.72	104.96	105.65	8199437.0
2015-08-28 16:00:00	QQQ	ETF	105.64	105.87	105.51	105.62	1607472.0
2015-08-28 17:00:00	QQQ	ETF	105.62	105.74	105.6	105.68	99318.0
2015-08-28 18:00:00	QQQ	ETF	105.64	105.74	105.61	105.62	125610.0
2015-08-28 19:00:00	QQQ	ETF	105.62	105.68	105.5	105.51	37474.0
2015-08-28 04:00:00	IWM	ETF	114.37	114.37	114.29	114.29	200.0
2015-08-28 05:00:00	IWM	ETF	113.95	114.2	113.95	114.2	1400.0
2015-08-28 06:00:00	IWM	ETF	114.2	114.21	114.2	114.2	1200.0
2015-08-28 07:00:00	IWM	ETF	113.85	114.26	113.81	114.26	63060.0
2015-08-28 08:00:00	IWM	ETF	114.2	114.42	114.05	114.27	74386.0
2015-08-28 09:00:00	IWM	ETF	114.22	114.92	114.05	114.79	4515416.0
2015-08-28 10:00:00	IWM	ETF	114.78	115.125	114.38	114.87	6035337.0
2015-08-28 11:00:00	IWM	ETF	114.87	115.7	114.56	114.76	4691590.0
2015-08-28 12:00:00	IWM	ETF	114.77	115.56	114.66	115.41	2544139.0
2015-08-28 13:00:00	IWM	ETF	115.41	115.54	114.65	115.095	4186420.0
2015-08-28 14:00:00	IWM	ETF	115.09	115.58	115.07	115.4	2594747.0
2015-08-28 15:00:00	IWM	ETF	115.4	115.64	114.82	115.58	6142430.0
2015-08-28 16:00:00	IWM	ETF	115.59	115.88	115.54	115.77	3342112.0
2015-08-28 17:00:00	IWM	ETF	115.77	115.84	115.66	115.66	5962.0
2015-08-28 18:00:00	IWM	ETF	115.7	115.7	115.2	115.5	1481512.0
2015-08-28 19:00:00	IWM	ETF	115.5	115.5	115.5	115.5	300.0
2015-08-28 04:00:00	DIA	ETF	165.58	165.58	165.58	165.58	100.0
2015-08-28 05:00:00	DIA	ETF	165.2	165.2	165.2	165.2	2400.0

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

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