PREVIEW / stock_30min / 2019-10-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-14.parquet
  size:    1.6 MB
  rows:    80,789
  symbols: 2,497

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-10-14 04:00:00	AAPL	Stock	59.1625	59.1625	59.005	59.005	4204.0
2019-10-14 04:30:00	AAPL	Stock	59.1	59.1	59.08	59.1	4944.0
2019-10-14 05:00:00	AAPL	Stock	59.0325	59.0325	58.8425	58.875	9364.0
2019-10-14 05:30:00	AAPL	Stock	58.81	58.81	58.45	58.5925	93180.0
2019-10-14 06:00:00	AAPL	Stock	58.6025	58.65	58.54	58.625	12416.0
2019-10-14 06:30:00	AAPL	Stock	58.625	58.75	58.625	58.75	19668.0
2019-10-14 07:00:00	AAPL	Stock	58.68	58.925	58.68	58.89	160360.0
2019-10-14 07:30:00	AAPL	Stock	58.8875	59.055	58.8875	59.055	98348.0
2019-10-14 08:00:00	AAPL	Stock	58.9545	59.075	58.725	59.0	284624.0
2019-10-14 08:30:00	AAPL	Stock	59.0	59.025	58.9175	58.9625	118940.0
2019-10-14 09:00:00	AAPL	Stock	58.9625	58.9875	58.6775	58.7675	574060.0
2019-10-14 09:30:00	AAPL	Stock	58.775	59.3175	58.6675	59.29	14313936.0
2019-10-14 10:00:00	AAPL	Stock	59.29	59.5335	59.27	59.3588	10536648.0
2019-10-14 10:30:00	AAPL	Stock	59.3575	59.53	59.3375	59.4738	6129924.0
2019-10-14 11:00:00	AAPL	Stock	59.4745	59.4875	59.3275	59.36	6030556.0
2019-10-14 11:30:00	AAPL	Stock	59.3625	59.415	59.2325	59.25	4714360.0
2019-10-14 12:00:00	AAPL	Stock	59.247	59.2622	59.055	59.1725	5120588.0
2019-10-14 12:30:00	AAPL	Stock	59.17	59.255	59.019	59.0875	3789224.0
2019-10-14 13:00:00	AAPL	Stock	59.0825	59.1575	59.0588	59.135	3489768.0
2019-10-14 13:30:00	AAPL	Stock	59.1325	59.1875	59.1038	59.1738	2682164.0
2019-10-14 14:00:00	AAPL	Stock	59.1725	59.2175	59.1175	59.1528	2020376.0
2019-10-14 14:30:00	AAPL	Stock	59.1525	59.2075	59.015	59.06	3139808.0
2019-10-14 15:00:00	AAPL	Stock	59.055	59.1075	59.035	59.055	2656456.0
2019-10-14 15:30:00	AAPL	Stock	59.0575	59.085	58.915	58.9725	9087468.0
2019-10-14 16:00:00	AAPL	Stock	58.9675	59.1372	58.955	58.975	6170344.0
2019-10-14 16:30:00	AAPL	Stock	58.965	58.975	58.85	58.975	14384.0
2019-10-14 17:00:00	AAPL	Stock	58.9775	58.9875	58.9625	58.975	12364.0
2019-10-14 17:30:00	AAPL	Stock	58.9925	59.0	58.975	58.975	8248.0
2019-10-14 18:00:00	AAPL	Stock	58.975	59.0225	58.975	59.0125	62640.0
2019-10-14 18:30:00	AAPL	Stock	59.02	59.0325	59.0025	59.0325	8920.0
2019-10-14 19:00:00	AAPL	Stock	59.03	59.06	59.03	59.0525	45856.0
2019-10-14 19:30:00	AAPL	Stock	59.05	59.1225	59.05	59.1125	77112.0
2019-10-14 04:00:00	MSFT	Stock	140.0	140.0	139.76	139.76	210.0
2019-10-14 04:30:00	MSFT	Stock	139.75	139.75	139.75	139.75	409.0
2019-10-14 05:00:00	MSFT	Stock	139.67	139.67	139.67	139.67	100.0
2019-10-14 05:30:00	MSFT	Stock	139.33	139.35	139.05	139.1	3198.0
2019-10-14 06:00:00	MSFT	Stock	139.17	139.17	139.17	139.17	100.0
2019-10-14 06:30:00	MSFT	Stock	139.18	139.18	139.18	139.18	100.0
2019-10-14 07:00:00	MSFT	Stock	139.49	139.64	139.38	139.55	5551.0
2019-10-14 07:30:00	MSFT	Stock	139.55	139.72	139.55	139.72	4990.0
2019-10-14 08:00:00	MSFT	Stock	139.44	139.83	139.36	139.65	16743.0
2019-10-14 08:30:00	MSFT	Stock	139.68	139.77	139.51	139.68	5157.0
2019-10-14 09:00:00	MSFT	Stock	139.65	139.77	139.5	139.67	8421.0
2019-10-14 09:30:00	MSFT	Stock	139.66	140.29	139.61	139.91	1702490.0
2019-10-14 10:00:00	MSFT	Stock	139.9	140.21	139.59	139.78	997057.0
2019-10-14 10:30:00	MSFT	Stock	139.8	140.21	139.77	140.16	638005.0
2019-10-14 11:00:00	MSFT	Stock	140.17	140.17	139.82	139.929	679110.0
2019-10-14 11:30:00	MSFT	Stock	139.93	140.03	139.835	139.93	514560.0
2019-10-14 12:00:00	MSFT	Stock	139.928	140.01	139.61	139.64	439573.0
2019-10-14 12:30:00	MSFT	Stock	139.63	139.87	139.582	139.67	443084.0

> showing 50 of 80,789 rows — these rows as CSV

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