PREVIEW / etf_1hour / 2015-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-18.parquet
  size:    235 KB
  rows:    7,566

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-18 04:00:00	SPY	ETF	210.21	210.32	210.01	210.27	91980.0
2015-08-18 05:00:00	SPY	ETF	210.27	210.39	210.04	210.04	20354.0
2015-08-18 06:00:00	SPY	ETF	210.05	210.3	210.05	210.3	159513.0
2015-08-18 07:00:00	SPY	ETF	210.31	210.34	209.94	210.08	328137.0
2015-08-18 08:00:00	SPY	ETF	210.07	210.59	209.91	210.32	827638.0
2015-08-18 09:00:00	SPY	ETF	210.33	210.43	209.945	210.19	9044167.0
2015-08-18 10:00:00	SPY	ETF	210.205	210.68	210.03	210.62	9486156.0
2015-08-18 11:00:00	SPY	ETF	210.62	210.64	209.96	210.14	7909299.0
2015-08-18 12:00:00	SPY	ETF	210.15	210.31	209.95	209.98	5974617.0
2015-08-18 13:00:00	SPY	ETF	209.975	210.03	209.699	209.894	8537112.0
2015-08-18 14:00:00	SPY	ETF	209.89	210.15	209.72	209.751	6673374.0
2015-08-18 15:00:00	SPY	ETF	209.76	210.09	209.75	209.97	14730560.0
2015-08-18 16:00:00	SPY	ETF	209.96	210.3744	209.8819	209.96	4556129.0
2015-08-18 17:00:00	SPY	ETF	209.96	210.01	209.95	210.01	22316.0
2015-08-18 18:00:00	SPY	ETF	209.98	210.05	209.98	210.0	11575.0
2015-08-18 19:00:00	SPY	ETF	210.0	210.05	209.96	209.98	14818.0
2015-08-18 04:00:00	QQQ	ETF	111.2	111.24	111.06	111.24	33100.0
2015-08-18 05:00:00	QQQ	ETF	111.29	111.29	111.29	111.29	5000.0
2015-08-18 06:00:00	QQQ	ETF	111.19	111.19	111.14	111.18	8350.0
2015-08-18 07:00:00	QQQ	ETF	111.23	111.23	111.05	111.1	12949.0
2015-08-18 08:00:00	QQQ	ETF	111.1	111.29	111.03	111.28	98748.0
2015-08-18 09:00:00	QQQ	ETF	111.27	111.3	110.91	111.07	3067412.0
2015-08-18 10:00:00	QQQ	ETF	111.08	111.37	110.95	111.345	2208444.0
2015-08-18 11:00:00	QQQ	ETF	111.34	111.36	110.98	111.15	1417563.0
2015-08-18 12:00:00	QQQ	ETF	111.15	111.25	110.97	110.99	775231.0
2015-08-18 13:00:00	QQQ	ETF	110.98	111.05	110.71	110.86	1327406.0
2015-08-18 14:00:00	QQQ	ETF	110.86	111.03	110.74	110.78	1322803.0
2015-08-18 15:00:00	QQQ	ETF	110.78	110.91	110.73	110.87	2632111.0
2015-08-18 16:00:00	QQQ	ETF	110.88	110.98	110.81	110.9	579012.0
2015-08-18 17:00:00	QQQ	ETF	110.91	110.93	110.91	110.93	11853.0
2015-08-18 18:00:00	QQQ	ETF	110.92	110.94	110.92	110.93	7003.0
2015-08-18 19:00:00	QQQ	ETF	110.93	110.93	110.9	110.9	3000.0
2015-08-18 05:00:00	IWM	ETF	121.53	121.53	121.53	121.53	100.0
2015-08-18 07:00:00	IWM	ETF	121.4	121.4	121.34	121.34	27850.0
2015-08-18 08:00:00	IWM	ETF	121.38	121.43	121.2	121.43	187494.0
2015-08-18 09:00:00	IWM	ETF	121.44	121.53	121.05	121.28	3005656.0
2015-08-18 10:00:00	IWM	ETF	121.285	121.45	120.87	121.4	3176480.0
2015-08-18 11:00:00	IWM	ETF	121.38	121.43	120.8	121.01	3823774.0
2015-08-18 12:00:00	IWM	ETF	121.01	121.13	120.71	120.72	1570252.0
2015-08-18 13:00:00	IWM	ETF	120.71	120.84	120.58	120.67	1487997.0
2015-08-18 14:00:00	IWM	ETF	120.66	120.86	120.52	120.7	2446505.0
2015-08-18 15:00:00	IWM	ETF	120.7	120.87	120.53	120.68	4345570.0
2015-08-18 16:00:00	IWM	ETF	120.69	120.73	120.54	120.57	741437.0
2015-08-18 07:00:00	DIA	ETF	175.18	175.18	175.18	175.18	100.0
2015-08-18 08:00:00	DIA	ETF	175.2	175.34	175.02	175.29	9600.0
2015-08-18 09:00:00	DIA	ETF	175.36	175.54	175.08	175.37	665100.0
2015-08-18 10:00:00	DIA	ETF	175.42	175.93	175.26	175.865	797683.0
2015-08-18 11:00:00	DIA	ETF	175.87	175.88	175.32	175.49	404682.0
2015-08-18 12:00:00	DIA	ETF	175.49	175.66	175.36	175.37	256777.0
2015-08-18 13:00:00	DIA	ETF	175.36	175.39	175.15	175.36	371143.0

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

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