PREVIEW / etf_30min / 2016-12-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-22.parquet
  size:    426 KB
  rows:    14,615

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-12-22 04:00:00	SPY	ETF	225.6	225.6	225.6	225.6	3000.0
2016-12-22 04:30:00	SPY	ETF	225.55	225.74	225.55	225.74	2500.0
2016-12-22 05:30:00	SPY	ETF	225.55	225.64	225.54	225.64	2600.0
2016-12-22 06:00:00	SPY	ETF	225.64	225.64	225.59	225.59	2300.0
2016-12-22 06:30:00	SPY	ETF	225.6	225.6	225.54	225.54	1110.0
2016-12-22 07:00:00	SPY	ETF	225.54	225.6	225.5	225.5	11550.0
2016-12-22 07:30:00	SPY	ETF	225.56	225.69	225.56	225.65	12740.0
2016-12-22 08:00:00	SPY	ETF	225.65	225.82	225.53	225.81	159484.0
2016-12-22 08:30:00	SPY	ETF	225.77	225.79	225.63	225.65	108696.0
2016-12-22 09:00:00	SPY	ETF	225.65	225.7	225.59	225.59	368151.0
2016-12-22 09:30:00	SPY	ETF	225.6	225.74	225.17	225.41	6491780.0
2016-12-22 10:00:00	SPY	ETF	225.41	225.57	225.3	225.48	4328388.0
2016-12-22 10:30:00	SPY	ETF	225.48	225.61	225.26	225.27	3433790.0
2016-12-22 11:00:00	SPY	ETF	225.27	225.38	225.1	225.12	3171875.0
2016-12-22 11:30:00	SPY	ETF	225.12	225.21	224.92	225.01	2976931.0
2016-12-22 12:00:00	SPY	ETF	225.0	225.11	224.97	225.0971	2105164.0
2016-12-22 12:30:00	SPY	ETF	225.1	225.265	225.08	225.19	1759557.0
2016-12-22 13:00:00	SPY	ETF	225.1973	225.27	225.13	225.19	2566355.0
2016-12-22 13:30:00	SPY	ETF	225.1938	225.54	225.13	225.44	2039342.0
2016-12-22 14:00:00	SPY	ETF	225.45	225.53	225.42	225.43	2227750.0
2016-12-22 14:30:00	SPY	ETF	225.43	225.44	225.32	225.41	2295590.0
2016-12-22 15:00:00	SPY	ETF	225.41	225.43	225.05	225.165	3158713.0
2016-12-22 15:30:00	SPY	ETF	225.165	225.46	225.06	225.43	7830873.0
2016-12-22 16:00:00	SPY	ETF	225.44	225.63	225.38	225.6	8305980.0
2016-12-22 16:30:00	SPY	ETF	225.6	225.6	225.3	225.56	178661.0
2016-12-22 17:00:00	SPY	ETF	225.2789	225.54	225.2789	225.5	20172.0
2016-12-22 17:30:00	SPY	ETF	225.5	225.5	225.47	225.5	13654.0
2016-12-22 18:00:00	SPY	ETF	225.5	225.63	225.38	225.6	216892.0
2016-12-22 18:30:00	SPY	ETF	225.57	225.6	225.55	225.58	4629.0
2016-12-22 19:00:00	SPY	ETF	225.59	225.6	225.4119	225.54	927903.0
2016-12-22 19:30:00	SPY	ETF	225.54	225.57	225.52	225.57	13200.0
2016-12-22 04:00:00	QQQ	ETF	120.29	120.29	120.29	120.29	200.0
2016-12-22 04:30:00	QQQ	ETF	120.29	120.29	120.29	120.29	200.0
2016-12-22 05:00:00	QQQ	ETF	120.27	120.27	120.26	120.26	666.0
2016-12-22 06:00:00	QQQ	ETF	120.32	120.32	120.3	120.3	400.0
2016-12-22 06:30:00	QQQ	ETF	120.3	120.31	120.3	120.31	2200.0
2016-12-22 07:00:00	QQQ	ETF	120.31	120.31	120.31	120.31	1000.0
2016-12-22 07:30:00	QQQ	ETF	120.31	120.4	120.31	120.38	8400.0
2016-12-22 08:00:00	QQQ	ETF	120.36	120.52	120.36	120.5	87870.0
2016-12-22 08:30:00	QQQ	ETF	120.52	120.52	120.41	120.43	49792.0
2016-12-22 09:00:00	QQQ	ETF	120.43	120.52	120.43	120.47	129886.0
2016-12-22 09:30:00	QQQ	ETF	120.47	120.5	119.92	120.21	1417669.0
2016-12-22 10:00:00	QQQ	ETF	120.215	120.33	120.15	120.25	877330.0
2016-12-22 10:30:00	QQQ	ETF	120.24	120.291	120.01	120.0353	479925.0
2016-12-22 11:00:00	QQQ	ETF	120.0375	120.15	119.93	119.93	1234422.0
2016-12-22 11:30:00	QQQ	ETF	119.94	120.01	119.65	119.7625	3440281.0
2016-12-22 12:00:00	QQQ	ETF	119.76	119.83	119.72	119.82	1630467.0
2016-12-22 12:30:00	QQQ	ETF	119.82	119.89	119.79	119.8305	546337.0
2016-12-22 13:00:00	QQQ	ETF	119.8332	119.95	119.8	119.89	331844.0
2016-12-22 13:30:00	QQQ	ETF	119.89	120.1115	119.8566	120.025	518038.0

> showing 50 of 14,615 rows — these rows as CSV

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