PREVIEW / etf_30min / 2016-06-24

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-24.parquet
  size:    458 KB
  rows:    15,668

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-06-24 04:00:00	SPY	ETF	204.6	204.79	203.67	204.6	185092.0
2016-06-24 04:30:00	SPY	ETF	204.55	204.55	203.33	203.33	196885.0
2016-06-24 05:00:00	SPY	ETF	203.33	204.29	203.27	204.25	341045.0
2016-06-24 05:30:00	SPY	ETF	204.2	204.35	203.3	203.52	182111.0
2016-06-24 06:00:00	SPY	ETF	203.59	203.75	202.8	203.38	483151.0
2016-06-24 06:30:00	SPY	ETF	203.4	203.46	202.09	203.17	1347187.0
2016-06-24 07:00:00	SPY	ETF	203.14	203.4	202.71	203.0	1163165.0
2016-06-24 07:30:00	SPY	ETF	203.01	203.77	202.98	203.09	1563992.0
2016-06-24 08:00:00	SPY	ETF	203.09	209.85	200.25	204.15	4197869.0
2016-06-24 08:30:00	SPY	ETF	204.14	204.55	203.71	203.8	3045412.0
2016-06-24 09:00:00	SPY	ETF	203.8	203.99	203.12	203.63	3763067.0
2016-06-24 09:30:00	SPY	ETF	203.63	206.199	203.38	205.9999	51290887.0
2016-06-24 10:00:00	SPY	ETF	205.99	206.905	205.59	205.94	35662054.0
2016-06-24 10:30:00	SPY	ETF	205.945	206.25	205.5	205.53	17651684.0
2016-06-24 11:00:00	SPY	ETF	205.53	210.8463	204.76	205.215	22602687.0
2016-06-24 11:30:00	SPY	ETF	205.2	205.68	205.01	205.33	13167198.0
2016-06-24 12:00:00	SPY	ETF	205.3397	205.46	204.55	204.885	13295983.0
2016-06-24 12:30:00	SPY	ETF	204.88	204.98	204.08	204.28	12110438.0
2016-06-24 13:00:00	SPY	ETF	204.28	204.58	204.08	204.4701	10175329.0
2016-06-24 13:30:00	SPY	ETF	204.47	204.96	204.37	204.61	11176625.0
2016-06-24 14:00:00	SPY	ETF	204.61	205.95	204.0	204.05	10997383.0
2016-06-24 14:30:00	SPY	ETF	204.041	204.32	203.48	203.95	18620557.0
2016-06-24 15:00:00	SPY	ETF	203.95	204.15	202.72	203.07	25033176.0
2016-06-24 15:30:00	SPY	ETF	203.07	204.45	203.0	203.22	43885511.0
2016-06-24 16:00:00	SPY	ETF	203.25	203.35	202.17	202.75	17436792.0
2016-06-24 16:30:00	SPY	ETF	202.75	203.2731	202.18	202.37	5607503.0
2016-06-24 17:00:00	SPY	ETF	202.35	202.64	202.35	202.5	688547.0
2016-06-24 17:30:00	SPY	ETF	202.47	203.13	202.38	202.44	421129.0
2016-06-24 18:00:00	SPY	ETF	202.44	202.44	202.31	202.39	75428.0
2016-06-24 18:30:00	SPY	ETF	202.4	202.4	202.16	202.2	83607.0
2016-06-24 19:00:00	SPY	ETF	202.2	202.27	202.03	202.03	86672.0
2016-06-24 19:30:00	SPY	ETF	202.05	202.12	201.95	202.0	103452.0
2016-06-24 04:00:00	QQQ	ETF	105.6	105.6	105.14	105.54	12112.0
2016-06-24 04:30:00	QQQ	ETF	105.45	105.49	104.98	104.98	59231.0
2016-06-24 05:00:00	QQQ	ETF	104.97	105.35	104.91	105.22	19229.0
2016-06-24 05:30:00	QQQ	ETF	105.32	105.34	104.99	105.11	18018.0
2016-06-24 06:00:00	QQQ	ETF	105.1	105.12	104.7	104.93	54200.0
2016-06-24 06:30:00	QQQ	ETF	104.91	104.91	104.32	104.82	223250.0
2016-06-24 07:00:00	QQQ	ETF	104.82	104.98	104.65	104.79	345026.0
2016-06-24 07:30:00	QQQ	ETF	104.77	105.12	104.77	104.83	262628.0
2016-06-24 08:00:00	QQQ	ETF	104.84	105.25	104.6	105.22	517104.0
2016-06-24 08:30:00	QQQ	ETF	105.19	105.36	105.0	105.06	708596.0
2016-06-24 09:00:00	QQQ	ETF	105.08	105.13	104.76	104.79	991712.0
2016-06-24 09:30:00	QQQ	ETF	104.81	106.22	104.54	106.09	9937129.0
2016-06-24 10:00:00	QQQ	ETF	106.08	106.5	105.69	105.87	6173814.0
2016-06-24 10:30:00	QQQ	ETF	105.87	106.06	105.58	105.6	3143176.0
2016-06-24 11:00:00	QQQ	ETF	105.6	105.67	105.2	105.47	3820246.0
2016-06-24 11:30:00	QQQ	ETF	105.45	105.69	105.32	105.5	2010225.0
2016-06-24 12:00:00	QQQ	ETF	105.51	105.56	105.05	105.13	2289114.0
2016-06-24 12:30:00	QQQ	ETF	105.12	105.16	104.66	104.77	3384531.0

> showing 50 of 15,668 rows — these rows as CSV

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