PREVIEW / etf_1hour / 2016-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-03.parquet
  size:    250 KB
  rows:    8,008

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
2016-08-03 04:00:00	SPY	ETF	215.3	215.33	215.05	215.2	46740.0
2016-08-03 05:00:00	SPY	ETF	215.2	215.36	215.1	215.32	53065.0
2016-08-03 06:00:00	SPY	ETF	215.27	215.33	215.23	215.24	75495.0
2016-08-03 07:00:00	SPY	ETF	215.29	215.37	215.18	215.35	271168.0
2016-08-03 08:00:00	SPY	ETF	215.35	215.49	215.08	215.34	555751.0
2016-08-03 09:00:00	SPY	ETF	215.35	215.74	215.13	215.58	7592715.0
2016-08-03 10:00:00	SPY	ETF	215.58	215.96	215.47	215.66	9560037.0
2016-08-03 11:00:00	SPY	ETF	215.65	215.92	215.53	215.87	4645877.0
2016-08-03 12:00:00	SPY	ETF	215.86	216.04	215.76	215.95	4033884.0
2016-08-03 13:00:00	SPY	ETF	215.9501	216.04	215.76	215.86	4592479.0
2016-08-03 14:00:00	SPY	ETF	215.8611	215.94	215.57	215.73	4287883.0
2016-08-03 15:00:00	SPY	ETF	215.73	216.245	215.68	216.21	11029643.0
2016-08-03 16:00:00	SPY	ETF	216.21	216.2631	215.94	216.12	5036571.0
2016-08-03 17:00:00	SPY	ETF	216.11	216.18	215.98	216.05	1260905.0
2016-08-03 18:00:00	SPY	ETF	216.05	216.18	216.02	216.08	209770.0
2016-08-03 19:00:00	SPY	ETF	216.09	216.2628	216.09	216.23	1530911.0
2016-08-03 04:00:00	QQQ	ETF	114.81	114.81	114.69	114.7	6200.0
2016-08-03 05:00:00	QQQ	ETF	114.77	114.79	114.76	114.79	2599.0
2016-08-03 06:00:00	QQQ	ETF	114.78	114.82	114.73	114.73	3600.0
2016-08-03 07:00:00	QQQ	ETF	114.77	114.79	114.71	114.79	79488.0
2016-08-03 08:00:00	QQQ	ETF	114.79	114.96	114.73	114.79	57781.0
2016-08-03 09:00:00	QQQ	ETF	114.8	115.175	114.79	115.1	2814802.0
2016-08-03 10:00:00	QQQ	ETF	115.09	115.27	114.94	114.96	1801820.0
2016-08-03 11:00:00	QQQ	ETF	114.97	115.09	114.9	115.07	855678.0
2016-08-03 12:00:00	QQQ	ETF	115.0799	115.11	114.9	115.03	1052393.0
2016-08-03 13:00:00	QQQ	ETF	115.03	115.14	114.9901	115.07	542382.0
2016-08-03 14:00:00	QQQ	ETF	115.07	115.15	114.97	115.11	1145207.0
2016-08-03 15:00:00	QQQ	ETF	115.11	115.35	115.105	115.34	3057300.0
2016-08-03 16:00:00	QQQ	ETF	115.34	115.36	115.22	115.31	554908.0
2016-08-03 17:00:00	QQQ	ETF	115.32	115.35	115.28	115.34	24202.0
2016-08-03 18:00:00	QQQ	ETF	115.32	115.32	115.25	115.27	13031.0
2016-08-03 19:00:00	QQQ	ETF	115.29	115.36	115.27	115.34	6986.0
2016-08-03 04:00:00	IWM	ETF	119.13	119.13	119.13	119.13	109.0
2016-08-03 07:00:00	IWM	ETF	119.2	119.32	119.2	119.32	30308.0
2016-08-03 08:00:00	IWM	ETF	119.29	119.39	119.19	119.26	90271.0
2016-08-03 09:00:00	IWM	ETF	119.26	119.6043	119.1	119.47	2392640.0
2016-08-03 10:00:00	IWM	ETF	119.48	119.9	119.3	119.5752	2562439.0
2016-08-03 11:00:00	IWM	ETF	119.58	120.23	119.52	120.155	1854426.0
2016-08-03 12:00:00	IWM	ETF	120.15	120.39	120.08	120.37	1423764.0
2016-08-03 13:00:00	IWM	ETF	120.37	120.39	120.06	120.22	1592487.0
2016-08-03 14:00:00	IWM	ETF	120.225	120.35	120.0	120.09	1876707.0
2016-08-03 15:00:00	IWM	ETF	120.1	120.5	120.09	120.49	3257419.0
2016-08-03 16:00:00	IWM	ETF	120.48	120.57	120.37	120.55	1346519.0
2016-08-03 17:00:00	IWM	ETF	120.52	120.52	120.45	120.52	16013.0
2016-08-03 18:00:00	IWM	ETF	120.49	120.49	120.49	120.49	1000.0
2016-08-03 19:00:00	IWM	ETF	120.47	120.57	120.45	120.46	2183.0
2016-08-03 20:00:00	IWM	ETF	120.4596	120.4596	120.4596	120.4596	100000.0
2016-08-03 04:00:00	DIA	ETF	182.67	182.67	182.67	182.67	100.0
2016-08-03 07:00:00	DIA	ETF	182.7	182.75	182.7	182.75	3600.0
2016-08-03 08:00:00	DIA	ETF	182.67	182.83	182.67	182.83	2100.0

> showing 50 of 8,008 rows — these rows as CSV

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