PREVIEW / stock_30min / 2018-04-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-04.parquet
  size:    1.7 MB
  rows:    83,668
  symbols: 2,869

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-04-04 04:00:00	AAPL	Stock	41.4375	41.4375	41.1125	41.1125	26164.0
2018-04-04 04:30:00	AAPL	Stock	41.14	41.225	41.14	41.2	28080.0
2018-04-04 05:00:00	AAPL	Stock	41.105	41.105	41.0675	41.0675	16716.0
2018-04-04 05:30:00	AAPL	Stock	41.1525	41.225	41.1275	41.1575	21876.0
2018-04-04 06:00:00	AAPL	Stock	41.105	41.105	40.8975	40.9625	29676.0
2018-04-04 06:30:00	AAPL	Stock	40.975	41.0725	40.925	41.0725	18920.0
2018-04-04 07:00:00	AAPL	Stock	41.1	41.25	41.0625	41.19	164512.0
2018-04-04 07:30:00	AAPL	Stock	41.19	41.385	41.165	41.3625	206196.0
2018-04-04 08:00:00	AAPL	Stock	41.175	41.475	41.025	41.3025	542488.0
2018-04-04 08:30:00	AAPL	Stock	41.2925	41.425	41.22	41.3775	197160.0
2018-04-04 09:00:00	AAPL	Stock	41.375	41.3775	41.19	41.2125	341860.0
2018-04-04 09:30:00	AAPL	Stock	41.22	41.73	41.1925	41.6	15526596.0
2018-04-04 10:00:00	AAPL	Stock	41.6025	41.75	41.4075	41.575	8871624.0
2018-04-04 10:30:00	AAPL	Stock	41.5825	42.0225	41.46	42.0175	7723404.0
2018-04-04 11:00:00	AAPL	Stock	42.0182	42.375	41.8525	42.265	9226472.0
2018-04-04 11:30:00	AAPL	Stock	42.2625	42.4475	42.2075	42.355	8562172.0
2018-04-04 12:00:00	AAPL	Stock	42.35	42.6325	42.3188	42.5125	8043912.0
2018-04-04 12:30:00	AAPL	Stock	42.5125	42.5575	42.345	42.3975	5103668.0
2018-04-04 13:00:00	AAPL	Stock	42.4025	42.43	42.1175	42.2425	5203700.0
2018-04-04 13:30:00	AAPL	Stock	42.2425	42.3975	42.205	42.355	4037240.0
2018-04-04 14:00:00	AAPL	Stock	42.365	42.7225	42.3375	42.7135	6258712.0
2018-04-04 14:30:00	AAPL	Stock	42.715	42.75	42.55	42.7325	6386864.0
2018-04-04 15:00:00	AAPL	Stock	42.73	42.85	42.6675	42.8075	10032876.0
2018-04-04 15:30:00	AAPL	Stock	42.81	43.0025	42.8075	42.895	14977992.0
2018-04-04 16:00:00	AAPL	Stock	42.9025	42.9025	42.0975	42.8975	9338144.0
2018-04-04 16:30:00	AAPL	Stock	42.9025	42.9025	42.86	42.875	88196.0
2018-04-04 17:00:00	AAPL	Stock	42.8875	42.91	42.865	42.91	43740.0
2018-04-04 17:30:00	AAPL	Stock	42.92	42.945	42.88	42.9	20904.0
2018-04-04 18:00:00	AAPL	Stock	42.9	42.9375	42.9	42.9225	11264.0
2018-04-04 18:30:00	AAPL	Stock	42.9325	42.9475	42.9275	42.9425	10124.0
2018-04-04 19:00:00	AAPL	Stock	42.95	42.96	42.95	42.95	7796.0
2018-04-04 19:30:00	AAPL	Stock	42.9875	43.0	42.9825	42.995	21300.0
2018-04-04 04:00:00	MSFT	Stock	88.65	88.65	87.91	88.11	21117.0
2018-04-04 04:30:00	MSFT	Stock	88.02	88.55	88.02	88.55	1857.0
2018-04-04 05:00:00	MSFT	Stock	88.12	88.13	88.12	88.13	8244.0
2018-04-04 05:30:00	MSFT	Stock	88.3	88.3	88.24	88.24	4800.0
2018-04-04 06:00:00	MSFT	Stock	88.16	88.16	87.7	87.83	5818.0
2018-04-04 06:30:00	MSFT	Stock	87.95	88.15	87.86	87.91	1785.0
2018-04-04 07:00:00	MSFT	Stock	88.0	88.38	88.0	88.13	24439.0
2018-04-04 07:30:00	MSFT	Stock	88.29	88.49	88.15	88.16	6786.0
2018-04-04 08:00:00	MSFT	Stock	87.96	88.4	87.96	88.15	35655.0
2018-04-04 08:30:00	MSFT	Stock	88.05	88.39	87.99	88.29	28256.0
2018-04-04 09:00:00	MSFT	Stock	88.28	88.29	87.92	87.92	55831.0
2018-04-04 09:30:00	MSFT	Stock	87.91	88.87	87.73	88.835	3745066.0
2018-04-04 10:00:00	MSFT	Stock	88.83	88.86	88.27	88.66	2090326.0
2018-04-04 10:30:00	MSFT	Stock	88.68	89.305	88.36	89.23	2046930.0
2018-04-04 11:00:00	MSFT	Stock	89.22	89.57	88.84	89.44	1487869.0
2018-04-04 11:30:00	MSFT	Stock	89.445	89.9	89.39	89.78	1586470.0
2018-04-04 12:00:00	MSFT	Stock	89.79	90.374	89.6	90.24	1633942.0
2018-04-04 12:30:00	MSFT	Stock	90.25	90.54	90.06	90.3	1317977.0

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

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