PREVIEW / stock_30min / 2020-10-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-14.parquet
  size:    1.9 MB
  rows:    96,090
  symbols: 2,495

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-14 04:00:00	AAPL	Stock	121.55	122.57	121.31	122.16	74911.0
2020-10-14 04:30:00	AAPL	Stock	122.3	122.39	122.02	122.19	38800.0
2020-10-14 05:00:00	AAPL	Stock	122.25	122.31	121.58	121.75	31434.0
2020-10-14 05:30:00	AAPL	Stock	121.74	121.76	121.28	121.35	27184.0
2020-10-14 06:00:00	AAPL	Stock	121.42	121.57	120.6	121.0	63474.0
2020-10-14 06:30:00	AAPL	Stock	121.1	121.1	120.7	120.9	30711.0
2020-10-14 07:00:00	AAPL	Stock	121.06	121.55	120.73	121.54	239598.0
2020-10-14 07:30:00	AAPL	Stock	121.54	121.6	121.32	121.42	173781.0
2020-10-14 08:00:00	AAPL	Stock	120.85	121.6	120.73	121.3	569050.0
2020-10-14 08:30:00	AAPL	Stock	121.29	121.38	121.1	121.28	351458.0
2020-10-14 09:00:00	AAPL	Stock	121.29	121.32	120.83	120.97	572852.0
2020-10-14 09:30:00	AAPL	Stock	120.99	123.03	120.04	122.68	23265001.0
2020-10-14 10:00:00	AAPL	Stock	122.691	122.82	121.4	121.69	12496030.0
2020-10-14 10:30:00	AAPL	Stock	121.69	122.39	121.18	122.116	10301752.0
2020-10-14 11:00:00	AAPL	Stock	122.13	122.27	121.49	121.6	6086846.0
2020-10-14 11:30:00	AAPL	Stock	121.61	121.73	120.72	120.815	9459477.0
2020-10-14 12:00:00	AAPL	Stock	120.83	121.33	119.71	120.248	11000593.0
2020-10-14 12:30:00	AAPL	Stock	120.25	120.655	120.0	120.28	8229388.0
2020-10-14 13:00:00	AAPL	Stock	120.28	120.77	120.08	120.14	5828876.0
2020-10-14 13:30:00	AAPL	Stock	120.146	120.7	119.62	120.55	7634159.0
2020-10-14 14:00:00	AAPL	Stock	120.54	121.2	120.501	120.84	7947809.0
2020-10-14 14:30:00	AAPL	Stock	120.835	121.37	120.52	121.19	6550936.0
2020-10-14 15:00:00	AAPL	Stock	121.18	121.73	121.03	121.48	8268532.0
2020-10-14 15:30:00	AAPL	Stock	121.48	122.0	121.14	121.29	11805279.0
2020-10-14 16:00:00	AAPL	Stock	121.24	121.25	120.7	120.76	8185014.0
2020-10-14 16:30:00	AAPL	Stock	120.78	121.19	120.75	120.76	139307.0
2020-10-14 17:00:00	AAPL	Stock	120.78	120.85	120.65	120.66	70388.0
2020-10-14 17:30:00	AAPL	Stock	120.74	120.92	120.69	120.88	47940.0
2020-10-14 18:00:00	AAPL	Stock	120.89	121.18	120.84	121.07	96364.0
2020-10-14 18:30:00	AAPL	Stock	121.09	121.09	120.71	120.9	105086.0
2020-10-14 19:00:00	AAPL	Stock	120.9	121.2	120.9	120.97	77766.0
2020-10-14 19:30:00	AAPL	Stock	120.97	121.0	120.76	120.81	72040.0
2020-10-14 04:00:00	MSFT	Stock	224.03	224.64	224.03	224.5	1207.0
2020-10-14 04:30:00	MSFT	Stock	224.75	224.75	223.75	224.02	2535.0
2020-10-14 05:00:00	MSFT	Stock	223.53	223.53	223.05	223.05	1180.0
2020-10-14 05:30:00	MSFT	Stock	223.39	223.39	223.1	223.29	636.0
2020-10-14 06:00:00	MSFT	Stock	223.46	223.46	221.51	222.86	5511.0
2020-10-14 06:30:00	MSFT	Stock	222.88	223.1	222.6	223.0	738.0
2020-10-14 07:00:00	MSFT	Stock	223.0	224.1	223.0	224.1	6737.0
2020-10-14 07:30:00	MSFT	Stock	224.02	224.25	223.51	224.03	14712.0
2020-10-14 08:00:00	MSFT	Stock	223.42	224.67	223.42	224.27	22582.0
2020-10-14 08:30:00	MSFT	Stock	224.15	224.257	223.22	224.02	17881.0
2020-10-14 09:00:00	MSFT	Stock	224.18	224.217	223.0	223.0	21339.0
2020-10-14 09:30:00	MSFT	Stock	223.0	224.22	221.94	223.47	2388084.0
2020-10-14 10:00:00	MSFT	Stock	223.485	223.67	221.95	222.225	1358673.0
2020-10-14 10:30:00	MSFT	Stock	222.22	222.98	221.96	222.685	1085400.0
2020-10-14 11:00:00	MSFT	Stock	222.69	223.24	222.1	222.197	849213.0
2020-10-14 11:30:00	MSFT	Stock	222.19	222.32	220.53	220.708	1371029.0
2020-10-14 12:00:00	MSFT	Stock	220.73	221.11	219.42	219.98	1322020.0
2020-10-14 12:30:00	MSFT	Stock	219.95	220.4	219.5	219.832	1203919.0

> showing 50 of 96,090 rows — these rows as CSV

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