PREVIEW / stock_30min / 2017-01-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-03.parquet
  size:    1.6 MB
  rows:    83,933
  symbols: 3,142

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-03 04:00:00	AAPL	Stock	29.005	29.06	29.0	29.0125	29288.0
2017-01-03 04:30:00	AAPL	Stock	29.0125	29.0125	29.01	29.0125	5848.0
2017-01-03 05:00:00	AAPL	Stock	29.0075	29.015	29.0025	29.0025	4616.0
2017-01-03 05:30:00	AAPL	Stock	29.005	29.005	29.0	29.005	10336.0
2017-01-03 06:00:00	AAPL	Stock	29.0175	29.045	29.0175	29.045	9792.0
2017-01-03 06:30:00	AAPL	Stock	29.07	29.07	29.07	29.07	400.0
2017-01-03 07:00:00	AAPL	Stock	29.0575	29.095	29.0575	29.075	16796.0
2017-01-03 07:30:00	AAPL	Stock	29.04	29.0475	29.005	29.005	38960.0
2017-01-03 08:00:00	AAPL	Stock	29.02	29.1	29.0	29.025	163188.0
2017-01-03 08:30:00	AAPL	Stock	29.025	29.0625	29.0175	29.05	187736.0
2017-01-03 09:00:00	AAPL	Stock	29.05	29.0625	28.95	28.95	229892.0
2017-01-03 09:30:00	AAPL	Stock	28.955	29.0825	28.69	28.9175	23510944.0
2017-01-03 10:00:00	AAPL	Stock	28.915	28.9575	28.8175	28.925	9425804.0
2017-01-03 10:30:00	AAPL	Stock	28.9238	28.945	28.85	28.8625	6565236.0
2017-01-03 11:00:00	AAPL	Stock	28.8625	28.92	28.8275	28.8375	5702152.0
2017-01-03 11:30:00	AAPL	Stock	28.84	28.8825	28.7825	28.844	5885928.0
2017-01-03 12:00:00	AAPL	Stock	28.8475	28.8825	28.815	28.845	3932092.0
2017-01-03 12:30:00	AAPL	Stock	28.846	28.87	28.8175	28.8662	2770208.0
2017-01-03 13:00:00	AAPL	Stock	28.8675	28.88	28.8422	28.85	2767688.0
2017-01-03 13:30:00	AAPL	Stock	28.8525	28.86	28.8075	28.8088	3419376.0
2017-01-03 14:00:00	AAPL	Stock	28.81	28.8425	28.7875	28.8425	4150248.0
2017-01-03 14:30:00	AAPL	Stock	28.8425	28.865	28.84	28.8575	4213024.0
2017-01-03 15:00:00	AAPL	Stock	28.86	28.9075	28.8575	28.87	5046336.0
2017-01-03 15:30:00	AAPL	Stock	28.8675	29.035	28.8475	29.035	16283344.0
2017-01-03 16:00:00	AAPL	Stock	29.0375	29.0625	28.8968	29.03	11900872.0
2017-01-03 16:30:00	AAPL	Stock	29.025	29.0525	29.0025	29.0025	441764.0
2017-01-03 17:00:00	AAPL	Stock	29.02	29.02	29.0125	29.0125	7928.0
2017-01-03 17:30:00	AAPL	Stock	29.005	29.005	28.9925	29.0025	4960.0
2017-01-03 18:00:00	AAPL	Stock	29.005	29.0175	29.005	29.0175	3600.0
2017-01-03 18:30:00	AAPL	Stock	29.005	29.005	29.005	29.005	400.0
2017-01-03 19:00:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	1900.0
2017-01-03 19:30:00	AAPL	Stock	29.0075	29.0175	29.0075	29.0175	6428.0
2017-01-03 04:00:00	MSFT	Stock	62.71	62.71	62.65	62.65	4182.0
2017-01-03 06:30:00	MSFT	Stock	62.85	62.85	62.8	62.8	1100.0
2017-01-03 07:00:00	MSFT	Stock	62.85	62.85	62.85	62.85	2389.0
2017-01-03 07:30:00	MSFT	Stock	62.8	62.8	62.8	62.8	890.0
2017-01-03 08:00:00	MSFT	Stock	62.8	62.8	62.65	62.69	7540.0
2017-01-03 08:30:00	MSFT	Stock	62.62	62.62	62.14	62.55	27134.0
2017-01-03 09:00:00	MSFT	Stock	62.6	62.82	62.6	62.75	14447.0
2017-01-03 09:30:00	MSFT	Stock	62.76	62.8	62.42	62.57	3115954.0
2017-01-03 10:00:00	MSFT	Stock	62.57	62.84	62.56	62.7	1340374.0
2017-01-03 10:30:00	MSFT	Stock	62.7	62.76	62.33	62.34	991902.0
2017-01-03 11:00:00	MSFT	Stock	62.34	62.411	62.25	62.38	1398383.0
2017-01-03 11:30:00	MSFT	Stock	62.37	62.48	62.254	62.41	1061228.0
2017-01-03 12:00:00	MSFT	Stock	62.42	62.43	62.31	62.37	557903.0
2017-01-03 12:30:00	MSFT	Stock	62.375	62.39	62.285	62.37	571972.0
2017-01-03 13:00:00	MSFT	Stock	62.37	62.42	62.31	62.37	693615.0
2017-01-03 13:30:00	MSFT	Stock	62.37	62.395	62.24	62.27	900842.0
2017-01-03 14:00:00	MSFT	Stock	62.265	62.33	62.21	62.22	704652.0
2017-01-03 14:30:00	MSFT	Stock	62.22	62.246	62.14	62.23	787508.0

> showing 50 of 83,933 rows — these rows as CSV

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