PREVIEW / stock_30min / 2021-03-05

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-05.parquet
  size:    2.4 MB
  rows:    120,388
  symbols: 2,880

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
2021-03-05 04:00:00	AAPL	Stock	119.6	119.75	119.31	119.32	25295.0
2021-03-05 04:30:00	AAPL	Stock	119.25	119.43	119.21	119.39	11416.0
2021-03-05 05:00:00	AAPL	Stock	119.39	119.53	119.0	119.44	10772.0
2021-03-05 05:30:00	AAPL	Stock	119.44	119.7	119.4	119.57	9480.0
2021-03-05 06:00:00	AAPL	Stock	119.53	120.13	119.53	120.1	24517.0
2021-03-05 06:30:00	AAPL	Stock	120.0	120.49	119.81	119.82	44576.0
2021-03-05 07:00:00	AAPL	Stock	119.81	120.13	119.62	120.1	213108.0
2021-03-05 07:30:00	AAPL	Stock	120.1	120.4	119.95	120.29	133645.0
2021-03-05 08:00:00	AAPL	Stock	120.27	120.51	119.6101	120.45	473243.0
2021-03-05 08:30:00	AAPL	Stock	120.49	120.5	119.3	120.23	981601.0
2021-03-05 09:00:00	AAPL	Stock	120.23	121.56	120.18	120.99	795293.0
2021-03-05 09:30:00	AAPL	Stock	120.99	121.67	118.62	119.15	16068201.0
2021-03-05 10:00:00	AAPL	Stock	119.15	120.02	118.54	118.77	11399320.0
2021-03-05 10:30:00	AAPL	Stock	118.78	119.82	118.38	118.94	10349323.0
2021-03-05 11:00:00	AAPL	Stock	118.95	119.3199	117.57	117.72	10165396.0
2021-03-05 11:30:00	AAPL	Stock	117.74	119.07	117.74	119.0	9617205.0
2021-03-05 12:00:00	AAPL	Stock	119.01	119.5799	118.5599	119.425	7284273.0
2021-03-05 12:30:00	AAPL	Stock	119.43	119.72	118.85	119.21	7031848.0
2021-03-05 13:00:00	AAPL	Stock	119.2	119.99	118.46	119.9402	7171914.0
2021-03-05 13:30:00	AAPL	Stock	119.95	120.7	119.87	120.28	7189357.0
2021-03-05 14:00:00	AAPL	Stock	120.281	120.51	119.635	120.47	6073031.0
2021-03-05 14:30:00	AAPL	Stock	120.48	121.4699	120.47	121.34	6107502.0
2021-03-05 15:00:00	AAPL	Stock	121.34	121.56	120.86	121.2299	6830207.0
2021-03-05 15:30:00	AAPL	Stock	121.23	121.935	121.0182	121.39	12479725.0
2021-03-05 16:00:00	AAPL	Stock	121.42	121.42	120.415	121.34	8685323.0
2021-03-05 16:30:00	AAPL	Stock	121.33	121.42	121.22	121.3	136273.0
2021-03-05 17:00:00	AAPL	Stock	121.26	121.39	121.25	121.36	34027.0
2021-03-05 17:30:00	AAPL	Stock	121.35	121.48	121.3	121.41	32494.0
2021-03-05 18:00:00	AAPL	Stock	121.4	121.49	121.37	121.48	39888.0
2021-03-05 18:30:00	AAPL	Stock	121.44	121.48	121.36	121.46	39183.0
2021-03-05 19:00:00	AAPL	Stock	121.48	121.49	121.36	121.38	42817.0
2021-03-05 19:30:00	AAPL	Stock	121.38	121.49	121.36	121.49	50936.0
2021-03-05 04:00:00	MSFT	Stock	226.32	226.32	225.5	225.5	378.0
2021-03-05 04:30:00	MSFT	Stock	225.4	225.5	225.27	225.27	774.0
2021-03-05 05:00:00	MSFT	Stock	225.3	225.5	225.3	225.5	1154.0
2021-03-05 05:30:00	MSFT	Stock	225.48	225.8	225.48	225.8	500.0
2021-03-05 06:30:00	MSFT	Stock	226.36	227.02	226.02	226.02	5081.0
2021-03-05 07:00:00	MSFT	Stock	226.13	227.33	226.13	227.33	6800.0
2021-03-05 07:30:00	MSFT	Stock	227.67	227.67	227.3	227.53	8837.0
2021-03-05 08:00:00	MSFT	Stock	227.68	227.78	226.0517	227.6	31258.0
2021-03-05 08:30:00	MSFT	Stock	226.99	227.91	225.01	227.25	60233.0
2021-03-05 09:00:00	MSFT	Stock	227.414	229.67	227.35	229.54	96712.0
2021-03-05 09:30:00	MSFT	Stock	229.52	229.88	227.42	228.12	3140910.0
2021-03-05 10:00:00	MSFT	Stock	228.105	229.6	226.92	226.97	2082160.0
2021-03-05 10:30:00	MSFT	Stock	226.96	228.3834	226.66	226.78	1831159.0
2021-03-05 11:00:00	MSFT	Stock	226.79	227.67	226.46	227.06	1597444.0
2021-03-05 11:30:00	MSFT	Stock	227.05	228.74	227.03	228.615	1610251.0
2021-03-05 12:00:00	MSFT	Stock	228.59	229.88	228.2012	229.78	1896191.0
2021-03-05 12:30:00	MSFT	Stock	229.78	232.42	229.28	232.28	2509224.0
2021-03-05 13:00:00	MSFT	Stock	232.28	232.91	230.74	232.75	1768214.0

> showing 50 of 120,388 rows — these rows as CSV

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