PREVIEW / stock_30min / 2020-12-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-02.parquet
  size:    2.1 MB
  rows:    104,857
  symbols: 2,614

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
2020-12-02 04:00:00	AAPL	Stock	122.5	122.5	122.05	122.25	12733.0
2020-12-02 04:30:00	AAPL	Stock	122.15	122.55	122.12	122.45	3928.0
2020-12-02 05:00:00	AAPL	Stock	122.45	122.55	122.4	122.55	1594.0
2020-12-02 05:30:00	AAPL	Stock	122.53	122.67	122.47	122.61	5155.0
2020-12-02 06:00:00	AAPL	Stock	122.61	122.65	122.4	122.4	5296.0
2020-12-02 06:30:00	AAPL	Stock	122.4	122.57	122.36	122.57	5970.0
2020-12-02 07:00:00	AAPL	Stock	122.51	122.65	122.18	122.2	122078.0
2020-12-02 07:30:00	AAPL	Stock	122.2	122.2	121.76	122.04	140967.0
2020-12-02 08:00:00	AAPL	Stock	122.55	123.02	121.76	122.15	344771.0
2020-12-02 08:30:00	AAPL	Stock	122.13	122.17	121.93	122.15	159554.0
2020-12-02 09:00:00	AAPL	Stock	122.15	122.773	121.8	122.01	389202.0
2020-12-02 09:30:00	AAPL	Stock	122.01	122.62	120.89	122.015	14861967.0
2020-12-02 10:00:00	AAPL	Stock	122.01	122.5	121.56	122.221	7097580.0
2020-12-02 10:30:00	AAPL	Stock	122.22	122.309	121.75	121.995	4645569.0
2020-12-02 11:00:00	AAPL	Stock	122.01	122.4	121.7	122.33	4093060.0
2020-12-02 11:30:00	AAPL	Stock	122.335	122.82	122.21	122.55	4022371.0
2020-12-02 12:00:00	AAPL	Stock	122.544	122.96	122.49	122.925	3766128.0
2020-12-02 12:30:00	AAPL	Stock	122.926	123.25	122.82	122.915	4279426.0
2020-12-02 13:00:00	AAPL	Stock	122.92	123.37	122.7	123.26	3637256.0
2020-12-02 13:30:00	AAPL	Stock	123.263	123.33	122.7	122.955	3877217.0
2020-12-02 14:00:00	AAPL	Stock	122.95	123.13	122.8	123.01	3308846.0
2020-12-02 14:30:00	AAPL	Stock	123.0	123.11	122.65	122.95	3404131.0
2020-12-02 15:00:00	AAPL	Stock	122.95	123.19	122.88	122.935	3911601.0
2020-12-02 15:30:00	AAPL	Stock	122.93	123.24	122.905	123.08	6349359.0
2020-12-02 16:00:00	AAPL	Stock	123.08	123.3	123.05	123.18	9575766.0
2020-12-02 16:30:00	AAPL	Stock	123.16	123.25	123.12	123.18	39072.0
2020-12-02 17:00:00	AAPL	Stock	123.16	123.21	123.1	123.15	42378.0
2020-12-02 17:30:00	AAPL	Stock	123.2	123.2	123.08	123.1	43321.0
2020-12-02 18:00:00	AAPL	Stock	123.08	123.18	122.9	122.94	54124.0
2020-12-02 18:30:00	AAPL	Stock	122.99	123.07	122.91	123.01	45729.0
2020-12-02 19:00:00	AAPL	Stock	123.02	123.09	123.0	123.05	31293.0
2020-12-02 19:30:00	AAPL	Stock	123.07	123.23	123.01	123.23	41731.0
2020-12-02 04:00:00	MSFT	Stock	216.5	216.73	216.5	216.52	5197.0
2020-12-02 04:30:00	MSFT	Stock	216.48	216.5	216.48	216.5	1428.0
2020-12-02 05:00:00	MSFT	Stock	216.5	216.5	216.5	216.5	188.0
2020-12-02 05:30:00	MSFT	Stock	216.37	216.37	216.35	216.35	891.0
2020-12-02 06:30:00	MSFT	Stock	216.06	216.22	215.94	216.18	3343.0
2020-12-02 07:00:00	MSFT	Stock	216.18	216.19	215.58	215.58	9976.0
2020-12-02 07:30:00	MSFT	Stock	215.57	215.57	215.0	215.3	8345.0
2020-12-02 08:00:00	MSFT	Stock	215.8	215.96	215.1	215.4	26905.0
2020-12-02 08:30:00	MSFT	Stock	215.35	215.6	215.1	215.6	9096.0
2020-12-02 09:00:00	MSFT	Stock	215.65	215.69	214.8	215.0	24269.0
2020-12-02 09:30:00	MSFT	Stock	214.89	215.085	212.8	213.835	3129076.0
2020-12-02 10:00:00	MSFT	Stock	213.82	214.59	213.115	214.45	1799649.0
2020-12-02 10:30:00	MSFT	Stock	214.44	214.666	213.81	214.11	1182139.0
2020-12-02 11:00:00	MSFT	Stock	214.12	214.32	213.75	213.925	975701.0
2020-12-02 11:30:00	MSFT	Stock	213.94	214.84	213.79	214.73	962488.0
2020-12-02 12:00:00	MSFT	Stock	214.725	214.75	214.09	214.282	666144.0
2020-12-02 12:30:00	MSFT	Stock	214.29	214.35	213.86	213.958	733828.0
2020-12-02 13:00:00	MSFT	Stock	213.96	214.5	213.77	214.32	615020.0

> showing 50 of 104,857 rows — these rows as CSV

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