PREVIEW / stock_30min / 2017-08-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-01.parquet
  size:    1.6 MB
  rows:    81,659
  symbols: 2,995

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-08-01 04:00:00	AAPL	Stock	37.2625	37.3225	37.1875	37.3225	22344.0
2017-08-01 05:00:00	AAPL	Stock	37.325	37.3425	37.325	37.3275	15984.0
2017-08-01 05:30:00	AAPL	Stock	37.3525	37.3525	37.33	37.33	1004.0
2017-08-01 06:00:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	400.0
2017-08-01 06:30:00	AAPL	Stock	37.2925	37.3175	37.2875	37.3025	51660.0
2017-08-01 07:00:00	AAPL	Stock	37.3125	37.3125	37.2125	37.2375	49736.0
2017-08-01 07:30:00	AAPL	Stock	37.25	37.275	37.2475	37.275	45348.0
2017-08-01 08:00:00	AAPL	Stock	37.3225	37.3225	37.1825	37.245	231640.0
2017-08-01 08:30:00	AAPL	Stock	37.2425	37.2925	37.2375	37.27	135196.0
2017-08-01 09:00:00	AAPL	Stock	37.275	37.335	37.25	37.2875	146128.0
2017-08-01 09:30:00	AAPL	Stock	37.275	37.355	37.1675	37.2025	11042728.0
2017-08-01 10:00:00	AAPL	Stock	37.1975	37.265	37.15	37.205	6648200.0
2017-08-01 10:30:00	AAPL	Stock	37.2062	37.33	37.205	37.31	6773872.0
2017-08-01 11:00:00	AAPL	Stock	37.31	37.3125	37.1025	37.15	5498856.0
2017-08-01 11:30:00	AAPL	Stock	37.15	37.245	37.15	37.2418	4806152.0
2017-08-01 12:00:00	AAPL	Stock	37.241	37.2425	37.175	37.1975	3113760.0
2017-08-01 12:30:00	AAPL	Stock	37.1965	37.2625	37.1825	37.2625	3429368.0
2017-08-01 13:00:00	AAPL	Stock	37.2612	37.295	37.2275	37.245	3814744.0
2017-08-01 13:30:00	AAPL	Stock	37.2475	37.2725	37.2338	37.2575	3164400.0
2017-08-01 14:00:00	AAPL	Stock	37.2562	37.3312	37.2475	37.3125	5230652.0
2017-08-01 14:30:00	AAPL	Stock	37.315	37.3375	37.27	37.335	4452856.0
2017-08-01 15:00:00	AAPL	Stock	37.335	37.355	37.2425	37.32	7238792.0
2017-08-01 15:30:00	AAPL	Stock	37.3175	37.555	37.29	37.5125	18998320.0
2017-08-01 16:00:00	AAPL	Stock	37.5125	37.585	37.3375	37.425	4497016.0
2017-08-01 16:30:00	AAPL	Stock	37.4625	39.6925	37.4625	39.45	24300040.0
2017-08-01 17:00:00	AAPL	Stock	39.455	39.975	39.4525	39.7125	8799368.0
2017-08-01 17:30:00	AAPL	Stock	39.725	39.9175	39.725	39.9	2416728.0
2017-08-01 18:00:00	AAPL	Stock	39.895	39.96	39.7625	39.805	1235784.0
2017-08-01 18:30:00	AAPL	Stock	39.8125	39.825	39.75	39.7825	735524.0
2017-08-01 19:00:00	AAPL	Stock	39.7875	39.8275	39.755	39.8175	473940.0
2017-08-01 19:30:00	AAPL	Stock	39.8125	39.9	39.8	39.875	742256.0
2017-08-01 04:00:00	MSFT	Stock	72.99	72.99	72.99	72.99	200.0
2017-08-01 06:30:00	MSFT	Stock	72.9	72.9	72.9	72.9	1500.0
2017-08-01 07:00:00	MSFT	Stock	72.9	72.9	72.9	72.9	3447.0
2017-08-01 07:30:00	MSFT	Stock	72.9	72.95	72.9	72.95	1552.0
2017-08-01 08:00:00	MSFT	Stock	72.81	72.85	72.81	72.85	1187.0
2017-08-01 08:30:00	MSFT	Stock	72.94	72.95	72.7	72.7	3942.0
2017-08-01 09:00:00	MSFT	Stock	73.0	73.22	72.93	73.06	63476.0
2017-08-01 09:30:00	MSFT	Stock	73.04	73.42	72.88	73.03	2285128.0
2017-08-01 10:00:00	MSFT	Stock	73.02	73.05	72.78	72.895	1591654.0
2017-08-01 10:30:00	MSFT	Stock	72.9	73.04	72.82	72.98	1323181.0
2017-08-01 11:00:00	MSFT	Stock	72.971	73.0	72.76	72.79	1039127.0
2017-08-01 11:30:00	MSFT	Stock	72.79	72.88	72.76	72.84	895169.0
2017-08-01 12:00:00	MSFT	Stock	72.84	72.88	72.76	72.78	840717.0
2017-08-01 12:30:00	MSFT	Stock	72.78	72.81	72.72	72.725	725542.0
2017-08-01 13:00:00	MSFT	Stock	72.725	72.82	72.71	72.8	1149558.0
2017-08-01 13:30:00	MSFT	Stock	72.8	72.81	72.77	72.795	735367.0
2017-08-01 14:00:00	MSFT	Stock	72.797	72.81	72.7	72.723	720071.0
2017-08-01 14:30:00	MSFT	Stock	72.72	72.77	72.635	72.695	735504.0
2017-08-01 15:00:00	MSFT	Stock	72.69	72.719	72.62	72.65	832503.0

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

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