PREVIEW / etf_30min / 2016-04-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-20.parquet
  size:    407 KB
  rows:    13,659

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-04-20 04:00:00	SPY	ETF	209.28	209.47	209.28	209.28	7586.0
2016-04-20 04:30:00	SPY	ETF	209.22	209.34	209.12	209.12	8942.0
2016-04-20 05:00:00	SPY	ETF	209.19	209.37	209.19	209.37	4876.0
2016-04-20 05:30:00	SPY	ETF	209.26	209.54	209.26	209.54	4273.0
2016-04-20 06:00:00	SPY	ETF	209.42	209.53	209.38	209.53	3017.0
2016-04-20 06:30:00	SPY	ETF	209.5	209.86	209.4	209.79	50430.0
2016-04-20 07:00:00	SPY	ETF	209.79	210.16	209.79	210.13	158551.0
2016-04-20 07:30:00	SPY	ETF	210.12	210.21	210.05	210.05	285054.0
2016-04-20 08:00:00	SPY	ETF	209.95	210.14	209.4	210.09	349805.0
2016-04-20 08:30:00	SPY	ETF	210.1	210.1	209.98	210.09	114963.0
2016-04-20 09:00:00	SPY	ETF	210.06	210.15	209.89	209.95	468750.0
2016-04-20 09:30:00	SPY	ETF	209.95	210.07	209.67	209.9876	6976079.0
2016-04-20 10:00:00	SPY	ETF	209.99	210.0399	209.67	209.71	4085854.0
2016-04-20 10:30:00	SPY	ETF	209.72	209.9	209.39	209.85	5518847.0
2016-04-20 11:00:00	SPY	ETF	209.85	210.39	209.77	210.31	5434667.0
2016-04-20 11:30:00	SPY	ETF	210.31	210.47	210.22	210.26	4806747.0
2016-04-20 12:00:00	SPY	ETF	210.25	210.3	210.135	210.26	4674429.0
2016-04-20 12:30:00	SPY	ETF	210.26	210.5	210.18	210.39	2557964.0
2016-04-20 13:00:00	SPY	ETF	210.39	210.495	210.22	210.405	2512357.0
2016-04-20 13:30:00	SPY	ETF	210.4099	210.69	210.386	210.57	3997899.0
2016-04-20 14:00:00	SPY	ETF	210.57	210.83	210.5	210.7	3959227.0
2016-04-20 14:30:00	SPY	ETF	210.7075	210.85	210.685	210.83	2889774.0
2016-04-20 15:00:00	SPY	ETF	210.83	210.92	210.51	210.52	6312779.0
2016-04-20 15:30:00	SPY	ETF	210.52	210.55	210.0	210.06	13558360.0
2016-04-20 16:00:00	SPY	ETF	210.07	210.25	209.99	210.17	7104803.0
2016-04-20 16:30:00	SPY	ETF	210.17	210.21	210.07	210.2	1724397.0
2016-04-20 17:00:00	SPY	ETF	210.19	210.24	210.15	210.2	548617.0
2016-04-20 17:30:00	SPY	ETF	210.22	210.24	210.1	210.16	1430620.0
2016-04-20 18:00:00	SPY	ETF	210.16	210.26	210.14	210.14	33541.0
2016-04-20 18:30:00	SPY	ETF	210.18	210.21	210.17	210.19	4671.0
2016-04-20 19:00:00	SPY	ETF	210.25	210.25	210.18	210.2	3933.0
2016-04-20 19:30:00	SPY	ETF	210.0309	210.25	210.0309	210.23	419858.0
2016-04-20 04:00:00	QQQ	ETF	110.35	110.35	110.27	110.27	250.0
2016-04-20 04:30:00	QQQ	ETF	110.17	110.24	110.11	110.11	8500.0
2016-04-20 06:00:00	QQQ	ETF	110.38	110.38	110.38	110.38	1196.0
2016-04-20 06:30:00	QQQ	ETF	110.34	110.58	110.27	110.56	50740.0
2016-04-20 07:00:00	QQQ	ETF	110.6	110.66	110.5	110.65	89197.0
2016-04-20 07:30:00	QQQ	ETF	110.63	110.71	110.59	110.59	68380.0
2016-04-20 08:00:00	QQQ	ETF	110.58	110.67	110.55	110.65	66653.0
2016-04-20 08:30:00	QQQ	ETF	110.66	110.66	110.57	110.62	48482.0
2016-04-20 09:00:00	QQQ	ETF	110.62	110.68	110.54	110.54	161780.0
2016-04-20 09:30:00	QQQ	ETF	110.54	110.864	110.17	110.72	2661023.0
2016-04-20 10:00:00	QQQ	ETF	110.72	110.82	110.48	110.525	1422138.0
2016-04-20 10:30:00	QQQ	ETF	110.53	110.65	110.32	110.64	1342370.0
2016-04-20 11:00:00	QQQ	ETF	110.64	111.09	110.56	111.03	1243354.0
2016-04-20 11:30:00	QQQ	ETF	111.05	111.1	110.92	110.935	1171802.0
2016-04-20 12:00:00	QQQ	ETF	110.94	111.005	110.83	110.92	898967.0
2016-04-20 12:30:00	QQQ	ETF	110.9267	111.06	110.875	110.92	592205.0
2016-04-20 13:00:00	QQQ	ETF	110.9201	110.98	110.79	110.895	750596.0
2016-04-20 13:30:00	QQQ	ETF	110.89	111.03	110.87	110.9399	801410.0

> showing 50 of 13,659 rows — these rows as CSV

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