PREVIEW / etf_30min / 2017-01-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-24.parquet
  size:    450 KB
  rows:    15,090

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
2017-01-24 04:00:00	SPY	ETF	226.14	226.24	226.11	226.21	9511.0
2017-01-24 04:30:00	SPY	ETF	226.16	226.36	226.16	226.29	13401.0
2017-01-24 05:00:00	SPY	ETF	226.36	226.49	226.36	226.36	5300.0
2017-01-24 05:30:00	SPY	ETF	226.44	226.44	226.44	226.44	300.0
2017-01-24 06:00:00	SPY	ETF	226.34	226.34	226.25	226.3	5021.0
2017-01-24 06:30:00	SPY	ETF	226.31	226.31	226.2	226.25	2504.0
2017-01-24 07:00:00	SPY	ETF	226.26	226.26	226.21	226.21	11927.0
2017-01-24 07:30:00	SPY	ETF	226.24	226.25	226.2	226.25	4348.0
2017-01-24 08:00:00	SPY	ETF	226.21	226.29	226.2	226.22	84218.0
2017-01-24 08:30:00	SPY	ETF	226.21	226.46	226.21	226.45	96121.0
2017-01-24 09:00:00	SPY	ETF	226.41	226.47	226.37	226.42	326129.0
2017-01-24 09:30:00	SPY	ETF	226.4	226.58	226.28	226.445	5071293.0
2017-01-24 10:00:00	SPY	ETF	226.45	226.65	226.27	226.48	3275257.0
2017-01-24 10:30:00	SPY	ETF	226.48	226.63	226.42	226.579	2154703.0
2017-01-24 11:00:00	SPY	ETF	226.575	226.83	226.52	226.72	3840144.0
2017-01-24 11:30:00	SPY	ETF	226.71	226.95	226.69	226.89	3975457.0
2017-01-24 12:00:00	SPY	ETF	226.89	227.19	226.86	227.16	5959778.0
2017-01-24 12:30:00	SPY	ETF	227.165	227.28	227.033	227.23	5241144.0
2017-01-24 13:00:00	SPY	ETF	227.23	227.53	227.22	227.48	5904953.0
2017-01-24 13:30:00	SPY	ETF	227.47	227.85	227.47	227.685	6206035.0
2017-01-24 14:00:00	SPY	ETF	227.685	227.82	227.63	227.66	6963522.0
2017-01-24 14:30:00	SPY	ETF	227.6699	227.89	227.66	227.845	7155631.0
2017-01-24 15:00:00	SPY	ETF	227.845	228.08	227.73	227.82	8165279.0
2017-01-24 15:30:00	SPY	ETF	227.82	227.87	227.52	227.58	14516672.0
2017-01-24 16:00:00	SPY	ETF	227.59	227.782	227.1819	227.51	12636904.0
2017-01-24 16:30:00	SPY	ETF	227.52	227.66	227.5	227.62	1339301.0
2017-01-24 17:00:00	SPY	ETF	227.62	227.65	227.6	227.6	22195.0
2017-01-24 17:30:00	SPY	ETF	227.6	227.65	227.56	227.6	84146.0
2017-01-24 18:00:00	SPY	ETF	227.62	227.68	227.6	227.68	117459.0
2017-01-24 18:30:00	SPY	ETF	227.67	227.73	227.67	227.68	39826.0
2017-01-24 19:00:00	SPY	ETF	227.7	227.75	227.7	227.73	47315.0
2017-01-24 19:30:00	SPY	ETF	227.72	227.73	227.66	227.68	17589.0
2017-01-24 04:30:00	QQQ	ETF	123.44	123.45	123.4	123.4	800.0
2017-01-24 05:00:00	QQQ	ETF	123.51	123.51	123.51	123.51	1000.0
2017-01-24 06:30:00	QQQ	ETF	123.38	123.43	123.38	123.43	3100.0
2017-01-24 07:00:00	QQQ	ETF	123.39	123.45	123.39	123.45	13355.0
2017-01-24 07:30:00	QQQ	ETF	123.46	123.51	123.44	123.47	36324.0
2017-01-24 08:00:00	QQQ	ETF	123.5	123.5	123.46	123.46	16116.0
2017-01-24 08:30:00	QQQ	ETF	123.49	123.6	123.48	123.6	49353.0
2017-01-24 09:00:00	QQQ	ETF	123.6	123.61	123.55	123.6	87808.0
2017-01-24 09:30:00	QQQ	ETF	123.59	123.77	123.46	123.46	1617982.0
2017-01-24 10:00:00	QQQ	ETF	123.46	123.64	123.3847	123.555	1060589.0
2017-01-24 10:30:00	QQQ	ETF	123.56	123.625	123.52	123.585	491408.0
2017-01-24 11:00:00	QQQ	ETF	123.59	123.67	123.53	123.55	860605.0
2017-01-24 11:30:00	QQQ	ETF	123.555	123.7	123.55	123.67	597349.0
2017-01-24 12:00:00	QQQ	ETF	123.6655	123.75	123.63	123.71	600530.0
2017-01-24 12:30:00	QQQ	ETF	123.716	123.73	123.66	123.6999	389631.0
2017-01-24 13:00:00	QQQ	ETF	123.7	123.94	123.7	123.935	916895.0
2017-01-24 13:30:00	QQQ	ETF	123.935	124.15	123.935	124.09	1028660.0
2017-01-24 14:00:00	QQQ	ETF	124.1	124.195	124.07	124.115	1126186.0

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

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