PREVIEW / stock_30min / 2020-10-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-15.parquet
  size:    1.9 MB
  rows:    97,767
  symbols: 2,487

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-10-15 04:00:00	AAPL	Stock	119.58	119.8	117.82	118.09	118338.0
2020-10-15 04:30:00	AAPL	Stock	118.09	118.1	117.25	117.83	116135.0
2020-10-15 05:00:00	AAPL	Stock	117.75	118.19	117.34	118.0	111361.0
2020-10-15 05:30:00	AAPL	Stock	118.0	118.0	117.4	118.0	69460.0
2020-10-15 06:00:00	AAPL	Stock	118.0	118.43	117.91	118.25	41434.0
2020-10-15 06:30:00	AAPL	Stock	118.3	118.88	118.13	118.4	63028.0
2020-10-15 07:00:00	AAPL	Stock	118.5	119.0	118.3	118.83	373278.0
2020-10-15 07:30:00	AAPL	Stock	118.86	119.11	118.5	118.89	279890.0
2020-10-15 08:00:00	AAPL	Stock	118.85	121.49	118.35	118.9	723695.0
2020-10-15 08:30:00	AAPL	Stock	118.88	118.88	118.32	118.772	574148.0
2020-10-15 09:00:00	AAPL	Stock	118.83	118.95	118.6	118.78	474898.0
2020-10-15 09:30:00	AAPL	Stock	118.75	120.635	118.15	120.2	16168969.0
2020-10-15 10:00:00	AAPL	Stock	120.18	120.38	119.21	119.57	10314967.0
2020-10-15 10:30:00	AAPL	Stock	119.536	119.85	119.01	119.743	8001075.0
2020-10-15 11:00:00	AAPL	Stock	119.74	120.11	119.17	119.85	6657549.0
2020-10-15 11:30:00	AAPL	Stock	119.84	120.39	119.75	120.29	5824209.0
2020-10-15 12:00:00	AAPL	Stock	120.281	120.65	119.78	119.86	6471887.0
2020-10-15 12:30:00	AAPL	Stock	119.861	120.07	119.55	119.81	4390268.0
2020-10-15 13:00:00	AAPL	Stock	119.81	119.93	119.39	119.557	3902033.0
2020-10-15 13:30:00	AAPL	Stock	119.564	120.44	119.47	120.345	4764851.0
2020-10-15 14:00:00	AAPL	Stock	120.34	120.64	120.232	120.608	4396731.0
2020-10-15 14:30:00	AAPL	Stock	120.6	120.81	120.2	120.665	5066210.0
2020-10-15 15:00:00	AAPL	Stock	120.66	121.2	120.57	120.955	7443479.0
2020-10-15 15:30:00	AAPL	Stock	120.96	121.1	120.58	120.745	9339212.0
2020-10-15 16:00:00	AAPL	Stock	120.71	120.722	120.5	120.58	6919581.0
2020-10-15 16:30:00	AAPL	Stock	120.61	120.75	120.56	120.65	86794.0
2020-10-15 17:00:00	AAPL	Stock	120.63	120.9	120.6	120.8	406242.0
2020-10-15 17:30:00	AAPL	Stock	120.82	120.9	120.64	120.85	65100.0
2020-10-15 18:00:00	AAPL	Stock	120.85	121.1	120.82	120.93	124959.0
2020-10-15 18:30:00	AAPL	Stock	121.0	121.0	120.81	120.93	44143.0
2020-10-15 19:00:00	AAPL	Stock	120.98	121.15	120.92	121.03	75629.0
2020-10-15 19:30:00	AAPL	Stock	121.01	121.1	120.95	121.0	133078.0
2020-10-15 04:00:00	MSFT	Stock	218.53	218.53	217.0	217.0	2858.0
2020-10-15 04:30:00	MSFT	Stock	217.2	217.2	215.78	216.98	20211.0
2020-10-15 05:00:00	MSFT	Stock	216.0	217.38	216.0	217.1	25044.0
2020-10-15 05:30:00	MSFT	Stock	217.1	217.14	216.22	217.13	10639.0
2020-10-15 06:00:00	MSFT	Stock	217.35	217.6	216.7	217.54	10408.0
2020-10-15 06:30:00	MSFT	Stock	217.21	218.37	217.21	217.51	15480.0
2020-10-15 07:00:00	MSFT	Stock	217.6	218.4	217.47	217.91	32798.0
2020-10-15 07:30:00	MSFT	Stock	217.98	218.09	217.67	218.0	20992.0
2020-10-15 08:00:00	MSFT	Stock	217.9	218.47	217.51	218.15	44982.0
2020-10-15 08:30:00	MSFT	Stock	217.967	218.0	217.16	217.474	85648.0
2020-10-15 09:00:00	MSFT	Stock	217.3	217.5	216.8	217.0	47609.0
2020-10-15 09:30:00	MSFT	Stock	216.93	219.22	216.01	219.22	2658040.0
2020-10-15 10:00:00	MSFT	Stock	219.21	219.29	217.01	217.18	1640269.0
2020-10-15 10:30:00	MSFT	Stock	217.19	217.66	216.445	217.47	1577795.0
2020-10-15 11:00:00	MSFT	Stock	217.48	218.62	216.67	218.18	1079182.0
2020-10-15 11:30:00	MSFT	Stock	218.19	218.82	217.75	218.03	864366.0
2020-10-15 12:00:00	MSFT	Stock	218.0	218.57	217.46	217.61	726182.0
2020-10-15 12:30:00	MSFT	Stock	217.59	217.86	217.15	217.77	716036.0

> showing 50 of 97,767 rows — these rows as CSV

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