PREVIEW / etf_30min / 2016-03-31

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-31.parquet
  size:    391 KB
  rows:    13,194

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-03-31 04:00:00	SPY	ETF	205.5	205.53	205.2	205.48	8751.0
2016-03-31 04:30:00	SPY	ETF	205.52	205.73	205.52	205.62	11565.0
2016-03-31 05:00:00	SPY	ETF	205.59	205.66	205.49	205.66	7269.0
2016-03-31 05:30:00	SPY	ETF	205.57	205.76	205.57	205.6	8700.0
2016-03-31 06:00:00	SPY	ETF	205.6	205.69	205.57	205.67	8763.0
2016-03-31 06:30:00	SPY	ETF	205.57	205.8	205.47	205.8	20463.0
2016-03-31 07:00:00	SPY	ETF	205.83	206.06	205.83	206.02	38876.0
2016-03-31 07:30:00	SPY	ETF	206.03	206.18	205.87	206.01	146274.0
2016-03-31 08:00:00	SPY	ETF	206.0	206.12	205.635	206.04	213843.0
2016-03-31 08:30:00	SPY	ETF	206.0	206.07	205.92	205.94	135291.0
2016-03-31 09:00:00	SPY	ETF	205.95	206.0	205.76	205.91	555290.0
2016-03-31 09:30:00	SPY	ETF	205.91	206.29	205.87	205.99	7337536.0
2016-03-31 10:00:00	SPY	ETF	206.0	206.37	205.91	206.06	6500145.0
2016-03-31 10:30:00	SPY	ETF	206.055	206.3	205.97	206.12	4035491.0
2016-03-31 11:00:00	SPY	ETF	206.125	206.37	206.08	206.18	4113106.0
2016-03-31 11:30:00	SPY	ETF	206.17	206.36	206.02	206.33	3839757.0
2016-03-31 12:00:00	SPY	ETF	206.33	206.41	206.27	206.38	2650241.0
2016-03-31 12:30:00	SPY	ETF	206.375	206.39	206.16	206.17	3863497.0
2016-03-31 13:00:00	SPY	ETF	206.169	206.2	206.05	206.1	2438473.0
2016-03-31 13:30:00	SPY	ETF	206.09	206.1	205.69	205.83	5756306.0
2016-03-31 14:00:00	SPY	ETF	205.82	205.83	205.5	205.54	5242502.0
2016-03-31 14:30:00	SPY	ETF	205.5489	205.64	205.33	205.48	6636789.0
2016-03-31 15:00:00	SPY	ETF	205.49	205.8	205.43	205.74	6433010.0
2016-03-31 15:30:00	SPY	ETF	205.75	206.02	205.43	205.55	17226192.0
2016-03-31 16:00:00	SPY	ETF	205.56	205.84	205.47	205.78	10880910.0
2016-03-31 16:30:00	SPY	ETF	205.78	205.9953	205.56	205.69	3259536.0
2016-03-31 17:00:00	SPY	ETF	205.72	205.72	205.45	205.5	563470.0
2016-03-31 17:30:00	SPY	ETF	205.49	205.65	205.44	205.65	199891.0
2016-03-31 18:00:00	SPY	ETF	205.61	205.76	205.6	205.74	219651.0
2016-03-31 18:30:00	SPY	ETF	205.73	205.8	205.73	205.79	43532.0
2016-03-31 19:00:00	SPY	ETF	205.8	205.8	205.7	205.7	14318.0
2016-03-31 19:30:00	SPY	ETF	205.69	205.81	205.68	205.73	39723.0
2016-03-31 04:00:00	QQQ	ETF	109.01	109.01	109.01	109.01	5000.0
2016-03-31 05:30:00	QQQ	ETF	109.2	109.2	109.2	109.2	100.0
2016-03-31 06:30:00	QQQ	ETF	109.26	109.27	109.26	109.27	700.0
2016-03-31 07:00:00	QQQ	ETF	109.28	109.38	109.28	109.38	6488.0
2016-03-31 07:30:00	QQQ	ETF	109.36	109.43	109.36	109.43	649.0
2016-03-31 08:00:00	QQQ	ETF	109.36	109.38	109.32	109.38	350.0
2016-03-31 08:30:00	QQQ	ETF	109.36	109.37	109.32	109.32	32385.0
2016-03-31 09:00:00	QQQ	ETF	109.3	109.34	109.26	109.3	41243.0
2016-03-31 09:30:00	QQQ	ETF	109.3	109.48	109.17	109.31	2177323.0
2016-03-31 10:00:00	QQQ	ETF	109.32	109.61	109.26	109.51	1616286.0
2016-03-31 10:30:00	QQQ	ETF	109.51	109.67	109.46	109.595	1027160.0
2016-03-31 11:00:00	QQQ	ETF	109.6	109.69	109.445	109.48	939696.0
2016-03-31 11:30:00	QQQ	ETF	109.48	109.64	109.43	109.6	673775.0
2016-03-31 12:00:00	QQQ	ETF	109.61	109.68	109.57	109.675	589627.0
2016-03-31 12:30:00	QQQ	ETF	109.67	109.68	109.54	109.5499	525286.0
2016-03-31 13:00:00	QQQ	ETF	109.54	109.56	109.42	109.43	727908.0
2016-03-31 13:30:00	QQQ	ETF	109.43	109.43	109.22	109.27	815601.0
2016-03-31 14:00:00	QQQ	ETF	109.27	109.28	109.1	109.11	1461020.0

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

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