PREVIEW / stock_30min / 2017-03-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-20.parquet
  size:    1.6 MB
  rows:    81,760
  symbols: 3,071

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-20 04:00:00	AAPL	Stock	35.035	35.035	35.0	35.02	7816.0
2017-03-20 05:30:00	AAPL	Stock	35.0025	35.015	35.0025	35.015	2072.0
2017-03-20 06:00:00	AAPL	Stock	35.07	35.0725	35.07	35.0725	2580.0
2017-03-20 06:30:00	AAPL	Stock	35.045	35.045	35.0325	35.045	15548.0
2017-03-20 07:00:00	AAPL	Stock	35.045	35.0575	35.045	35.055	4800.0
2017-03-20 07:30:00	AAPL	Stock	35.05	35.0625	35.05	35.0625	13776.0
2017-03-20 08:00:00	AAPL	Stock	35.0625	35.1225	35.0325	35.0775	205596.0
2017-03-20 08:30:00	AAPL	Stock	35.075	35.09	35.0525	35.075	179100.0
2017-03-20 09:00:00	AAPL	Stock	35.0825	35.125	35.075	35.11	191616.0
2017-03-20 09:30:00	AAPL	Stock	35.1	35.19	35.0575	35.184	11505504.0
2017-03-20 10:00:00	AAPL	Stock	35.1825	35.335	35.1725	35.3062	8705736.0
2017-03-20 10:30:00	AAPL	Stock	35.3075	35.325	35.25	35.2702	5744168.0
2017-03-20 11:00:00	AAPL	Stock	35.2725	35.335	35.27	35.31	4217644.0
2017-03-20 11:30:00	AAPL	Stock	35.3125	35.33	35.2612	35.27	3165396.0
2017-03-20 12:00:00	AAPL	Stock	35.2712	35.3125	35.26	35.27	2672240.0
2017-03-20 12:30:00	AAPL	Stock	35.27	35.31	35.26	35.2772	2908232.0
2017-03-20 13:00:00	AAPL	Stock	35.2772	35.31	35.265	35.3025	2173912.0
2017-03-20 13:30:00	AAPL	Stock	35.3015	35.304	35.2275	35.25	3365664.0
2017-03-20 14:00:00	AAPL	Stock	35.2525	35.29	35.24	35.275	2478896.0
2017-03-20 14:30:00	AAPL	Stock	35.2725	35.2825	35.215	35.225	3701164.0
2017-03-20 15:00:00	AAPL	Stock	35.2275	35.3225	35.2125	35.3125	5594436.0
2017-03-20 15:30:00	AAPL	Stock	35.3138	35.375	35.31	35.3725	9534720.0
2017-03-20 16:00:00	AAPL	Stock	35.3698	35.375	35.35	35.365	5740676.0
2017-03-20 16:30:00	AAPL	Stock	35.3575	35.38	35.355	35.3675	1869208.0
2017-03-20 17:00:00	AAPL	Stock	35.3625	35.39	35.3625	35.39	2203028.0
2017-03-20 17:30:00	AAPL	Stock	35.375	35.3825	35.375	35.3825	11012.0
2017-03-20 18:00:00	AAPL	Stock	35.3825	35.385	35.37	35.375	10584.0
2017-03-20 18:30:00	AAPL	Stock	35.375	35.385	35.37	35.385	15732.0
2017-03-20 19:00:00	AAPL	Stock	35.385	35.385	35.37	35.375	10992.0
2017-03-20 19:30:00	AAPL	Stock	35.3775	35.3875	35.3775	35.3875	15584.0
2017-03-20 06:30:00	MSFT	Stock	65.01	65.01	65.01	65.01	657.0
2017-03-20 08:00:00	MSFT	Stock	65.0	65.01	65.0	65.01	244.0
2017-03-20 08:30:00	MSFT	Stock	65.08	65.08	65.08	65.08	500.0
2017-03-20 09:00:00	MSFT	Stock	65.07	65.07	64.9	64.91	1589.0
2017-03-20 09:30:00	MSFT	Stock	64.91	65.175	64.85	65.01	1439418.0
2017-03-20 10:00:00	MSFT	Stock	65.01	65.145	64.99	65.1	738307.0
2017-03-20 10:30:00	MSFT	Stock	65.093	65.1	64.945	65.02	833649.0
2017-03-20 11:00:00	MSFT	Stock	65.02	65.04	64.86	64.862	710694.0
2017-03-20 11:30:00	MSFT	Stock	64.86	64.96	64.86	64.918	527009.0
2017-03-20 12:00:00	MSFT	Stock	64.915	64.93	64.81	64.84	537881.0
2017-03-20 12:30:00	MSFT	Stock	64.84	64.91	64.83	64.905	391518.0
2017-03-20 13:00:00	MSFT	Stock	64.91	64.93	64.85	64.89	452598.0
2017-03-20 13:30:00	MSFT	Stock	64.89	64.92	64.72	64.82	839715.0
2017-03-20 14:00:00	MSFT	Stock	64.815	64.88	64.79	64.855	503034.0
2017-03-20 14:30:00	MSFT	Stock	64.85	64.86	64.735	64.82	768482.0
2017-03-20 15:00:00	MSFT	Stock	64.82	64.955	64.81	64.949	736638.0
2017-03-20 15:30:00	MSFT	Stock	64.945	64.97	64.9	64.93	1544990.0
2017-03-20 16:00:00	MSFT	Stock	64.905	64.93	64.905	64.93	1735845.0
2017-03-20 16:30:00	MSFT	Stock	64.93	64.93	64.9	64.9	665687.0
2017-03-20 17:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	840000.0

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

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