PREVIEW / stock_30min / 2017-03-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-27.parquet
  size:    1.6 MB
  rows:    81,893
  symbols: 3,080

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-27 04:00:00	AAPL	Stock	34.9875	34.9875	34.9275	34.9275	2400.0
2017-03-27 04:30:00	AAPL	Stock	34.9325	34.9325	34.9325	34.9325	1744.0
2017-03-27 05:00:00	AAPL	Stock	34.8925	34.9225	34.8925	34.9225	2368.0
2017-03-27 05:30:00	AAPL	Stock	34.885	34.885	34.875	34.875	928.0
2017-03-27 06:00:00	AAPL	Stock	34.91	34.96	34.91	34.9125	40540.0
2017-03-27 06:30:00	AAPL	Stock	34.9125	34.9125	34.87	34.9125	62560.0
2017-03-27 07:00:00	AAPL	Stock	34.9125	34.95	34.9	34.9175	106848.0
2017-03-27 07:30:00	AAPL	Stock	34.9125	34.925	34.905	34.91	57944.0
2017-03-27 08:00:00	AAPL	Stock	34.91	34.9375	34.855	34.905	291768.0
2017-03-27 08:30:00	AAPL	Stock	34.905	34.905	34.8525	34.8775	143884.0
2017-03-27 09:00:00	AAPL	Stock	34.8775	34.8825	34.79	34.8475	289040.0
2017-03-27 09:30:00	AAPL	Stock	34.8475	35.0	34.655	34.9725	18105364.0
2017-03-27 10:00:00	AAPL	Stock	34.9725	35.07	34.9275	35.034	8380032.0
2017-03-27 10:30:00	AAPL	Stock	35.0335	35.125	35.025	35.0862	6227236.0
2017-03-27 11:00:00	AAPL	Stock	35.085	35.12	35.035	35.12	4005412.0
2017-03-27 11:30:00	AAPL	Stock	35.12	35.17	35.0775	35.1425	4341388.0
2017-03-27 12:00:00	AAPL	Stock	35.145	35.21	35.1213	35.2038	3919660.0
2017-03-27 12:30:00	AAPL	Stock	35.2045	35.2625	35.17	35.245	4348428.0
2017-03-27 13:00:00	AAPL	Stock	35.2425	35.305	35.2375	35.2638	3591820.0
2017-03-27 13:30:00	AAPL	Stock	35.265	35.285	35.2212	35.245	3045800.0
2017-03-27 14:00:00	AAPL	Stock	35.245	35.26	35.175	35.197	3883028.0
2017-03-27 14:30:00	AAPL	Stock	35.195	35.265	35.1925	35.2612	3197504.0
2017-03-27 15:00:00	AAPL	Stock	35.2622	35.2788	35.225	35.2275	3128824.0
2017-03-27 15:30:00	AAPL	Stock	35.2275	35.2875	35.0	35.22	7247596.0
2017-03-27 16:00:00	AAPL	Stock	35.22	35.2375	35.215	35.2375	10941384.0
2017-03-27 16:30:00	AAPL	Stock	35.2375	35.2375	35.22	35.22	126684.0
2017-03-27 17:00:00	AAPL	Stock	35.245	35.2475	35.2325	35.2475	8204.0
2017-03-27 17:30:00	AAPL	Stock	35.2375	35.2375	35.2375	35.2375	800.0
2017-03-27 18:00:00	AAPL	Stock	35.255	35.2575	35.255	35.2575	1600.0
2017-03-27 18:30:00	AAPL	Stock	35.25	35.25	35.2375	35.24	5000.0
2017-03-27 19:00:00	AAPL	Stock	35.25	35.2625	35.25	35.2625	10536.0
2017-03-27 19:30:00	AAPL	Stock	35.2625	35.275	35.26	35.275	22360.0
2017-03-27 04:00:00	MSFT	Stock	64.79	64.79	64.47	64.47	700.0
2017-03-27 05:00:00	MSFT	Stock	64.48	64.48	64.48	64.48	152.0
2017-03-27 06:00:00	MSFT	Stock	64.57	64.58	64.51	64.51	452.0
2017-03-27 07:00:00	MSFT	Stock	64.54	64.54	64.54	64.54	525.0
2017-03-27 08:00:00	MSFT	Stock	64.64	64.64	64.5	64.63	12349.0
2017-03-27 08:30:00	MSFT	Stock	64.51	64.69	64.51	64.69	5608.0
2017-03-27 09:00:00	MSFT	Stock	64.69	64.69	64.48	64.64	25003.0
2017-03-27 09:30:00	MSFT	Stock	64.63	64.735	64.35	64.54	2452759.0
2017-03-27 10:00:00	MSFT	Stock	64.535	64.65	64.46	64.52	1180919.0
2017-03-27 10:30:00	MSFT	Stock	64.525	64.65	64.48	64.625	1004166.0
2017-03-27 11:00:00	MSFT	Stock	64.62	64.81	64.6	64.81	907608.0
2017-03-27 11:30:00	MSFT	Stock	64.81	64.93	64.81	64.9	748222.0
2017-03-27 12:00:00	MSFT	Stock	64.9	64.97	64.85	64.925	534007.0
2017-03-27 12:30:00	MSFT	Stock	64.924	65.06	64.89	64.99	549324.0
2017-03-27 13:00:00	MSFT	Stock	64.99	65.1	64.931	64.955	805200.0
2017-03-27 13:30:00	MSFT	Stock	64.96	65.0	64.91	64.967	485782.0
2017-03-27 14:00:00	MSFT	Stock	64.96	65.03	64.9	64.96	692200.0
2017-03-27 14:30:00	MSFT	Stock	64.96	65.1	64.89	65.087	941931.0

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

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