PREVIEW / etf_30min / 2016-05-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-19.parquet
  size:    393 KB
  rows:    13,452

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-05-19 04:00:00	SPY	ETF	204.31	204.51	204.16	204.16	13614.0
2016-05-19 04:30:00	SPY	ETF	204.1	204.21	203.85	203.92	9469.0
2016-05-19 05:00:00	SPY	ETF	204.0	204.01	203.95	203.95	823.0
2016-05-19 05:30:00	SPY	ETF	203.91	203.99	203.87	203.99	3605.0
2016-05-19 06:00:00	SPY	ETF	203.95	204.27	203.95	203.99	20242.0
2016-05-19 06:30:00	SPY	ETF	204.0	204.12	203.99	204.04	48229.0
2016-05-19 07:00:00	SPY	ETF	204.03	204.39	204.02	204.3	205871.0
2016-05-19 07:30:00	SPY	ETF	204.27	204.64	204.25	204.42	120620.0
2016-05-19 08:00:00	SPY	ETF	204.21	204.49	203.86	204.4	432897.0
2016-05-19 08:30:00	SPY	ETF	204.35	204.35	204.12	204.18	415099.0
2016-05-19 09:00:00	SPY	ETF	204.18	204.24	204.01	204.04	826494.0
2016-05-19 09:30:00	SPY	ETF	204.06	204.54	203.11	203.1261	13671157.0
2016-05-19 10:00:00	SPY	ETF	203.12	203.46	202.94	203.44	14017142.0
2016-05-19 10:30:00	SPY	ETF	203.44	203.72	203.02	203.0507	11052545.0
2016-05-19 11:00:00	SPY	ETF	203.06	203.38	202.78	203.15	11924887.0
2016-05-19 11:30:00	SPY	ETF	203.1515	203.36	202.8108	203.26	7728497.0
2016-05-19 12:00:00	SPY	ETF	203.26	203.63	203.16	203.3389	5635345.0
2016-05-19 12:30:00	SPY	ETF	203.337	203.47	203.02	203.045	4212373.0
2016-05-19 13:00:00	SPY	ETF	203.05	203.55	203.03	203.55	3334371.0
2016-05-19 13:30:00	SPY	ETF	203.55	203.97	203.53	203.64	6084005.0
2016-05-19 14:00:00	SPY	ETF	203.65	204.1801	203.62	204.12	5877704.0
2016-05-19 14:30:00	SPY	ETF	204.13	204.15	203.545	203.6	4592363.0
2016-05-19 15:00:00	SPY	ETF	203.6	204.4	203.59	204.15	7044486.0
2016-05-19 15:30:00	SPY	ETF	204.15	204.41	203.98	204.22	11098404.0
2016-05-19 16:00:00	SPY	ETF	204.23	204.45	204.16	204.42	3059552.0
2016-05-19 16:30:00	SPY	ETF	204.41	204.9834	204.33	204.43	876617.0
2016-05-19 17:00:00	SPY	ETF	204.43	204.45	204.38	204.38	49886.0
2016-05-19 17:30:00	SPY	ETF	204.39	204.49	204.37	204.46	71054.0
2016-05-19 18:00:00	SPY	ETF	204.46	204.49	204.37	204.42	110283.0
2016-05-19 18:30:00	SPY	ETF	204.44	204.47	204.44	204.45	6312.0
2016-05-19 19:00:00	SPY	ETF	204.45	204.53	204.44	204.47	25380.0
2016-05-19 19:30:00	SPY	ETF	204.49	204.5	204.32	204.37	76850.0
2016-05-19 04:00:00	QQQ	ETF	105.73	105.73	105.73	105.73	100.0
2016-05-19 04:30:00	QQQ	ETF	105.5	105.5	105.4	105.4	600.0
2016-05-19 05:00:00	QQQ	ETF	105.42	105.42	105.4	105.4	848.0
2016-05-19 05:30:00	QQQ	ETF	105.36	105.36	105.36	105.36	200.0
2016-05-19 06:00:00	QQQ	ETF	105.56	105.56	105.56	105.56	200.0
2016-05-19 06:30:00	QQQ	ETF	105.37	105.37	105.37	105.37	100.0
2016-05-19 07:00:00	QQQ	ETF	105.56	105.56	105.56	105.56	1999.0
2016-05-19 07:30:00	QQQ	ETF	105.69	105.7	105.64	105.64	12083.0
2016-05-19 08:00:00	QQQ	ETF	105.61	105.65	105.57	105.57	11246.0
2016-05-19 08:30:00	QQQ	ETF	105.54	105.56	105.42	105.44	38341.0
2016-05-19 09:00:00	QQQ	ETF	105.44	105.48	105.38	105.43	114722.0
2016-05-19 09:30:00	QQQ	ETF	105.45	105.705	104.93	104.94	3259411.0
2016-05-19 10:00:00	QQQ	ETF	104.935	105.05	104.75	105.01	2598553.0
2016-05-19 10:30:00	QQQ	ETF	105.01	105.09	104.771	104.8	1761756.0
2016-05-19 11:00:00	QQQ	ETF	104.805	104.925	104.66	104.785	1873643.0
2016-05-19 11:30:00	QQQ	ETF	104.81	104.815	104.54	104.77	1107813.0
2016-05-19 12:00:00	QQQ	ETF	104.77	104.99	104.72	104.76	1116823.0
2016-05-19 12:30:00	QQQ	ETF	104.77	104.83	104.61	104.66	728209.0

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

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