PREVIEW / stock_30min / 2017-03-29

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-29.parquet
  size:    1.6 MB
  rows:    81,832
  symbols: 3,095

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-03-29 04:00:00	AAPL	Stock	35.925	35.9975	35.925	35.9875	29624.0
2017-03-29 04:30:00	AAPL	Stock	35.9625	35.9625	35.9625	35.9625	1360.0
2017-03-29 05:30:00	AAPL	Stock	35.905	35.905	35.905	35.905	4800.0
2017-03-29 06:00:00	AAPL	Stock	35.93	35.9425	35.9075	35.925	13436.0
2017-03-29 06:30:00	AAPL	Stock	35.9375	35.9375	35.905	35.905	2500.0
2017-03-29 07:00:00	AAPL	Stock	35.875	35.93	35.875	35.9225	24524.0
2017-03-29 07:30:00	AAPL	Stock	35.9225	35.9225	35.855	35.885	39168.0
2017-03-29 08:00:00	AAPL	Stock	35.885	35.925	35.875	35.895	96252.0
2017-03-29 08:30:00	AAPL	Stock	35.895	35.925	35.8875	35.9175	81640.0
2017-03-29 09:00:00	AAPL	Stock	35.905	35.92	35.875	35.92	240100.0
2017-03-29 09:30:00	AAPL	Stock	35.92	36.05	35.7975	35.9525	21907516.0
2017-03-29 10:00:00	AAPL	Stock	35.9525	35.955	35.8275	35.8925	8650992.0
2017-03-29 10:30:00	AAPL	Stock	35.895	35.9602	35.8875	35.9162	6560936.0
2017-03-29 11:00:00	AAPL	Stock	35.915	35.9275	35.855	35.89	5065352.0
2017-03-29 11:30:00	AAPL	Stock	35.89	35.8907	35.8175	35.8862	5822924.0
2017-03-29 12:00:00	AAPL	Stock	35.8852	35.9525	35.8775	35.9312	4516632.0
2017-03-29 12:30:00	AAPL	Stock	35.93	35.9425	35.88	35.8825	2660420.0
2017-03-29 13:00:00	AAPL	Stock	35.8825	35.975	35.8775	35.9625	3553624.0
2017-03-29 13:30:00	AAPL	Stock	35.9625	36.075	35.9575	36.0525	6173660.0
2017-03-29 14:00:00	AAPL	Stock	36.0525	36.103	36.005	36.103	5089996.0
2017-03-29 14:30:00	AAPL	Stock	36.1025	36.1075	36.06	36.0825	5101528.0
2017-03-29 15:00:00	AAPL	Stock	36.0825	36.1225	36.0625	36.085	6468240.0
2017-03-29 15:30:00	AAPL	Stock	36.085	36.0975	36.0	36.04	11256704.0
2017-03-29 16:00:00	AAPL	Stock	36.03	36.04	36.025	36.04	6786392.0
2017-03-29 16:30:00	AAPL	Stock	36.045	36.045	36.03	36.0375	52724.0
2017-03-29 17:00:00	AAPL	Stock	36.045	36.045	36.03	36.0375	21004.0
2017-03-29 17:30:00	AAPL	Stock	36.0375	36.0375	36.02	36.02	1412.0
2017-03-29 18:00:00	AAPL	Stock	36.0375	36.0525	36.03	36.0375	14328.0
2017-03-29 18:30:00	AAPL	Stock	36.0275	36.0375	36.0275	36.0375	11308.0
2017-03-29 19:00:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	936.0
2017-03-29 19:30:00	AAPL	Stock	36.0375	36.0625	36.035	36.0625	26224.0
2017-03-29 06:30:00	MSFT	Stock	65.24	65.24	65.24	65.24	241.0
2017-03-29 07:30:00	MSFT	Stock	65.24	65.24	65.24	65.24	100.0
2017-03-29 08:00:00	MSFT	Stock	65.2	65.2	65.2	65.2	600.0
2017-03-29 09:00:00	MSFT	Stock	65.3	65.35	65.19	65.19	30643.0
2017-03-29 09:30:00	MSFT	Stock	65.12	65.34	65.02	65.22	1634881.0
2017-03-29 10:00:00	MSFT	Stock	65.225	65.24	65.16	65.18	1066730.0
2017-03-29 10:30:00	MSFT	Stock	65.19	65.24	65.09	65.106	664139.0
2017-03-29 11:00:00	MSFT	Stock	65.1	65.15	65.04	65.13	550465.0
2017-03-29 11:30:00	MSFT	Stock	65.12	65.13	64.948	65.05	664927.0
2017-03-29 12:00:00	MSFT	Stock	65.055	65.12	65.01	65.085	400163.0
2017-03-29 12:30:00	MSFT	Stock	65.08	65.12	65.045	65.07	304211.0
2017-03-29 13:00:00	MSFT	Stock	65.06	65.205	65.06	65.2	752035.0
2017-03-29 13:30:00	MSFT	Stock	65.21	65.26	65.19	65.26	550534.0
2017-03-29 14:00:00	MSFT	Stock	65.25	65.31	65.205	65.29	662979.0
2017-03-29 14:30:00	MSFT	Stock	65.29	65.34	65.27	65.3	576172.0
2017-03-29 15:00:00	MSFT	Stock	65.305	65.42	65.28	65.415	829067.0
2017-03-29 15:30:00	MSFT	Stock	65.42	65.5	65.4	65.48	2434404.0
2017-03-29 16:00:00	MSFT	Stock	65.47	65.57	65.47	65.51	1125002.0
2017-03-29 16:30:00	MSFT	Stock	65.5	65.5	65.5	65.5	400.0

> showing 50 of 81,832 rows — these rows as CSV

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