PREVIEW / etf_1hour / 2015-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-13.parquet
  size:    238 KB
  rows:    7,569

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-13 04:00:00	SPY	ETF	209.39	209.56	209.01	209.54	64555.0
2015-08-13 05:00:00	SPY	ETF	209.61	209.61	209.28	209.39	25061.0
2015-08-13 06:00:00	SPY	ETF	209.44	209.73	209.44	209.69	50986.0
2015-08-13 07:00:00	SPY	ETF	209.63	209.79	209.43	209.43	229688.0
2015-08-13 08:00:00	SPY	ETF	209.43	209.68	208.85	208.86	662995.0
2015-08-13 09:00:00	SPY	ETF	208.86	209.039	208.0901	208.38	11999859.0
2015-08-13 10:00:00	SPY	ETF	208.38	208.93	208.01	208.6	13072162.0
2015-08-13 11:00:00	SPY	ETF	208.57	209.04	208.2601	208.88	10158849.0
2015-08-13 12:00:00	SPY	ETF	208.89	209.4	208.89	209.305	8711531.0
2015-08-13 13:00:00	SPY	ETF	209.295	209.55	209.04	209.185	7394780.0
2015-08-13 14:00:00	SPY	ETF	209.19	209.5	209.1	209.44	8943498.0
2015-08-13 15:00:00	SPY	ETF	209.445	209.48	208.4	208.63	23383486.0
2015-08-13 16:00:00	SPY	ETF	208.62	208.79	208.6	208.74	2812939.0
2015-08-13 17:00:00	SPY	ETF	208.74	208.8078	208.6	208.6	171704.0
2015-08-13 18:00:00	SPY	ETF	208.66	208.66	208.53	208.53	160363.0
2015-08-13 19:00:00	SPY	ETF	208.54	208.57	208.48	208.54	39164.0
2015-08-13 04:00:00	QQQ	ETF	111.0	111.0	110.85	110.99	78870.0
2015-08-13 05:00:00	QQQ	ETF	110.85	110.85	110.85	110.85	5000.0
2015-08-13 06:00:00	QQQ	ETF	111.05	111.05	110.9	111.01	8350.0
2015-08-13 07:00:00	QQQ	ETF	111.09	111.11	111.0	111.01	41875.0
2015-08-13 08:00:00	QQQ	ETF	111.01	111.1	110.69	110.69	90301.0
2015-08-13 09:00:00	QQQ	ETF	110.68	110.94	110.19	110.34	5057215.0
2015-08-13 10:00:00	QQQ	ETF	110.3	110.814	110.1	110.5	3382088.0
2015-08-13 11:00:00	QQQ	ETF	110.5	110.87	110.31	110.725	1817461.0
2015-08-13 12:00:00	QQQ	ETF	110.73	111.08	110.73	110.962	2000577.0
2015-08-13 13:00:00	QQQ	ETF	110.965	111.16	110.82	110.894	1843079.0
2015-08-13 14:00:00	QQQ	ETF	110.9	111.08	110.83	111.06	1289102.0
2015-08-13 15:00:00	QQQ	ETF	111.06	111.08	110.22	110.29	5700254.0
2015-08-13 16:00:00	QQQ	ETF	110.3	110.36	110.26	110.33	417611.0
2015-08-13 17:00:00	QQQ	ETF	110.32	110.34	110.24	110.34	11462.0
2015-08-13 18:00:00	QQQ	ETF	110.24	110.32	110.21	110.25	2630.0
2015-08-13 19:00:00	QQQ	ETF	110.21	110.21	110.2	110.2	900.0
2015-08-13 04:00:00	IWM	ETF	120.38	120.41	120.38	120.41	200.0
2015-08-13 06:00:00	IWM	ETF	120.55	120.65	120.55	120.63	11400.0
2015-08-13 07:00:00	IWM	ETF	120.56	120.56	120.54	120.54	1100.0
2015-08-13 08:00:00	IWM	ETF	120.48	120.51	119.98	120.09	95783.0
2015-08-13 09:00:00	IWM	ETF	120.05	120.31	119.48	119.69	3324041.0
2015-08-13 10:00:00	IWM	ETF	119.67	120.28	119.39	119.99	3613376.0
2015-08-13 11:00:00	IWM	ETF	119.995	120.15	119.72	120.04	3013700.0
2015-08-13 12:00:00	IWM	ETF	120.04	120.5	120.04	120.36	1957856.0
2015-08-13 13:00:00	IWM	ETF	120.36	120.59	120.14	120.24	1984134.0
2015-08-13 14:00:00	IWM	ETF	120.25	120.38	120.16	120.305	1360719.0
2015-08-13 15:00:00	IWM	ETF	120.29	120.32	119.48	119.61	6997650.0
2015-08-13 16:00:00	IWM	ETF	119.6	120.28	119.5	119.54	735531.0
2015-08-13 17:00:00	IWM	ETF	119.53	119.53	119.46	119.48	4126.0
2015-08-13 06:00:00	DIA	ETF	174.78	174.78	174.78	174.78	100.0
2015-08-13 07:00:00	DIA	ETF	174.9	174.9	174.9	174.9	100.0
2015-08-13 08:00:00	DIA	ETF	174.63	174.64	174.1	174.1	6400.0
2015-08-13 09:00:00	DIA	ETF	174.1	174.32	173.59	173.9	1084833.0
2015-08-13 10:00:00	DIA	ETF	173.86	174.35	173.55	174.09	872560.0

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

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