PREVIEW / stock_30min / 2017-01-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-05.parquet
  size:    1.6 MB
  rows:    82,537
  symbols: 3,123

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-05 07:00:00	AAPL	Stock	28.9625	28.985	28.9425	28.9425	12328.0
2017-01-05 07:30:00	AAPL	Stock	28.95	28.95	28.945	28.945	1600.0
2017-01-05 08:00:00	AAPL	Stock	28.9975	28.9975	28.945	28.965	12680.0
2017-01-05 08:30:00	AAPL	Stock	28.975	29.0175	28.9575	29.0175	73412.0
2017-01-05 09:00:00	AAPL	Stock	29.015	29.02	28.975	28.9825	163632.0
2017-01-05 09:30:00	AAPL	Stock	28.98	29.216	28.9525	29.1675	15433408.0
2017-01-05 10:00:00	AAPL	Stock	29.17	29.2	29.0825	29.1375	6919140.0
2017-01-05 10:30:00	AAPL	Stock	29.14	29.145	29.02	29.0825	7501024.0
2017-01-05 11:00:00	AAPL	Stock	29.08	29.1	29.005	29.0125	5084988.0
2017-01-05 11:30:00	AAPL	Stock	29.0125	29.0825	28.985	29.0725	5923580.0
2017-01-05 12:00:00	AAPL	Stock	29.0725	29.145	29.0525	29.1288	6109476.0
2017-01-05 12:30:00	AAPL	Stock	29.1288	29.205	29.1125	29.1725	6230796.0
2017-01-05 13:00:00	AAPL	Stock	29.1725	29.175	29.085	29.0978	3592924.0
2017-01-05 13:30:00	AAPL	Stock	29.1	29.1425	29.085	29.12	2166132.0
2017-01-05 14:00:00	AAPL	Stock	29.1215	29.1538	29.1125	29.1175	2521192.0
2017-01-05 14:30:00	AAPL	Stock	29.1162	29.1188	29.075	29.08	2485896.0
2017-01-05 15:00:00	AAPL	Stock	29.0775	29.1675	29.0725	29.1625	3512340.0
2017-01-05 15:30:00	AAPL	Stock	29.165	29.19	29.145	29.1525	9459300.0
2017-01-05 16:00:00	AAPL	Stock	29.1525	29.17	29.13	29.1525	4973040.0
2017-01-05 16:30:00	AAPL	Stock	29.1575	29.165	29.1575	29.165	6680.0
2017-01-05 17:00:00	AAPL	Stock	29.1675	29.1725	29.1575	29.1725	36400.0
2017-01-05 17:30:00	AAPL	Stock	29.165	29.1725	29.165	29.1725	4400.0
2017-01-05 18:00:00	AAPL	Stock	29.175	29.18	29.1675	29.18	28720.0
2017-01-05 18:30:00	AAPL	Stock	29.18	29.18	29.16	29.1675	26884.0
2017-01-05 19:00:00	AAPL	Stock	29.1675	29.1775	29.1675	29.1775	3200.0
2017-01-05 19:30:00	AAPL	Stock	29.1775	29.1775	29.16	29.175	3360.0
2017-01-05 06:00:00	MSFT	Stock	62.3	62.3	62.3	62.3	964.0
2017-01-05 06:30:00	MSFT	Stock	62.3	62.3	62.3	62.3	475.0
2017-01-05 07:00:00	MSFT	Stock	62.3	62.3	62.15	62.15	677.0
2017-01-05 08:30:00	MSFT	Stock	62.17	62.3	62.17	62.3	2200.0
2017-01-05 09:00:00	MSFT	Stock	62.3	62.39	62.17	62.18	31069.0
2017-01-05 09:30:00	MSFT	Stock	62.19	62.66	62.03	62.48	2624915.0
2017-01-05 10:00:00	MSFT	Stock	62.47	62.52	62.285	62.3	1730836.0
2017-01-05 10:30:00	MSFT	Stock	62.3	62.43	62.21	62.37	1247183.0
2017-01-05 11:00:00	MSFT	Stock	62.37	62.44	62.17	62.31	876896.0
2017-01-05 11:30:00	MSFT	Stock	62.31	62.466	62.26	62.445	1199569.0
2017-01-05 12:00:00	MSFT	Stock	62.445	62.52	62.36	62.41	1207829.0
2017-01-05 12:30:00	MSFT	Stock	62.405	62.49	62.38	62.43	882612.0
2017-01-05 13:00:00	MSFT	Stock	62.425	62.51	62.42	62.44	1026704.0
2017-01-05 13:30:00	MSFT	Stock	62.45	62.475	62.31	62.31	896475.0
2017-01-05 14:00:00	MSFT	Stock	62.315	62.41	62.3	62.385	1218094.0
2017-01-05 14:30:00	MSFT	Stock	62.385	62.4	62.27	62.275	871647.0
2017-01-05 15:00:00	MSFT	Stock	62.28	62.38	62.27	62.374	1079628.0
2017-01-05 15:30:00	MSFT	Stock	62.375	62.43	62.29	62.3	2207481.0
2017-01-05 16:00:00	MSFT	Stock	62.3	62.43	62.24	62.3	3166367.0
2017-01-05 17:00:00	MSFT	Stock	62.35	62.35	62.3	62.3	5716.0
2017-01-05 17:30:00	MSFT	Stock	62.31	62.35	62.31	62.35	1100.0
2017-01-05 18:00:00	MSFT	Stock	62.31	62.31	62.3	62.3	2214.0
2017-01-05 18:30:00	MSFT	Stock	62.35	62.35	62.35	62.35	200.0
2017-01-05 19:30:00	MSFT	Stock	62.31	62.31	62.31	62.31	200.0

> showing 50 of 82,537 rows — these rows as CSV

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