PREVIEW / etf_1hour / 2015-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-30.parquet
  size:    236 KB
  rows:    7,547

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-07-30 04:00:00	SPY	ETF	210.39	210.41	210.22	210.41	4345.0
2015-07-30 05:00:00	SPY	ETF	210.47	210.78	210.42	210.74	22235.0
2015-07-30 06:00:00	SPY	ETF	210.73	210.96	210.73	210.82	66839.0
2015-07-30 07:00:00	SPY	ETF	210.83	210.9	210.6	210.7	67708.0
2015-07-30 08:00:00	SPY	ETF	210.643	210.65	209.99	210.17	1034862.0
2015-07-30 09:00:00	SPY	ETF	210.16	210.47	209.42	209.58	12050222.0
2015-07-30 10:00:00	SPY	ETF	209.58	210.32	209.45	209.81	15517289.0
2015-07-30 11:00:00	SPY	ETF	209.8	210.68	209.62	210.56	13341334.0
2015-07-30 12:00:00	SPY	ETF	210.55	210.82	210.455	210.81	6114477.0
2015-07-30 13:00:00	SPY	ETF	210.81	210.91	210.51	210.617	7813633.0
2015-07-30 14:00:00	SPY	ETF	210.62	210.88	210.5301	210.855	7122777.0
2015-07-30 15:00:00	SPY	ETF	210.86	211.02	210.77	210.79	18632449.0
2015-07-30 16:00:00	SPY	ETF	210.79	211.03	210.76	210.94	3666779.0
2015-07-30 17:00:00	SPY	ETF	210.93	210.95	210.6773	210.81	157293.0
2015-07-30 18:00:00	SPY	ETF	210.8	210.82	210.75	210.82	39893.0
2015-07-30 19:00:00	SPY	ETF	210.8	210.82	210.77	210.82	26334.0
2015-07-30 05:00:00	QQQ	ETF	111.4	111.61	111.4	111.61	1000.0
2015-07-30 06:00:00	QQQ	ETF	111.64	111.69	111.61	111.61	1900.0
2015-07-30 07:00:00	QQQ	ETF	111.67	111.67	111.55	111.56	6000.0
2015-07-30 08:00:00	QQQ	ETF	111.55	111.55	111.26	111.35	102984.0
2015-07-30 09:00:00	QQQ	ETF	111.3	111.48	110.71	110.73	3373781.0
2015-07-30 10:00:00	QQQ	ETF	110.72	111.27	110.621	111.04	3181359.0
2015-07-30 11:00:00	QQQ	ETF	111.03	111.77	110.91	111.74	3023411.0
2015-07-30 12:00:00	QQQ	ETF	111.76	112.1	111.67	112.1	2185209.0
2015-07-30 13:00:00	QQQ	ETF	112.1	112.25	111.99	112.03	2262056.0
2015-07-30 14:00:00	QQQ	ETF	112.03	112.22	112.02	112.16	1509482.0
2015-07-30 15:00:00	QQQ	ETF	112.16	112.2663	112.07	112.09	4066875.0
2015-07-30 16:00:00	QQQ	ETF	112.06	112.21	112.03	112.18	580791.0
2015-07-30 17:00:00	QQQ	ETF	112.15	112.15	112.09	112.09	13150.0
2015-07-30 18:00:00	QQQ	ETF	112.08	112.08	112.01	112.03	25732.0
2015-07-30 19:00:00	QQQ	ETF	112.04	112.05	112.01	112.05	29900.0
2015-07-30 07:00:00	IWM	ETF	121.74	121.74	121.72	121.72	2700.0
2015-07-30 08:00:00	IWM	ETF	121.68	121.68	121.28	121.47	168965.0
2015-07-30 09:00:00	IWM	ETF	121.41	121.75	121.01	121.26	4315565.0
2015-07-30 10:00:00	IWM	ETF	121.27	121.98	121.2	121.58	3640498.0
2015-07-30 11:00:00	IWM	ETF	121.58	122.32	121.43	122.2	2544495.0
2015-07-30 12:00:00	IWM	ETF	122.19	122.33	122.05	122.3	1660471.0
2015-07-30 13:00:00	IWM	ETF	122.3	122.44	122.1	122.12	1680353.0
2015-07-30 14:00:00	IWM	ETF	122.12	122.31	122.03	122.27	1986102.0
2015-07-30 15:00:00	IWM	ETF	122.266	122.4	122.15	122.3	2592771.0
2015-07-30 16:00:00	IWM	ETF	122.3	122.42	122.18	122.28	973094.0
2015-07-30 17:00:00	IWM	ETF	122.27	122.29	122.16	122.16	1548662.0
2015-07-30 18:00:00	IWM	ETF	122.12	122.16	122.12	122.16	2100.0
2015-07-30 19:00:00	IWM	ETF	122.08	122.16	122.08	122.16	1190.0
2015-07-30 06:00:00	DIA	ETF	177.4	177.4	177.4	177.4	100.0
2015-07-30 07:00:00	DIA	ETF	177.45	177.45	177.31	177.31	200.0
2015-07-30 08:00:00	DIA	ETF	176.94	177.01	176.94	177.0	1600.0
2015-07-30 09:00:00	DIA	ETF	176.99	177.1	176.13	176.26	842146.0
2015-07-30 10:00:00	DIA	ETF	176.27	176.86	176.19	176.53	639762.0
2015-07-30 11:00:00	DIA	ETF	176.52	177.2	176.37	177.1	583279.0

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

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