PREVIEW / stock_30min / 2018-05-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-01.parquet
  size:    1.6 MB
  rows:    81,339
  symbols: 2,840

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-05-01 04:00:00	AAPL	Stock	41.55	41.55	41.535	41.55	9504.0
2018-05-01 04:30:00	AAPL	Stock	41.525	41.5975	41.495	41.5	12188.0
2018-05-01 06:00:00	AAPL	Stock	41.47	41.47	41.425	41.425	2800.0
2018-05-01 06:30:00	AAPL	Stock	41.475	41.5275	41.475	41.475	3200.0
2018-05-01 07:00:00	AAPL	Stock	41.5	41.7125	41.5	41.6625	165864.0
2018-05-01 07:30:00	AAPL	Stock	41.6575	41.7525	41.575	41.58	232400.0
2018-05-01 08:00:00	AAPL	Stock	41.7235	41.75	41.5625	41.6375	267884.0
2018-05-01 08:30:00	AAPL	Stock	41.64	41.675	41.55	41.565	245684.0
2018-05-01 09:00:00	AAPL	Stock	41.575	41.615	41.45	41.595	466780.0
2018-05-01 09:30:00	AAPL	Stock	41.6025	41.7925	41.3175	41.715	19227852.0
2018-05-01 10:00:00	AAPL	Stock	41.7025	42.0325	41.6875	41.9425	17417444.0
2018-05-01 10:30:00	AAPL	Stock	41.9375	41.9575	41.7425	41.7425	9973236.0
2018-05-01 11:00:00	AAPL	Stock	41.7425	41.82	41.625	41.725	7798932.0
2018-05-01 11:30:00	AAPL	Stock	41.7275	41.7775	41.675	41.773	7199264.0
2018-05-01 12:00:00	AAPL	Stock	41.7738	42.025	41.7685	42.025	10444920.0
2018-05-01 12:30:00	AAPL	Stock	42.025	42.05	41.832	41.8925	8369536.0
2018-05-01 13:00:00	AAPL	Stock	41.8925	41.9375	41.7325	41.905	6015264.0
2018-05-01 13:30:00	AAPL	Stock	41.905	42.02	41.845	42.01	6335296.0
2018-05-01 14:00:00	AAPL	Stock	42.0105	42.025	41.885	41.9325	6355932.0
2018-05-01 14:30:00	AAPL	Stock	41.93	42.0335	41.93	41.9838	8077136.0
2018-05-01 15:00:00	AAPL	Stock	41.9825	42.2425	41.9525	42.2092	12940112.0
2018-05-01 15:30:00	AAPL	Stock	42.2075	42.3	41.99	42.25	23321512.0
2018-05-01 16:00:00	AAPL	Stock	42.275	42.5	42.125	42.37	7050720.0
2018-05-01 16:30:00	AAPL	Stock	42.375	44.5	41.95	43.8625	24850580.0
2018-05-01 17:00:00	AAPL	Stock	43.87	43.9	42.275	43.755	7755388.0
2018-05-01 17:30:00	AAPL	Stock	43.7525	43.8725	43.5675	43.75	2252688.0
2018-05-01 18:00:00	AAPL	Stock	43.7275	43.975	43.65	43.675	1741620.0
2018-05-01 18:30:00	AAPL	Stock	43.7125	43.75	43.65	43.7125	357404.0
2018-05-01 19:00:00	AAPL	Stock	43.6925	43.7475	43.6925	43.72	214260.0
2018-05-01 19:30:00	AAPL	Stock	43.7375	43.85	43.72	43.8225	423200.0
2018-05-01 07:00:00	MSFT	Stock	93.55	93.55	93.52	93.52	1142.0
2018-05-01 07:30:00	MSFT	Stock	93.6	93.6	93.25	93.25	6200.0
2018-05-01 08:00:00	MSFT	Stock	93.55	93.62	93.28	93.41	8659.0
2018-05-01 08:30:00	MSFT	Stock	93.48	93.6	93.48	93.54	6208.0
2018-05-01 09:00:00	MSFT	Stock	93.54	93.6	93.16	93.21	28867.0
2018-05-01 09:30:00	MSFT	Stock	93.25	93.69	92.79	93.64	2702726.0
2018-05-01 10:00:00	MSFT	Stock	93.64	94.18	93.33	93.885	2490145.0
2018-05-01 10:30:00	MSFT	Stock	93.89	94.22	93.71	93.94	3317520.0
2018-05-01 11:00:00	MSFT	Stock	93.93	93.985	93.545	93.965	1418437.0
2018-05-01 11:30:00	MSFT	Stock	93.97	94.035	93.45	93.52	1905532.0
2018-05-01 12:00:00	MSFT	Stock	93.515	94.035	93.515	93.994	1722175.0
2018-05-01 12:30:00	MSFT	Stock	94.0	94.07	93.8	94.01	1534018.0
2018-05-01 13:00:00	MSFT	Stock	94.01	94.01	93.72	93.94	1318991.0
2018-05-01 13:30:00	MSFT	Stock	93.94	94.539	93.89	94.539	1178183.0
2018-05-01 14:00:00	MSFT	Stock	94.53	94.87	94.485	94.84	1578373.0
2018-05-01 14:30:00	MSFT	Stock	94.85	94.95	94.62	94.87	1276286.0
2018-05-01 15:00:00	MSFT	Stock	94.87	94.95	94.65	94.73	1348657.0
2018-05-01 15:30:00	MSFT	Stock	94.74	95.29	94.735	94.98	4367918.0
2018-05-01 16:00:00	MSFT	Stock	94.98	95.28	94.3	95.05	2686830.0
2018-05-01 16:30:00	MSFT	Stock	95.1	95.5	95.0	95.3	266526.0

> showing 50 of 81,339 rows — these rows as CSV

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