PREVIEW / etf_1hour / 2015-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-31.parquet
  size:    239 KB
  rows:    7,639

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-31 04:00:00	SPY	ETF	210.92	211.15	210.88	211.06	8080.0
2015-07-31 05:00:00	SPY	ETF	210.98	211.03	210.66	210.72	42837.0
2015-07-31 06:00:00	SPY	ETF	210.72	210.85	210.69	210.74	35384.0
2015-07-31 07:00:00	SPY	ETF	210.75	210.75	210.52	210.63	147191.0
2015-07-31 08:00:00	SPY	ETF	210.6	211.39	210.39	211.32	2067837.0
2015-07-31 09:00:00	SPY	ETF	211.33	211.52	210.51	210.62	11492415.0
2015-07-31 10:00:00	SPY	ETF	210.615	211.34	210.54	211.21	12369695.0
2015-07-31 11:00:00	SPY	ETF	211.2	211.33	211.01	211.19	7423107.0
2015-07-31 12:00:00	SPY	ETF	211.19	211.38	211.02	211.065	6963520.0
2015-07-31 13:00:00	SPY	ETF	211.06	211.18	210.6	210.6601	6858208.0
2015-07-31 14:00:00	SPY	ETF	210.67	210.83	210.29	210.54	15478273.0
2015-07-31 15:00:00	SPY	ETF	210.54	210.645	210.16	210.47	27411608.0
2015-07-31 16:00:00	SPY	ETF	210.47	210.8026	210.3629	210.64	10686943.0
2015-07-31 17:00:00	SPY	ETF	210.65	210.68	210.41	210.54	701283.0
2015-07-31 18:00:00	SPY	ETF	210.5	210.58	210.43	210.46	41705.0
2015-07-31 19:00:00	SPY	ETF	210.46	210.5	210.42	210.45	41857.0
2015-07-31 04:00:00	QQQ	ETF	112.15	112.24	112.15	112.24	3500.0
2015-07-31 06:00:00	QQQ	ETF	112.14	112.14	112.14	112.14	500.0
2015-07-31 07:00:00	QQQ	ETF	111.87	112.03	111.84	112.02	13300.0
2015-07-31 08:00:00	QQQ	ETF	111.98	112.493	111.9	112.493	370736.0
2015-07-31 09:00:00	QQQ	ETF	112.49	112.49	111.91	111.92	3562824.0
2015-07-31 10:00:00	QQQ	ETF	111.92	112.45	111.87	112.39	3346639.0
2015-07-31 11:00:00	QQQ	ETF	112.38	112.385	112.13	112.22	1693470.0
2015-07-31 12:00:00	QQQ	ETF	112.23	112.3767	112.169	112.169	1499836.0
2015-07-31 13:00:00	QQQ	ETF	112.16	112.225	111.91	111.95	1458453.0
2015-07-31 14:00:00	QQQ	ETF	111.96	112.065	111.755	111.87	2558362.0
2015-07-31 15:00:00	QQQ	ETF	111.88	111.97	111.72	111.95	5067308.0
2015-07-31 16:00:00	QQQ	ETF	111.95	112.04	111.86	111.92	929009.0
2015-07-31 17:00:00	QQQ	ETF	111.93	111.95	111.88	111.9	413150.0
2015-07-31 18:00:00	QQQ	ETF	111.93	111.96	111.89	111.89	5190.0
2015-07-31 19:00:00	QQQ	ETF	111.94	111.94	111.88	111.88	2971.0
2015-07-31 07:00:00	IWM	ETF	121.84	121.87	121.84	121.87	400.0
2015-07-31 08:00:00	IWM	ETF	122.02	122.25	121.87	122.18	13567.0
2015-07-31 09:00:00	IWM	ETF	122.28	122.95	122.19	122.8	3456149.0
2015-07-31 10:00:00	IWM	ETF	122.83	123.59	122.74	123.51	5084861.0
2015-07-31 11:00:00	IWM	ETF	123.5	123.65	123.32	123.455	2522067.0
2015-07-31 12:00:00	IWM	ETF	123.46	123.67	123.43	123.45	1245188.0
2015-07-31 13:00:00	IWM	ETF	123.44	123.56	123.12	123.14	2372759.0
2015-07-31 14:00:00	IWM	ETF	123.14	123.31	123.04	123.18	2432701.0
2015-07-31 15:00:00	IWM	ETF	123.17	123.21	122.53	122.97	8112446.0
2015-07-31 16:00:00	IWM	ETF	122.96	123.15	122.88	123.01	3817053.0
2015-07-31 17:00:00	IWM	ETF	122.97	123.02	122.94	123.0	69727.0
2015-07-31 18:00:00	IWM	ETF	123.0	123.0	122.62	122.62	700.0
2015-07-31 07:00:00	DIA	ETF	177.1	177.19	177.1	177.19	600.0
2015-07-31 08:00:00	DIA	ETF	177.04	177.4	177.04	177.4	11299.0
2015-07-31 09:00:00	DIA	ETF	177.58	177.74	176.53	176.67	760228.0
2015-07-31 10:00:00	DIA	ETF	176.66	177.44	176.66	177.32	518346.0
2015-07-31 11:00:00	DIA	ETF	177.31	177.43	177.2	177.32	288009.0
2015-07-31 12:00:00	DIA	ETF	177.33	177.5	177.18	177.21	323623.0
2015-07-31 13:00:00	DIA	ETF	177.2	177.31	176.81	176.86	445739.0

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

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