PREVIEW / stock_30min / 2019-12-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-24.parquet
  size:    1.1 MB
  rows:    49,417
  symbols: 2,413

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
2019-12-24 04:00:00	AAPL	Stock	71.14	71.1625	71.14	71.1625	800.0
2019-12-24 04:30:00	AAPL	Stock	71.225	71.3	71.2175	71.3	14144.0
2019-12-24 05:00:00	AAPL	Stock	71.3	71.3	71.3	71.3	400.0
2019-12-24 05:30:00	AAPL	Stock	71.32	71.32	71.25	71.25	1600.0
2019-12-24 06:00:00	AAPL	Stock	71.32	71.32	71.32	71.32	600.0
2019-12-24 06:30:00	AAPL	Stock	71.3	71.3	71.2625	71.2625	10960.0
2019-12-24 07:00:00	AAPL	Stock	71.2825	71.2925	71.15	71.17	98484.0
2019-12-24 07:30:00	AAPL	Stock	71.18	71.1825	71.1375	71.175	44460.0
2019-12-24 08:00:00	AAPL	Stock	71.2	71.25	70.8225	71.21	222828.0
2019-12-24 08:30:00	AAPL	Stock	71.2075	71.2075	71.1425	71.18	96012.0
2019-12-24 09:00:00	AAPL	Stock	71.18	71.18	71.0	71.1475	1773372.0
2019-12-24 09:30:00	AAPL	Stock	71.13	71.2225	70.73	71.0312	12464396.0
2019-12-24 10:00:00	AAPL	Stock	71.0275	71.119	70.95	71.0775	4738340.0
2019-12-24 10:30:00	AAPL	Stock	71.075	71.1375	71.0225	71.048	3257844.0
2019-12-24 11:00:00	AAPL	Stock	71.046	71.0825	70.995	71.0145	2328416.0
2019-12-24 11:30:00	AAPL	Stock	71.022	71.0475	70.9275	70.9722	2381188.0
2019-12-24 12:00:00	AAPL	Stock	70.97	71.0725	70.9225	71.0327	2730688.0
2019-12-24 12:30:00	AAPL	Stock	71.0338	71.139	70.9888	71.069	3917444.0
2019-12-24 13:00:00	AAPL	Stock	71.0675	71.1175	71.0525	71.0868	2044936.0
2019-12-24 13:30:00	AAPL	Stock	71.0875	71.0875	71.0675	71.085	20520.0
2019-12-24 14:00:00	AAPL	Stock	71.07	71.125	71.0675	71.119	165672.0
2019-12-24 14:30:00	AAPL	Stock	71.125	71.125	71.11	71.1125	7992.0
2019-12-24 15:00:00	AAPL	Stock	71.1125	71.1125	71.1075	71.1075	15404.0
2019-12-24 15:30:00	AAPL	Stock	71.1075	71.1075	71.1075	71.1075	2856.0
2019-12-24 16:00:00	AAPL	Stock	71.09	71.105	71.0875	71.0875	3212.0
2019-12-24 16:30:00	AAPL	Stock	71.1	71.105	71.1	71.105	1872.0
2019-12-24 08:00:00	MSFT	Stock	157.695	157.695	157.6	157.6	4305.0
2019-12-24 09:00:00	MSFT	Stock	157.56	157.57	157.42	157.45	18596.0
2019-12-24 09:30:00	MSFT	Stock	157.48	157.595	157.115	157.31	1095701.0
2019-12-24 10:00:00	MSFT	Stock	157.29	157.45	157.22	157.43	512009.0
2019-12-24 10:30:00	MSFT	Stock	157.43	157.59	157.37	157.59	469179.0
2019-12-24 11:00:00	MSFT	Stock	157.592	157.71	157.49	157.523	527627.0
2019-12-24 11:30:00	MSFT	Stock	157.54	157.62	157.49	157.5	368514.0
2019-12-24 12:00:00	MSFT	Stock	157.505	157.53	157.35	157.375	505540.0
2019-12-24 12:30:00	MSFT	Stock	157.38	157.47	157.22	157.39	751204.0
2019-12-24 13:00:00	MSFT	Stock	157.38	157.55	157.35	157.439	919308.0
2019-12-24 13:30:00	MSFT	Stock	157.5	157.5	157.5	157.5	100.0
2019-12-24 14:00:00	MSFT	Stock	157.38	157.47	157.3	157.38	63921.0
2019-12-24 14:30:00	MSFT	Stock	157.37	157.37	157.31	157.36	1500.0
2019-12-24 15:00:00	MSFT	Stock	157.32	157.32	157.3	157.3	1475.0
2019-12-24 15:30:00	MSFT	Stock	157.3	157.3	157.26	157.26	1372.0
2019-12-24 16:00:00	MSFT	Stock	157.27	157.27	157.27	157.27	230.0
2019-12-24 16:30:00	MSFT	Stock	157.35	157.35	157.35	157.35	100.0
2019-12-24 04:00:00	NVDA	Stock	5.9702	5.9702	5.9702	5.9702	4520.0
2019-12-24 04:30:00	NVDA	Stock	5.9702	5.9702	5.9702	5.9702	4000.0
2019-12-24 05:00:00	NVDA	Stock	5.9702	5.9702	5.9702	5.9702	8000.0
2019-12-24 07:00:00	NVDA	Stock	5.9752	5.9825	5.9752	5.9825	29520.0
2019-12-24 07:30:00	NVDA	Stock	5.9812	5.9812	5.9788	5.9788	39600.0
2019-12-24 08:00:00	NVDA	Stock	5.9825	5.985	5.9558	5.9788	233960.0
2019-12-24 08:30:00	NVDA	Stock	5.9793	5.9823	5.9788	5.9823	65440.0

> showing 50 of 49,417 rows — these rows as CSV

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