PREVIEW / etf_1hour / 2016-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-23.parquet
  size:    243 KB
  rows:    7,815

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-05-23 04:00:00	SPY	ETF	205.4	206.12	205.25	205.99	19358.0
2016-05-23 05:00:00	SPY	ETF	206.0	206.0	205.23	205.29	8934.0
2016-05-23 06:00:00	SPY	ETF	205.25	205.3	205.07	205.21	4603.0
2016-05-23 07:00:00	SPY	ETF	205.25	205.75	205.13	205.6	238205.0
2016-05-23 08:00:00	SPY	ETF	205.6	205.69	204.861	205.34	550027.0
2016-05-23 09:00:00	SPY	ETF	205.33	205.69	205.2	205.43	7801446.0
2016-05-23 10:00:00	SPY	ETF	205.44	205.84	205.29	205.4	11459403.0
2016-05-23 11:00:00	SPY	ETF	205.4	205.71	205.1401	205.23	6745450.0
2016-05-23 12:00:00	SPY	ETF	205.24	205.57	205.19	205.56	5047468.0
2016-05-23 13:00:00	SPY	ETF	205.57	205.68	205.405	205.53	4147042.0
2016-05-23 14:00:00	SPY	ETF	205.53	205.74	205.47	205.5299	4306791.0
2016-05-23 15:00:00	SPY	ETF	205.52	205.61	204.985	205.15	12199366.0
2016-05-23 16:00:00	SPY	ETF	205.14	205.4449	204.96	205.07	5155561.0
2016-05-23 17:00:00	SPY	ETF	205.06	205.08	205.02	205.05	55322.0
2016-05-23 18:00:00	SPY	ETF	205.04	205.12	205.02	205.11	50816.0
2016-05-23 19:00:00	SPY	ETF	205.11	205.13	205.07	205.11	37257.0
2016-05-23 04:00:00	QQQ	ETF	106.3	106.85	106.3	106.79	4700.0
2016-05-23 05:00:00	QQQ	ETF	106.79	106.79	106.66	106.66	3200.0
2016-05-23 06:00:00	QQQ	ETF	106.34	106.4	106.29	106.38	8503.0
2016-05-23 07:00:00	QQQ	ETF	106.37	106.7	106.36	106.66	10969.0
2016-05-23 08:00:00	QQQ	ETF	106.63	106.64	106.4	106.48	46313.0
2016-05-23 09:00:00	QQQ	ETF	106.49	106.94	106.46	106.81	3229708.0
2016-05-23 10:00:00	QQQ	ETF	106.81	106.97	106.62	106.68	2563599.0
2016-05-23 11:00:00	QQQ	ETF	106.68	106.86	106.5	106.56	1118921.0
2016-05-23 12:00:00	QQQ	ETF	106.565	106.7366	106.53	106.71	815184.0
2016-05-23 13:00:00	QQQ	ETF	106.715	106.77	106.52	106.61	902387.0
2016-05-23 14:00:00	QQQ	ETF	106.62	106.74	106.55	106.58	932931.0
2016-05-23 15:00:00	QQQ	ETF	106.585	106.64	106.23	106.3	2753148.0
2016-05-23 16:00:00	QQQ	ETF	106.28	106.33	106.22	106.25	1891596.0
2016-05-23 17:00:00	QQQ	ETF	106.32	106.32	106.23	106.24	4843.0
2016-05-23 18:00:00	QQQ	ETF	106.26	106.29	106.26	106.29	2219.0
2016-05-23 19:00:00	QQQ	ETF	106.29	106.3	106.27	106.28	5809.0
2016-05-23 04:00:00	IWM	ETF	110.83	111.0	110.83	111.0	1300.0
2016-05-23 05:00:00	IWM	ETF	111.04	111.04	110.7	110.7	2282.0
2016-05-23 06:00:00	IWM	ETF	110.63	110.65	110.63	110.65	1100.0
2016-05-23 07:00:00	IWM	ETF	110.63	110.97	110.63	110.87	25342.0
2016-05-23 08:00:00	IWM	ETF	110.74	110.85	110.74	110.75	102023.0
2016-05-23 09:00:00	IWM	ETF	110.71	111.13	110.678	111.04	4081091.0
2016-05-23 10:00:00	IWM	ETF	111.04	111.39	110.94	111.05	2439186.0
2016-05-23 11:00:00	IWM	ETF	111.04	111.275	110.5	110.56	2115066.0
2016-05-23 12:00:00	IWM	ETF	110.56	110.975	110.545	110.97	1320035.0
2016-05-23 13:00:00	IWM	ETF	110.98	111.18	110.9	111.0	1165036.0
2016-05-23 14:00:00	IWM	ETF	111.01	111.16	110.89	110.95	1025648.0
2016-05-23 15:00:00	IWM	ETF	110.94	110.99	110.57	110.63	4181566.0
2016-05-23 16:00:00	IWM	ETF	110.66	110.8203	110.46	110.48	2164285.0
2016-05-23 17:00:00	IWM	ETF	110.54	110.54	110.49	110.49	10900.0
2016-05-23 18:00:00	IWM	ETF	110.55	110.58	110.55	110.58	350.0
2016-05-23 07:00:00	DIA	ETF	174.66	174.8	174.66	174.8	745.0
2016-05-23 08:00:00	DIA	ETF	174.75	174.88	174.75	174.8	1532.0
2016-05-23 09:00:00	DIA	ETF	174.84	175.02	174.6	174.87	348823.0

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

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