PREVIEW / stock_30min / 2020-11-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-09.parquet
  size:    2.2 MB
  rows:    110,562
  symbols: 2,558

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-11-09 04:00:00	AAPL	Stock	121.2	121.6	120.7	120.82	97646.0
2020-11-09 04:30:00	AAPL	Stock	120.96	121.17	120.7	120.9	22525.0
2020-11-09 05:00:00	AAPL	Stock	120.97	121.44	120.97	121.12	35894.0
2020-11-09 05:30:00	AAPL	Stock	121.25	121.68	121.14	121.38	15783.0
2020-11-09 06:00:00	AAPL	Stock	121.38	121.38	121.02	121.1	24246.0
2020-11-09 06:30:00	AAPL	Stock	121.1	121.96	120.51	121.06	111040.0
2020-11-09 07:00:00	AAPL	Stock	120.98	121.29	119.25	120.33	732867.0
2020-11-09 07:30:00	AAPL	Stock	120.3	120.4	117.93	119.79	817828.0
2020-11-09 08:00:00	AAPL	Stock	119.75	121.29	117.9	119.83	1323797.0
2020-11-09 08:30:00	AAPL	Stock	119.83	121.4	119.7	120.09	935934.0
2020-11-09 09:00:00	AAPL	Stock	120.17	120.67	119.91	120.34	696302.0
2020-11-09 09:30:00	AAPL	Stock	120.5	121.69	118.48	119.743	20800507.0
2020-11-09 10:00:00	AAPL	Stock	119.73	121.79	119.67	121.61	12658747.0
2020-11-09 10:30:00	AAPL	Stock	121.61	121.99	120.067	120.63	9513263.0
2020-11-09 11:00:00	AAPL	Stock	120.64	121.57	119.72	121.57	9077293.0
2020-11-09 11:30:00	AAPL	Stock	121.56	121.68	120.55	120.56	5750012.0
2020-11-09 12:00:00	AAPL	Stock	120.57	120.87	120.0	120.646	6602018.0
2020-11-09 12:30:00	AAPL	Stock	120.66	120.95	120.45	120.81	5131393.0
2020-11-09 13:00:00	AAPL	Stock	120.81	121.0	120.03	120.059	5273512.0
2020-11-09 13:30:00	AAPL	Stock	120.055	120.15	119.38	119.64	5781907.0
2020-11-09 14:00:00	AAPL	Stock	119.63	119.82	118.64	118.93	6107640.0
2020-11-09 14:30:00	AAPL	Stock	118.92	119.13	118.2	118.523	7079351.0
2020-11-09 15:00:00	AAPL	Stock	118.54	118.94	117.92	118.03	7108319.0
2020-11-09 15:30:00	AAPL	Stock	118.04	118.45	116.05	116.32	15675064.0
2020-11-09 16:00:00	AAPL	Stock	116.32	117.0	116.03	116.75	10999184.0
2020-11-09 16:30:00	AAPL	Stock	116.75	116.83	116.35	116.79	209636.0
2020-11-09 17:00:00	AAPL	Stock	116.8	116.84	116.56	116.82	67846.0
2020-11-09 17:30:00	AAPL	Stock	116.85	117.24	116.78	117.11	137873.0
2020-11-09 18:00:00	AAPL	Stock	117.13	117.7	117.05	117.58	196003.0
2020-11-09 18:30:00	AAPL	Stock	117.57	117.59	117.1	117.18	88735.0
2020-11-09 19:00:00	AAPL	Stock	117.2	117.24	116.43	116.58	128063.0
2020-11-09 19:30:00	AAPL	Stock	116.57	116.88	116.5	116.88	93091.0
2020-11-09 04:00:00	MSFT	Stock	227.5	228.47	226.88	226.96	8238.0
2020-11-09 04:30:00	MSFT	Stock	227.4	227.64	227.35	227.4	2504.0
2020-11-09 05:00:00	MSFT	Stock	227.5	227.86	227.5	227.83	4041.0
2020-11-09 05:30:00	MSFT	Stock	227.85	228.19	227.54	228.19	6702.0
2020-11-09 06:00:00	MSFT	Stock	228.07	228.07	227.54	227.9	2773.0
2020-11-09 06:30:00	MSFT	Stock	227.82	229.0	225.72	226.0	32691.0
2020-11-09 07:00:00	MSFT	Stock	225.55	226.0	223.23	223.99	138828.0
2020-11-09 07:30:00	MSFT	Stock	223.92	223.97	217.87	220.77	267678.0
2020-11-09 08:00:00	MSFT	Stock	225.5	225.75	218.0	222.646	175922.0
2020-11-09 08:30:00	MSFT	Stock	222.69	226.01	222.69	222.75	180292.0
2020-11-09 09:00:00	MSFT	Stock	223.0	225.0	221.7	224.2	147958.0
2020-11-09 09:30:00	MSFT	Stock	224.22	226.55	223.32	224.81	4074809.0
2020-11-09 10:00:00	MSFT	Stock	224.78	228.12	224.66	226.31	2872616.0
2020-11-09 10:30:00	MSFT	Stock	226.32	226.93	223.8	224.7	2071380.0
2020-11-09 11:00:00	MSFT	Stock	224.69	225.92	223.46	225.815	1893411.0
2020-11-09 11:30:00	MSFT	Stock	225.84	226.09	224.5	224.91	1081089.0
2020-11-09 12:00:00	MSFT	Stock	224.91	225.58	223.81	224.83	1178229.0
2020-11-09 12:30:00	MSFT	Stock	224.83	225.5	223.83	224.78	1077920.0

> showing 50 of 110,562 rows — these rows as CSV

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