PREVIEW / stock_30min / 2017-11-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-02.parquet
  size:    1.6 MB
  rows:    81,862
  symbols: 2,943

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-11-02 04:00:00	AAPL	Stock	41.7	41.72	41.7	41.72	800.0
2017-11-02 04:30:00	AAPL	Stock	41.7375	41.75	41.7375	41.7375	9744.0
2017-11-02 05:30:00	AAPL	Stock	41.7275	41.7275	41.6975	41.6975	800.0
2017-11-02 06:00:00	AAPL	Stock	41.7275	41.745	41.7275	41.7375	3628.0
2017-11-02 06:30:00	AAPL	Stock	41.745	41.7875	41.6975	41.705	33076.0
2017-11-02 07:00:00	AAPL	Stock	41.7625	41.845	41.6925	41.825	89924.0
2017-11-02 07:30:00	AAPL	Stock	41.8225	41.975	41.8225	41.9675	160492.0
2017-11-02 08:00:00	AAPL	Stock	41.775	42.07	41.725	41.97	557544.0
2017-11-02 08:30:00	AAPL	Stock	41.975	42.0	41.85	41.9	375360.0
2017-11-02 09:00:00	AAPL	Stock	41.9	41.9375	41.8625	41.885	254536.0
2017-11-02 09:30:00	AAPL	Stock	41.895	41.9325	41.475	41.68	13544752.0
2017-11-02 10:00:00	AAPL	Stock	41.6825	41.6875	41.4425	41.595	9267032.0
2017-11-02 10:30:00	AAPL	Stock	41.5975	41.7175	41.535	41.625	5269432.0
2017-11-02 11:00:00	AAPL	Stock	41.6225	41.7125	41.49	41.514	4896188.0
2017-11-02 11:30:00	AAPL	Stock	41.5125	41.56	41.32	41.555	6294392.0
2017-11-02 12:00:00	AAPL	Stock	41.56	41.775	41.48	41.7705	7000828.0
2017-11-02 12:30:00	AAPL	Stock	41.7718	42.0525	41.7625	41.93	13109956.0
2017-11-02 13:00:00	AAPL	Stock	41.9275	41.9525	41.8225	41.83	5531636.0
2017-11-02 13:30:00	AAPL	Stock	41.825	41.9775	41.8075	41.9125	5773824.0
2017-11-02 14:00:00	AAPL	Stock	41.915	42.0625	41.914	42.06	6661692.0
2017-11-02 14:30:00	AAPL	Stock	42.06	42.125	42.005	42.01	8284264.0
2017-11-02 15:00:00	AAPL	Stock	42.0125	42.0598	41.92	41.9815	7631336.0
2017-11-02 15:30:00	AAPL	Stock	41.9825	42.1	41.965	42.0175	17244976.0
2017-11-02 16:00:00	AAPL	Stock	42.0275	42.26	42.0175	42.1975	7264116.0
2017-11-02 16:30:00	AAPL	Stock	42.2	43.5875	42.0275	43.425	19626580.0
2017-11-02 17:00:00	AAPL	Stock	43.425	43.52	42.0275	43.1	4657544.0
2017-11-02 17:30:00	AAPL	Stock	43.0975	43.1	42.38	42.815	3181848.0
2017-11-02 18:00:00	AAPL	Stock	42.815	43.2	42.8	43.14	1148432.0
2017-11-02 18:30:00	AAPL	Stock	43.14	43.1625	43.085	43.1375	518576.0
2017-11-02 19:00:00	AAPL	Stock	43.14	43.3	43.1375	43.2725	520856.0
2017-11-02 19:30:00	AAPL	Stock	43.2675	43.355	43.265	43.345	611056.0
2017-11-02 04:00:00	MSFT	Stock	83.15	83.15	83.15	83.15	800.0
2017-11-02 04:30:00	MSFT	Stock	83.15	83.17	83.15	83.17	220.0
2017-11-02 05:00:00	MSFT	Stock	83.15	83.15	83.15	83.15	274.0
2017-11-02 06:00:00	MSFT	Stock	83.15	83.15	83.15	83.15	120.0
2017-11-02 07:00:00	MSFT	Stock	83.04	83.18	83.04	83.18	790.0
2017-11-02 08:00:00	MSFT	Stock	83.01	83.05	83.01	83.05	200.0
2017-11-02 08:30:00	MSFT	Stock	83.22	83.39	83.22	83.39	2013.0
2017-11-02 09:00:00	MSFT	Stock	83.37	83.37	83.25	83.25	3403.0
2017-11-02 09:30:00	MSFT	Stock	83.35	83.48	83.15	83.27	2175288.0
2017-11-02 10:00:00	MSFT	Stock	83.27	83.68	83.12	83.6	2336797.0
2017-11-02 10:30:00	MSFT	Stock	83.61	83.99	83.55	83.83	2171040.0
2017-11-02 11:00:00	MSFT	Stock	83.83	84.03	83.65	83.73	1445474.0
2017-11-02 11:30:00	MSFT	Stock	83.73	83.776	83.45	83.76	1226446.0
2017-11-02 12:00:00	MSFT	Stock	83.765	83.95	83.75	83.9	1163409.0
2017-11-02 12:30:00	MSFT	Stock	83.9	84.15	83.83	84.02	918395.0
2017-11-02 13:00:00	MSFT	Stock	84.02	84.46	84.02	84.34	1311236.0
2017-11-02 13:30:00	MSFT	Stock	84.33	84.37	84.0	84.02	1135395.0
2017-11-02 14:00:00	MSFT	Stock	84.02	84.27	84.0	84.24	952721.0
2017-11-02 14:30:00	MSFT	Stock	84.24	84.3	84.1	84.11	932958.0

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

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