PREVIEW / stock_30min / 2018-02-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-26.parquet
  size:    1.7 MB
  rows:    83,903
  symbols: 2,895

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-26 04:00:00	AAPL	Stock	44.0	44.0375	44.0	44.0375	12788.0
2018-02-26 04:30:00	AAPL	Stock	44.0475	44.05	44.025	44.025	10912.0
2018-02-26 05:00:00	AAPL	Stock	44.02	44.045	44.0	44.0025	19120.0
2018-02-26 05:30:00	AAPL	Stock	44.0025	44.0125	43.9825	44.0125	7440.0
2018-02-26 06:00:00	AAPL	Stock	44.0	44.05	43.9775	44.015	34692.0
2018-02-26 06:30:00	AAPL	Stock	44.0	44.02	43.9775	44.02	41076.0
2018-02-26 07:00:00	AAPL	Stock	44.0	44.06	43.99	44.0075	160496.0
2018-02-26 07:30:00	AAPL	Stock	44.0025	44.1075	44.0025	44.1075	226044.0
2018-02-26 08:00:00	AAPL	Stock	44.11	44.15	44.0175	44.075	417748.0
2018-02-26 08:30:00	AAPL	Stock	44.0675	44.125	44.065	44.075	158480.0
2018-02-26 09:00:00	AAPL	Stock	44.0675	44.1625	44.0625	44.0925	467624.0
2018-02-26 09:30:00	AAPL	Stock	44.0875	44.5	44.0525	44.4312	23430528.0
2018-02-26 10:00:00	AAPL	Stock	44.4312	44.6025	44.3875	44.4525	15522000.0
2018-02-26 10:30:00	AAPL	Stock	44.4525	44.465	44.325	44.4125	8771976.0
2018-02-26 11:00:00	AAPL	Stock	44.415	44.675	44.3998	44.67	10798088.0
2018-02-26 11:30:00	AAPL	Stock	44.67	44.75	44.64	44.7075	8114464.0
2018-02-26 12:00:00	AAPL	Stock	44.7075	44.785	44.6225	44.73	8582256.0
2018-02-26 12:30:00	AAPL	Stock	44.7325	44.755	44.585	44.635	6601940.0
2018-02-26 13:00:00	AAPL	Stock	44.6338	44.75	44.6275	44.75	4425336.0
2018-02-26 13:30:00	AAPL	Stock	44.7475	44.7482	44.6875	44.7362	3664288.0
2018-02-26 14:00:00	AAPL	Stock	44.7368	44.83	44.5162	44.7825	7075064.0
2018-02-26 14:30:00	AAPL	Stock	44.785	44.8475	44.7325	44.7537	5794740.0
2018-02-26 15:00:00	AAPL	Stock	44.7525	44.825	44.7	44.76	7467488.0
2018-02-26 15:30:00	AAPL	Stock	44.76	44.825	44.625	44.745	13504408.0
2018-02-26 16:00:00	AAPL	Stock	44.7425	44.775	44.5625	44.775	9101800.0
2018-02-26 16:30:00	AAPL	Stock	44.7675	44.7725	44.7425	44.75	91896.0
2018-02-26 17:00:00	AAPL	Stock	44.7625	44.775	44.725	44.7425	2038652.0
2018-02-26 17:30:00	AAPL	Stock	44.74	44.75	44.7275	44.75	34108.0
2018-02-26 18:00:00	AAPL	Stock	44.7425	44.75	44.74	44.74	12148.0
2018-02-26 18:30:00	AAPL	Stock	44.75	44.7575	44.7375	44.7575	38564.0
2018-02-26 19:00:00	AAPL	Stock	44.7575	44.775	44.7475	44.7475	32140.0
2018-02-26 19:30:00	AAPL	Stock	44.75	44.7625	44.7275	44.7625	47128.0
2018-02-26 04:00:00	MSFT	Stock	94.2	94.49	94.2	94.49	200.0
2018-02-26 04:30:00	MSFT	Stock	94.49	94.49	94.49	94.49	150.0
2018-02-26 05:00:00	MSFT	Stock	94.49	94.49	94.49	94.49	1000.0
2018-02-26 07:00:00	MSFT	Stock	94.23	94.46	94.23	94.43	11077.0
2018-02-26 07:30:00	MSFT	Stock	94.35	94.58	94.35	94.51	32059.0
2018-02-26 08:00:00	MSFT	Stock	94.21	94.6	94.21	94.6	17588.0
2018-02-26 08:30:00	MSFT	Stock	94.52	94.56	94.5	94.5	9426.0
2018-02-26 09:00:00	MSFT	Stock	94.53	94.55	94.22	94.3	40545.0
2018-02-26 09:30:00	MSFT	Stock	94.38	94.98	94.25	94.91	3289709.0
2018-02-26 10:00:00	MSFT	Stock	94.91	95.22	94.85	94.85	2792426.0
2018-02-26 10:30:00	MSFT	Stock	94.86	95.0	94.715	94.83	1442200.0
2018-02-26 11:00:00	MSFT	Stock	94.83	95.14	94.77	95.121	1504231.0
2018-02-26 11:30:00	MSFT	Stock	95.12	95.24	94.86	94.87	1223751.0
2018-02-26 12:00:00	MSFT	Stock	94.86	95.01	94.79	94.98	1241520.0
2018-02-26 12:30:00	MSFT	Stock	94.99	95.0	94.85	94.93	1149310.0
2018-02-26 13:00:00	MSFT	Stock	94.93	95.12	94.929	95.1	1304031.0
2018-02-26 13:30:00	MSFT	Stock	95.09	95.11	94.98	95.0	811109.0
2018-02-26 14:00:00	MSFT	Stock	95.0	95.25	94.955	95.16	1276880.0

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

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