PREVIEW / stock_30min / 2018-11-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-02.parquet
  size:    1.7 MB
  rows:    84,197
  symbols: 2,747

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
2018-11-02 04:00:00	AAPL	Stock	52.495	53.05	52.3525	53.0	274680.0
2018-11-02 04:30:00	AAPL	Stock	53.005	53.05	52.5	52.7125	163456.0
2018-11-02 05:00:00	AAPL	Stock	52.7475	52.75	52.5	52.735	88940.0
2018-11-02 05:30:00	AAPL	Stock	52.7	52.92	52.5025	52.6875	282732.0
2018-11-02 06:00:00	AAPL	Stock	52.6975	52.9125	52.35	52.575	519552.0
2018-11-02 06:30:00	AAPL	Stock	52.57	52.7	52.375	52.6375	291024.0
2018-11-02 07:00:00	AAPL	Stock	52.5925	52.8	52.025	52.1025	1841228.0
2018-11-02 07:30:00	AAPL	Stock	52.1475	52.4375	52.08	52.4	915880.0
2018-11-02 08:00:00	AAPL	Stock	52.4	52.8	51.92	52.005	3044228.0
2018-11-02 08:30:00	AAPL	Stock	52.015	52.2	51.9375	52.025	1853396.0
2018-11-02 09:00:00	AAPL	Stock	52.025	52.4875	51.7925	52.3875	5108344.0
2018-11-02 09:30:00	AAPL	Stock	52.3875	53.4125	52.1	52.5175	70635832.0
2018-11-02 10:00:00	AAPL	Stock	52.5285	52.61	51.8575	51.87	36879344.0
2018-11-02 10:30:00	AAPL	Stock	51.8725	52.0525	51.6	52.0	29837648.0
2018-11-02 11:00:00	AAPL	Stock	52.0	52.12	51.595	51.8175	19292552.0
2018-11-02 11:30:00	AAPL	Stock	51.825	51.95	51.6525	51.815	13714524.0
2018-11-02 12:00:00	AAPL	Stock	51.8175	52.0025	51.7025	51.77	13439624.0
2018-11-02 12:30:00	AAPL	Stock	51.7725	51.79	51.47	51.57	16268584.0
2018-11-02 13:00:00	AAPL	Stock	51.576	51.74	51.4125	51.6075	10107184.0
2018-11-02 13:30:00	AAPL	Stock	51.607	51.815	51.535	51.6287	8548580.0
2018-11-02 14:00:00	AAPL	Stock	51.6275	51.8	51.3575	51.7835	12059304.0
2018-11-02 14:30:00	AAPL	Stock	51.7875	51.86	51.54	51.8	9456460.0
2018-11-02 15:00:00	AAPL	Stock	51.8	51.8625	51.47	51.4925	11180620.0
2018-11-02 15:30:00	AAPL	Stock	51.49	51.8675	51.375	51.8675	28028568.0
2018-11-02 16:00:00	AAPL	Stock	51.8675	51.87	51.3775	51.7	16210228.0
2018-11-02 16:30:00	AAPL	Stock	51.6775	51.87	51.65	51.7	773824.0
2018-11-02 17:00:00	AAPL	Stock	51.6975	51.71	51.645	51.66	137972.0
2018-11-02 17:30:00	AAPL	Stock	51.6525	51.675	51.54	51.63	81904.0
2018-11-02 18:00:00	AAPL	Stock	51.63	51.655	51.6	51.625	126104.0
2018-11-02 18:30:00	AAPL	Stock	51.625	51.6725	51.62	51.6375	39964.0
2018-11-02 19:00:00	AAPL	Stock	51.65	51.6725	51.6375	51.6375	41304.0
2018-11-02 19:30:00	AAPL	Stock	51.63	51.64	51.6025	51.625	98172.0
2018-11-02 04:00:00	MSFT	Stock	107.0	107.72	106.82	107.67	6261.0
2018-11-02 04:30:00	MSFT	Stock	107.75	107.75	107.32	107.34	9610.0
2018-11-02 05:00:00	MSFT	Stock	107.3	107.3	107.0	107.01	5215.0
2018-11-02 05:30:00	MSFT	Stock	107.0	107.0	106.85	107.0	2854.0
2018-11-02 06:00:00	MSFT	Stock	106.92	106.92	106.9	106.9	300.0
2018-11-02 06:30:00	MSFT	Stock	107.07	107.17	107.07	107.17	600.0
2018-11-02 07:00:00	MSFT	Stock	107.07	107.14	106.85	107.14	20615.0
2018-11-02 07:30:00	MSFT	Stock	107.12	107.25	106.88	107.06	29916.0
2018-11-02 08:00:00	MSFT	Stock	107.1	107.25	106.59	106.85	61790.0
2018-11-02 08:30:00	MSFT	Stock	106.87	107.0	106.6	106.76	29807.0
2018-11-02 09:00:00	MSFT	Stock	106.76	106.85	105.95	106.45	43547.0
2018-11-02 09:30:00	MSFT	Stock	106.43	107.32	106.09	106.568	4132615.0
2018-11-02 10:00:00	MSFT	Stock	106.56	106.9	105.92	106.02	2381172.0
2018-11-02 10:30:00	MSFT	Stock	106.02	106.1	105.19	105.835	2236136.0
2018-11-02 11:00:00	MSFT	Stock	105.85	106.11	105.22	105.57	2164953.0
2018-11-02 11:30:00	MSFT	Stock	105.56	105.93	105.43	105.9	1501826.0
2018-11-02 12:00:00	MSFT	Stock	105.89	106.025	105.58	105.92	1622806.0
2018-11-02 12:30:00	MSFT	Stock	105.92	106.0	105.17	105.34	1640132.0

> showing 50 of 84,197 rows — these rows as CSV

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