PREVIEW / stock_30min / 2018-02-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-21.parquet
  size:    1.7 MB
  rows:    82,705
  symbols: 2,876

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-02-21 04:00:00	AAPL	Stock	42.975	42.975	42.925	42.975	13972.0
2018-02-21 04:30:00	AAPL	Stock	42.975	42.975	42.9025	42.9025	6888.0
2018-02-21 05:00:00	AAPL	Stock	42.955	43.045	42.955	43.02	8536.0
2018-02-21 05:30:00	AAPL	Stock	42.995	43.0575	42.995	43.045	23040.0
2018-02-21 06:00:00	AAPL	Stock	43.0525	43.0525	43.0025	43.0175	19044.0
2018-02-21 06:30:00	AAPL	Stock	43.0	43.0625	42.9675	43.0625	45440.0
2018-02-21 07:00:00	AAPL	Stock	43.03	43.15	43.0275	43.1225	165528.0
2018-02-21 07:30:00	AAPL	Stock	43.1	43.1475	43.0775	43.1225	31532.0
2018-02-21 08:00:00	AAPL	Stock	43.125	43.2775	43.025	43.2625	253984.0
2018-02-21 08:30:00	AAPL	Stock	43.275	43.335	43.225	43.275	259884.0
2018-02-21 09:00:00	AAPL	Stock	43.26	43.325	43.15	43.2	269944.0
2018-02-21 09:30:00	AAPL	Stock	43.2075	43.3975	43.1062	43.2575	14351164.0
2018-02-21 10:00:00	AAPL	Stock	43.2588	43.3625	43.2025	43.33	7670344.0
2018-02-21 10:30:00	AAPL	Stock	43.33	43.445	43.3175	43.425	10433976.0
2018-02-21 11:00:00	AAPL	Stock	43.425	43.4525	43.245	43.4032	8721748.0
2018-02-21 11:30:00	AAPL	Stock	43.4025	43.5175	43.39	43.425	8245552.0
2018-02-21 12:00:00	AAPL	Stock	43.425	43.435	43.195	43.2788	8310324.0
2018-02-21 12:30:00	AAPL	Stock	43.28	43.3025	43.165	43.2725	4853616.0
2018-02-21 13:00:00	AAPL	Stock	43.27	43.285	43.19	43.2725	3371676.0
2018-02-21 13:30:00	AAPL	Stock	43.274	43.355	43.2525	43.33	4141720.0
2018-02-21 14:00:00	AAPL	Stock	43.33	43.53	43.2725	43.455	11658108.0
2018-02-21 14:30:00	AAPL	Stock	43.455	43.5275	43.325	43.3575	8151596.0
2018-02-21 15:00:00	AAPL	Stock	43.3575	43.3725	43.0125	43.1675	13176252.0
2018-02-21 15:30:00	AAPL	Stock	43.1675	43.25	42.7525	42.7525	18137356.0
2018-02-21 16:00:00	AAPL	Stock	42.7675	42.8675	42.65	42.755	11218336.0
2018-02-21 16:30:00	AAPL	Stock	42.755	42.775	42.7125	42.7125	703948.0
2018-02-21 17:00:00	AAPL	Stock	42.7125	42.7125	42.675	42.6825	69240.0
2018-02-21 17:30:00	AAPL	Stock	42.7075	42.735	42.675	42.735	46268.0
2018-02-21 18:00:00	AAPL	Stock	42.73	42.745	42.68	42.7125	51280.0
2018-02-21 18:30:00	AAPL	Stock	42.7175	42.725	42.63	42.6675	103428.0
2018-02-21 19:00:00	AAPL	Stock	42.6375	42.68	42.6375	42.6625	55532.0
2018-02-21 19:30:00	AAPL	Stock	42.6625	42.6875	42.605	42.6375	54836.0
2018-02-21 04:00:00	MSFT	Stock	92.37	92.37	92.37	92.37	100.0
2018-02-21 06:30:00	MSFT	Stock	92.71	92.71	92.71	92.71	492.0
2018-02-21 07:00:00	MSFT	Stock	92.84	92.99	92.84	92.9	2905.0
2018-02-21 07:30:00	MSFT	Stock	92.85	92.99	92.85	92.99	1386.0
2018-02-21 08:00:00	MSFT	Stock	92.95	93.09	92.85	92.9	14088.0
2018-02-21 08:30:00	MSFT	Stock	92.99	93.0	92.89	92.91	2174.0
2018-02-21 09:00:00	MSFT	Stock	92.95	93.17	92.95	93.08	41992.0
2018-02-21 09:30:00	MSFT	Stock	93.01	93.14	92.83	93.01	2203161.0
2018-02-21 10:00:00	MSFT	Stock	93.02	93.36	92.93	93.21	1710345.0
2018-02-21 10:30:00	MSFT	Stock	93.21	93.28	92.97	93.14	1388977.0
2018-02-21 11:00:00	MSFT	Stock	93.14	93.21	93.06	93.115	1108134.0
2018-02-21 11:30:00	MSFT	Stock	93.12	93.19	92.78	92.82	964576.0
2018-02-21 12:00:00	MSFT	Stock	92.815	93.01	92.75	92.83	895297.0
2018-02-21 12:30:00	MSFT	Stock	92.82	92.852	92.68	92.83	813293.0
2018-02-21 13:00:00	MSFT	Stock	92.82	92.9	92.545	92.6	660870.0
2018-02-21 13:30:00	MSFT	Stock	92.595	92.783	92.445	92.715	1013244.0
2018-02-21 14:00:00	MSFT	Stock	92.71	93.3	92.58	93.13	2346308.0
2018-02-21 14:30:00	MSFT	Stock	93.14	93.23	92.69	92.79	1301381.0

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

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