PREVIEW / stock_30min / 2018-04-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-02.parquet
  size:    1.7 MB
  rows:    83,207
  symbols: 2,881

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-02 04:00:00	AAPL	Stock	41.9	41.9775	41.85	41.925	22568.0
2018-04-02 04:30:00	AAPL	Stock	41.93	41.95	41.925	41.95	6976.0
2018-04-02 05:00:00	AAPL	Stock	41.95	41.95	41.925	41.9275	30000.0
2018-04-02 05:30:00	AAPL	Stock	41.9375	41.9375	41.9375	41.9375	760.0
2018-04-02 06:00:00	AAPL	Stock	42.0175	42.0475	42.0	42.02	20936.0
2018-04-02 06:30:00	AAPL	Stock	42.0	42.0	41.975	41.975	6740.0
2018-04-02 07:00:00	AAPL	Stock	42.0	42.0	41.815	41.8525	151388.0
2018-04-02 07:30:00	AAPL	Stock	41.8425	41.8425	41.79	41.8	64948.0
2018-04-02 08:00:00	AAPL	Stock	41.8125	41.975	41.8025	41.8975	147828.0
2018-04-02 08:30:00	AAPL	Stock	41.8425	41.9675	41.8425	41.9625	118436.0
2018-04-02 09:00:00	AAPL	Stock	41.925	42.0025	41.9065	41.9525	285728.0
2018-04-02 09:30:00	AAPL	Stock	41.97	42.235	41.8325	41.9725	16377340.0
2018-04-02 10:00:00	AAPL	Stock	41.9855	42.0	41.81	41.87	7907688.0
2018-04-02 10:30:00	AAPL	Stock	41.8688	41.9248	41.71	41.7425	6840020.0
2018-04-02 11:00:00	AAPL	Stock	41.7425	41.7825	41.555	41.7412	7813160.0
2018-04-02 11:30:00	AAPL	Stock	41.74	41.75	41.2	41.335	11765184.0
2018-04-02 12:00:00	AAPL	Stock	41.3325	41.5525	41.1875	41.5222	8639740.0
2018-04-02 12:30:00	AAPL	Stock	41.515	41.64	41.38	41.43	6423740.0
2018-04-02 13:00:00	AAPL	Stock	41.425	41.4825	41.2125	41.23	5178296.0
2018-04-02 13:30:00	AAPL	Stock	41.2275	41.4725	41.22	41.3	6999488.0
2018-04-02 14:00:00	AAPL	Stock	41.3	41.4275	41.1175	41.3	9368408.0
2018-04-02 14:30:00	AAPL	Stock	41.2975	41.5325	41.215	41.525	7677308.0
2018-04-02 15:00:00	AAPL	Stock	41.525	41.6825	41.45	41.5125	9290776.0
2018-04-02 15:30:00	AAPL	Stock	41.5125	41.765	41.33	41.67	16214680.0
2018-04-02 16:00:00	AAPL	Stock	41.6575	41.67	41.3128	41.67	12693340.0
2018-04-02 16:30:00	AAPL	Stock	41.57	41.67	41.57	41.625	197776.0
2018-04-02 17:00:00	AAPL	Stock	41.65	41.65	41.585	41.585	22440.0
2018-04-02 17:30:00	AAPL	Stock	41.575	41.585	41.5625	41.5775	72748.0
2018-04-02 18:00:00	AAPL	Stock	41.58	41.65	41.58	41.6225	30596.0
2018-04-02 18:30:00	AAPL	Stock	41.625	41.6375	41.6025	41.6125	33864.0
2018-04-02 19:00:00	AAPL	Stock	41.62	41.625	41.5875	41.615	20132.0
2018-04-02 19:30:00	AAPL	Stock	41.6325	41.65	41.625	41.645	73704.0
2018-04-02 04:00:00	MSFT	Stock	91.38	91.38	91.3	91.3	340.0
2018-04-02 06:00:00	MSFT	Stock	90.8	90.8	90.5	90.5	300.0
2018-04-02 07:00:00	MSFT	Stock	91.0	91.0	90.35	90.6	5273.0
2018-04-02 07:30:00	MSFT	Stock	90.47	90.65	90.47	90.5	3535.0
2018-04-02 08:00:00	MSFT	Stock	90.5	91.0	90.35	90.7	16570.0
2018-04-02 08:30:00	MSFT	Stock	91.27	91.27	90.66	91.27	13267.0
2018-04-02 09:00:00	MSFT	Stock	90.85	90.94	90.47	90.48	16812.0
2018-04-02 09:30:00	MSFT	Stock	90.47	90.88	90.3	90.45	2969502.0
2018-04-02 10:00:00	MSFT	Stock	90.45	90.47	89.56	89.65	2165969.0
2018-04-02 10:30:00	MSFT	Stock	89.65	89.965	89.3	89.5	1962251.0
2018-04-02 11:00:00	MSFT	Stock	89.49	89.52	88.88	89.49	2495873.0
2018-04-02 11:30:00	MSFT	Stock	89.49	89.5	88.17	88.36	2896197.0
2018-04-02 12:00:00	MSFT	Stock	88.36	88.85	88.02	88.741	2484868.0
2018-04-02 12:30:00	MSFT	Stock	88.74	89.29	88.71	88.85	1976706.0
2018-04-02 13:00:00	MSFT	Stock	88.85	88.985	87.92	87.998	2393195.0
2018-04-02 13:30:00	MSFT	Stock	87.99	88.43	87.94	88.05	2662470.0
2018-04-02 14:00:00	MSFT	Stock	88.05	88.31	87.74	87.77	2655938.0
2018-04-02 14:30:00	MSFT	Stock	87.77	88.17	87.51	88.14	2452425.0

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

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