PREVIEW / stock_30min / 2019-05-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-03.parquet
  size:    1.7 MB
  rows:    83,201
  symbols: 2,609

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-05-03 04:00:00	AAPL	Stock	52.495	52.595	52.495	52.5875	5308.0
2019-05-03 04:30:00	AAPL	Stock	52.5525	52.5525	52.5475	52.5475	800.0
2019-05-03 05:00:00	AAPL	Stock	52.5375	52.575	52.5	52.5	22688.0
2019-05-03 05:30:00	AAPL	Stock	52.4875	52.4975	52.4875	52.4875	3448.0
2019-05-03 06:00:00	AAPL	Stock	52.485	52.51	52.4475	52.51	13424.0
2019-05-03 06:30:00	AAPL	Stock	52.525	52.6	52.525	52.56	30508.0
2019-05-03 07:00:00	AAPL	Stock	52.525	52.6125	52.5125	52.53	66568.0
2019-05-03 07:30:00	AAPL	Stock	52.55	52.615	52.55	52.6125	81424.0
2019-05-03 08:00:00	AAPL	Stock	52.61	52.635	52.5125	52.5875	232188.0
2019-05-03 08:30:00	AAPL	Stock	52.5875	52.7475	52.4675	52.695	562432.0
2019-05-03 09:00:00	AAPL	Stock	52.695	52.7275	52.5725	52.71	298200.0
2019-05-03 09:30:00	AAPL	Stock	52.69	52.865	52.58	52.78	13234604.0
2019-05-03 10:00:00	AAPL	Stock	52.775	52.8325	52.5575	52.6805	6929552.0
2019-05-03 10:30:00	AAPL	Stock	52.6875	52.765	52.64	52.7112	5108284.0
2019-05-03 11:00:00	AAPL	Stock	52.7125	52.7725	52.655	52.735	4826740.0
2019-05-03 11:30:00	AAPL	Stock	52.735	52.815	52.6875	52.748	3947232.0
2019-05-03 12:00:00	AAPL	Stock	52.7492	52.8375	52.7325	52.7975	3252064.0
2019-05-03 12:30:00	AAPL	Stock	52.7975	52.855	52.7075	52.7425	2963628.0
2019-05-03 13:00:00	AAPL	Stock	52.745	52.88	52.7325	52.8622	2827660.0
2019-05-03 13:30:00	AAPL	Stock	52.8625	52.925	52.8025	52.8075	2686280.0
2019-05-03 14:00:00	AAPL	Stock	52.8075	52.8625	52.7725	52.8285	2244212.0
2019-05-03 14:30:00	AAPL	Stock	52.8275	52.8605	52.77	52.855	2115892.0
2019-05-03 15:00:00	AAPL	Stock	52.855	52.855	52.745	52.7962	2687708.0
2019-05-03 15:30:00	AAPL	Stock	52.795	52.96	52.77	52.945	7695252.0
2019-05-03 16:00:00	AAPL	Stock	52.9375	52.9825	52.925	52.9525	9481680.0
2019-05-03 16:30:00	AAPL	Stock	52.9625	52.99	52.8975	52.985	120568.0
2019-05-03 17:00:00	AAPL	Stock	52.96	52.99	52.9375	52.9525	54328.0
2019-05-03 17:30:00	AAPL	Stock	52.9525	52.98	52.9525	52.98	22564.0
2019-05-03 18:00:00	AAPL	Stock	52.9875	52.9875	52.9525	52.9725	72596.0
2019-05-03 18:30:00	AAPL	Stock	52.97	52.9725	52.9525	52.9725	15600.0
2019-05-03 19:00:00	AAPL	Stock	52.97	52.99	52.9575	52.99	28672.0
2019-05-03 19:30:00	AAPL	Stock	52.9875	53.0	52.97	52.9875	38764.0
2019-05-03 04:00:00	MSFT	Stock	127.0	127.0	126.92	126.92	1783.0
2019-05-03 04:30:00	MSFT	Stock	126.89	126.89	126.89	126.89	100.0
2019-05-03 05:00:00	MSFT	Stock	127.08	127.08	126.94	126.94	200.0
2019-05-03 05:30:00	MSFT	Stock	126.94	127.2	126.92	126.97	4300.0
2019-05-03 06:00:00	MSFT	Stock	126.86	126.99	126.86	126.99	450.0
2019-05-03 06:30:00	MSFT	Stock	126.99	126.99	126.75	126.75	1850.0
2019-05-03 07:00:00	MSFT	Stock	126.75	126.97	126.71	126.9	6287.0
2019-05-03 07:30:00	MSFT	Stock	126.9	127.0	126.81	126.9	7401.0
2019-05-03 08:00:00	MSFT	Stock	126.8	127.11	126.8	127.0	26849.0
2019-05-03 08:30:00	MSFT	Stock	127.1	127.27	126.53	127.27	30058.0
2019-05-03 09:00:00	MSFT	Stock	127.27	127.35	127.05	127.29	50054.0
2019-05-03 09:30:00	MSFT	Stock	127.32	127.865	127.25	127.865	2372941.0
2019-05-03 10:00:00	MSFT	Stock	127.86	128.18	127.78	128.02	1546351.0
2019-05-03 10:30:00	MSFT	Stock	128.03	128.594	127.89	128.49	1710931.0
2019-05-03 11:00:00	MSFT	Stock	128.495	128.773	128.46	128.575	1673425.0
2019-05-03 11:30:00	MSFT	Stock	128.57	128.615	128.16	128.35	1077693.0
2019-05-03 12:00:00	MSFT	Stock	128.34	128.64	128.276	128.64	1203310.0
2019-05-03 12:30:00	MSFT	Stock	128.64	128.75	128.38	128.619	1074102.0

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

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