PREVIEW / stock_30min / 2018-08-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-31.parquet
  size:    1.6 MB
  rows:    82,079
  symbols: 2,788

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-08-31 04:00:00	AAPL	Stock	56.36	56.375	56.325	56.375	20088.0
2018-08-31 04:30:00	AAPL	Stock	56.3275	56.375	56.325	56.33	6760.0
2018-08-31 05:00:00	AAPL	Stock	56.4375	56.4525	56.4125	56.45	10548.0
2018-08-31 05:30:00	AAPL	Stock	56.4425	56.4725	56.33	56.33	21684.0
2018-08-31 06:00:00	AAPL	Stock	56.305	56.37	56.305	56.37	2800.0
2018-08-31 06:30:00	AAPL	Stock	56.3925	56.4	56.3675	56.395	14048.0
2018-08-31 07:00:00	AAPL	Stock	56.4	56.4575	56.375	56.4	144300.0
2018-08-31 07:30:00	AAPL	Stock	56.395	56.45	56.37	56.4325	142756.0
2018-08-31 08:00:00	AAPL	Stock	56.41	56.62	56.3625	56.575	796760.0
2018-08-31 08:30:00	AAPL	Stock	56.5725	56.5925	56.475	56.4775	421008.0
2018-08-31 09:00:00	AAPL	Stock	56.48	56.6875	56.4625	56.63	508060.0
2018-08-31 09:30:00	AAPL	Stock	56.6275	57.07	56.5525	56.959	22947444.0
2018-08-31 10:00:00	AAPL	Stock	56.9575	57.2175	56.84	56.9075	16433196.0
2018-08-31 10:30:00	AAPL	Stock	56.91	57.095	56.8225	57.0175	9015912.0
2018-08-31 11:00:00	AAPL	Stock	57.0162	57.145	56.8375	56.8428	7944848.0
2018-08-31 11:30:00	AAPL	Stock	56.845	56.8975	56.655	56.765	8656960.0
2018-08-31 12:00:00	AAPL	Stock	56.765	56.9925	56.7175	56.9475	6644980.0
2018-08-31 12:30:00	AAPL	Stock	56.9452	57.1175	56.8575	57.1125	7261072.0
2018-08-31 13:00:00	AAPL	Stock	57.1105	57.16	56.9425	56.9528	5396524.0
2018-08-31 13:30:00	AAPL	Stock	56.9522	57.0298	56.875	56.9652	4196056.0
2018-08-31 14:00:00	AAPL	Stock	56.9675	56.9825	56.7598	56.881	4986924.0
2018-08-31 14:30:00	AAPL	Stock	56.885	56.94	56.8412	56.8795	4192828.0
2018-08-31 15:00:00	AAPL	Stock	56.878	56.9808	56.7875	56.8248	6126040.0
2018-08-31 15:30:00	AAPL	Stock	56.825	57.0075	56.825	56.8775	16584724.0
2018-08-31 16:00:00	AAPL	Stock	56.875	56.97	56.875	56.9225	24409720.0
2018-08-31 16:30:00	AAPL	Stock	56.9225	56.945	56.9075	56.945	711344.0
2018-08-31 17:00:00	AAPL	Stock	56.9475	56.975	56.925	56.975	42640.0
2018-08-31 17:30:00	AAPL	Stock	56.975	56.975	56.9375	56.955	61544.0
2018-08-31 18:00:00	AAPL	Stock	56.975	56.975	56.9425	56.97	29080.0
2018-08-31 18:30:00	AAPL	Stock	56.955	56.9725	56.9325	56.9625	35372.0
2018-08-31 19:00:00	AAPL	Stock	56.95	56.9825	56.95	56.9825	23960.0
2018-08-31 19:30:00	AAPL	Stock	56.9875	57.0	56.975	56.9825	28508.0
2018-08-31 04:00:00	MSFT	Stock	111.78	111.78	111.78	111.78	100.0
2018-08-31 07:00:00	MSFT	Stock	111.6	111.61	111.6	111.61	878.0
2018-08-31 07:30:00	MSFT	Stock	111.63	111.79	111.62	111.79	791.0
2018-08-31 08:00:00	MSFT	Stock	111.92	111.92	111.56	111.77	5019.0
2018-08-31 08:30:00	MSFT	Stock	111.77	111.83	111.7	111.7	6308.0
2018-08-31 09:00:00	MSFT	Stock	111.62	111.72	111.51	111.51	44078.0
2018-08-31 09:30:00	MSFT	Stock	111.59	112.4	111.55	112.22	2136632.0
2018-08-31 10:00:00	MSFT	Stock	112.21	112.77	112.15	112.631	1346178.0
2018-08-31 10:30:00	MSFT	Stock	112.64	112.75	112.5	112.71	877232.0
2018-08-31 11:00:00	MSFT	Stock	112.708	112.777	112.39	112.41	998304.0
2018-08-31 11:30:00	MSFT	Stock	112.42	112.44	111.9	111.9	1369068.0
2018-08-31 12:00:00	MSFT	Stock	111.9	112.09	111.78	112.03	930891.0
2018-08-31 12:30:00	MSFT	Stock	112.04	112.045	111.85	111.96	630397.0
2018-08-31 13:00:00	MSFT	Stock	111.955	111.955	111.785	111.88	383439.0
2018-08-31 13:30:00	MSFT	Stock	111.87	111.93	111.76	111.88	474108.0
2018-08-31 14:00:00	MSFT	Stock	111.88	111.9	111.515	111.723	808194.0
2018-08-31 14:30:00	MSFT	Stock	111.72	111.85	111.67	111.73	642849.0
2018-08-31 15:00:00	MSFT	Stock	111.73	112.037	111.73	111.855	900137.0

> showing 50 of 82,079 rows — these rows as CSV

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