PREVIEW / stock_30min / 2020-09-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-10.parquet
  size:    1.9 MB
  rows:    95,616
  symbols: 2,464

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-09-10 04:00:00	AAPL	Stock	116.82	116.9	115.69	116.6	55056.0
2020-09-10 04:30:00	AAPL	Stock	116.6	117.31	116.6	116.73	19602.0
2020-09-10 05:00:00	AAPL	Stock	116.82	118.0	116.64	117.51	21357.0
2020-09-10 05:30:00	AAPL	Stock	117.68	118.2	117.26	118.2	18976.0
2020-09-10 06:00:00	AAPL	Stock	118.2	118.6	117.26	117.45	50007.0
2020-09-10 06:30:00	AAPL	Stock	117.5	117.89	116.6	117.1	37117.0
2020-09-10 07:00:00	AAPL	Stock	117.31	118.2	117.1	117.95	191966.0
2020-09-10 07:30:00	AAPL	Stock	117.96	119.15	117.8	118.95	249618.0
2020-09-10 08:00:00	AAPL	Stock	117.79	119.45	117.22	119.181	822746.0
2020-09-10 08:30:00	AAPL	Stock	119.248	120.48	118.9	120.25	988723.0
2020-09-10 09:00:00	AAPL	Stock	120.28	120.64	120.06	120.47	1003246.0
2020-09-10 09:30:00	AAPL	Stock	120.44	120.5	118.12	118.963	20483412.0
2020-09-10 10:00:00	AAPL	Stock	118.97	119.64	118.18	118.22	11138183.0
2020-09-10 10:30:00	AAPL	Stock	118.2	118.69	116.03	116.145	13879292.0
2020-09-10 11:00:00	AAPL	Stock	116.145	117.54	115.56	117.53	11545755.0
2020-09-10 11:30:00	AAPL	Stock	117.52	117.7	116.62	116.89	7083153.0
2020-09-10 12:00:00	AAPL	Stock	116.89	117.37	116.15	116.545	7942644.0
2020-09-10 12:30:00	AAPL	Stock	116.55	116.8	115.81	116.445	6631916.0
2020-09-10 13:00:00	AAPL	Stock	116.43	116.9	115.95	116.132	6112007.0
2020-09-10 13:30:00	AAPL	Stock	116.14	116.39	115.2	115.27	7275683.0
2020-09-10 14:00:00	AAPL	Stock	115.27	115.86	113.04	113.1	12595771.0
2020-09-10 14:30:00	AAPL	Stock	113.09	114.36	112.962	114.202	11899440.0
2020-09-10 15:00:00	AAPL	Stock	114.2	114.26	112.5	113.35	14183342.0
2020-09-10 15:30:00	AAPL	Stock	113.37	114.24	113.14	113.48	15532978.0
2020-09-10 16:00:00	AAPL	Stock	113.42	114.0	113.36	113.58	9029240.0
2020-09-10 16:30:00	AAPL	Stock	113.58	113.82	113.49	113.69	236845.0
2020-09-10 17:00:00	AAPL	Stock	113.699	113.78	113.55	113.6	136627.0
2020-09-10 17:30:00	AAPL	Stock	113.6	114.18	113.58	114.1	171755.0
2020-09-10 18:00:00	AAPL	Stock	114.04	114.34	113.86	114.1	256719.0
2020-09-10 18:30:00	AAPL	Stock	114.06	114.26	114.04	114.13	97508.0
2020-09-10 19:00:00	AAPL	Stock	114.11	114.3	114.05	114.28	118243.0
2020-09-10 19:30:00	AAPL	Stock	114.28	114.5	114.04	114.1	242656.0
2020-09-10 04:00:00	MSFT	Stock	210.1	210.1	208.0	209.5	8437.0
2020-09-10 04:30:00	MSFT	Stock	209.99	210.1	209.54	209.54	2849.0
2020-09-10 05:00:00	MSFT	Stock	209.5	210.5	209.5	209.9	6206.0
2020-09-10 05:30:00	MSFT	Stock	210.0	210.78	210.0	210.78	3544.0
2020-09-10 06:00:00	MSFT	Stock	211.44	212.35	210.87	210.87	6115.0
2020-09-10 06:30:00	MSFT	Stock	210.61	210.86	209.87	209.9	5652.0
2020-09-10 07:00:00	MSFT	Stock	210.81	210.81	210.0	210.51	28570.0
2020-09-10 07:30:00	MSFT	Stock	210.52	211.6	210.51	211.1	18829.0
2020-09-10 08:00:00	MSFT	Stock	210.51	211.98	210.1	211.9	73400.0
2020-09-10 08:30:00	MSFT	Stock	212.08	212.99	211.417	212.74	63182.0
2020-09-10 09:00:00	MSFT	Stock	212.93	213.78	212.51	213.4	64010.0
2020-09-10 09:30:00	MSFT	Stock	213.4	214.74	210.77	212.125	4037271.0
2020-09-10 10:00:00	MSFT	Stock	212.14	213.2	211.995	212.09	1706480.0
2020-09-10 10:30:00	MSFT	Stock	212.06	212.86	209.2	209.735	1987265.0
2020-09-10 11:00:00	MSFT	Stock	209.74	211.34	209.02	211.206	1472282.0
2020-09-10 11:30:00	MSFT	Stock	211.15	211.67	209.81	210.22	1297901.0
2020-09-10 12:00:00	MSFT	Stock	210.22	210.78	209.13	209.57	1073538.0
2020-09-10 12:30:00	MSFT	Stock	209.58	209.81	207.85	209.21	1298907.0

> showing 50 of 95,616 rows — these rows as CSV

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