PREVIEW / stock_30min / 2019-03-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-01.parquet
  size:    1.7 MB
  rows:    84,794
  symbols: 2,665

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
2019-03-01 04:00:00	AAPL	Stock	43.5125	43.5625	43.5125	43.5575	3064.0
2019-03-01 04:30:00	AAPL	Stock	43.5875	43.6475	43.5875	43.61	3424.0
2019-03-01 05:00:00	AAPL	Stock	43.5925	43.5925	43.5925	43.5925	400.0
2019-03-01 05:30:00	AAPL	Stock	43.6025	43.6025	43.5925	43.5925	1276.0
2019-03-01 06:00:00	AAPL	Stock	43.5925	43.6	43.5925	43.6	1200.0
2019-03-01 06:30:00	AAPL	Stock	43.575	43.575	43.575	43.575	400.0
2019-03-01 07:00:00	AAPL	Stock	43.585	43.625	43.5775	43.6225	40604.0
2019-03-01 07:30:00	AAPL	Stock	43.6	43.62	43.5825	43.6	36384.0
2019-03-01 08:00:00	AAPL	Stock	43.6075	43.6375	43.2875	43.555	122460.0
2019-03-01 08:30:00	AAPL	Stock	43.55	43.5625	43.5	43.505	105440.0
2019-03-01 09:00:00	AAPL	Stock	43.5175	43.585	43.5175	43.585	66524.0
2019-03-01 09:30:00	AAPL	Stock	43.57	43.62	43.3948	43.555	8822296.0
2019-03-01 10:00:00	AAPL	Stock	43.5525	43.5538	43.3575	43.4052	5733140.0
2019-03-01 10:30:00	AAPL	Stock	43.4075	43.485	43.345	43.42	4172392.0
2019-03-01 11:00:00	AAPL	Stock	43.4212	43.4263	43.2225	43.3325	5800608.0
2019-03-01 11:30:00	AAPL	Stock	43.3325	43.3525	43.2275	43.3348	4774052.0
2019-03-01 12:00:00	AAPL	Stock	43.335	43.475	43.325	43.4612	4740840.0
2019-03-01 12:30:00	AAPL	Stock	43.4625	43.56	43.4525	43.5475	4949832.0
2019-03-01 13:00:00	AAPL	Stock	43.5475	43.58	43.505	43.536	3444380.0
2019-03-01 13:30:00	AAPL	Stock	43.5375	43.6575	43.53	43.6287	3761856.0
2019-03-01 14:00:00	AAPL	Stock	43.63	43.785	43.5825	43.775	6786032.0
2019-03-01 14:30:00	AAPL	Stock	43.777	43.7875	43.6875	43.7445	4283288.0
2019-03-01 15:00:00	AAPL	Stock	43.745	43.745	43.67	43.6975	4530452.0
2019-03-01 15:30:00	AAPL	Stock	43.7025	43.7825	43.694	43.7425	10867632.0
2019-03-01 16:00:00	AAPL	Stock	43.7425	43.765	43.7125	43.7625	16835212.0
2019-03-01 16:30:00	AAPL	Stock	43.76	43.77	43.7475	43.7475	167996.0
2019-03-01 17:00:00	AAPL	Stock	43.75	43.75	43.7375	43.7375	10724.0
2019-03-01 17:30:00	AAPL	Stock	43.7425	43.7575	43.7425	43.7575	19300.0
2019-03-01 18:00:00	AAPL	Stock	43.7575	43.775	43.755	43.77	8872.0
2019-03-01 18:30:00	AAPL	Stock	43.7625	43.77	43.7625	43.77	4376.0
2019-03-01 19:00:00	AAPL	Stock	43.7575	43.775	43.7575	43.7625	8488.0
2019-03-01 19:30:00	AAPL	Stock	43.765	43.78	43.765	43.78	21944.0
2019-03-01 04:00:00	MSFT	Stock	113.0	113.0	113.0	113.0	419.0
2019-03-01 04:30:00	MSFT	Stock	112.83	112.83	112.83	112.83	671.0
2019-03-01 05:00:00	MSFT	Stock	112.95	112.95	112.95	112.95	1017.0
2019-03-01 05:30:00	MSFT	Stock	112.95	112.98	112.93	112.98	1835.0
2019-03-01 06:00:00	MSFT	Stock	112.98	113.2	112.98	113.09	6319.0
2019-03-01 06:30:00	MSFT	Stock	113.1	113.15	113.0	113.0	1580.0
2019-03-01 07:00:00	MSFT	Stock	112.89	113.06	112.8	112.85	17894.0
2019-03-01 07:30:00	MSFT	Stock	112.85	112.85	112.78	112.8	18841.0
2019-03-01 08:00:00	MSFT	Stock	112.95	113.0	112.7	112.8	24545.0
2019-03-01 08:30:00	MSFT	Stock	112.8	112.85	112.7	112.75	10308.0
2019-03-01 09:00:00	MSFT	Stock	112.78	112.95	112.72	112.8	22322.0
2019-03-01 09:30:00	MSFT	Stock	112.87	113.02	112.36	112.49	2963533.0
2019-03-01 10:00:00	MSFT	Stock	112.46	112.53	112.016	112.12	1524616.0
2019-03-01 10:30:00	MSFT	Stock	112.12	112.29	111.955	112.077	961282.0
2019-03-01 11:00:00	MSFT	Stock	112.08	112.121	111.85	112.015	997345.0
2019-03-01 11:30:00	MSFT	Stock	112.02	112.086	111.665	111.83	948212.0
2019-03-01 12:00:00	MSFT	Stock	111.82	112.15	111.764	112.117	807986.0
2019-03-01 12:30:00	MSFT	Stock	112.115	112.41	112.11	112.37	779513.0

> showing 50 of 84,794 rows — these rows as CSV

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