PREVIEW / stock_1hour / 2019-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-11.parquet
  size:    1.1 MB
  rows:    50,122
  symbols: 2,481

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-11 04:00:00	AAPL	Stock	67.13	67.225	67.1025	67.15	15268.0
2019-12-11 05:00:00	AAPL	Stock	67.1925	67.2675	67.1925	67.1925	17824.0
2019-12-11 06:00:00	AAPL	Stock	67.2225	67.4075	67.2225	67.375	16420.0
2019-12-11 07:00:00	AAPL	Stock	67.3625	67.4	67.2775	67.3425	113584.0
2019-12-11 08:00:00	AAPL	Stock	67.343	67.4375	67.2875	67.4	194524.0
2019-12-11 09:00:00	AAPL	Stock	67.3875	67.685	67.125	67.66	12268336.0
2019-12-11 10:00:00	AAPL	Stock	67.66	67.7675	67.335	67.365	12651716.0
2019-12-11 11:00:00	AAPL	Stock	67.365	67.6025	67.2712	67.515	7330088.0
2019-12-11 12:00:00	AAPL	Stock	67.515	67.56	67.4025	67.4925	4209660.0
2019-12-11 13:00:00	AAPL	Stock	67.495	67.5575	67.45	67.4775	3548864.0
2019-12-11 14:00:00	AAPL	Stock	67.48	67.6675	67.445	67.665	7456020.0
2019-12-11 15:00:00	AAPL	Stock	67.665	67.775	67.535	67.685	11342532.0
2019-12-11 16:00:00	AAPL	Stock	67.6925	67.745	67.6625	67.7025	7907916.0
2019-12-11 17:00:00	AAPL	Stock	67.7075	67.7175	67.6875	67.6875	47356.0
2019-12-11 18:00:00	AAPL	Stock	67.6975	67.75	67.6825	67.745	51444.0
2019-12-11 19:00:00	AAPL	Stock	67.75	67.7625	67.675	67.7625	62860.0
2019-12-11 05:00:00	MSFT	Stock	151.4	151.4	151.0	151.34	1452.0
2019-12-11 06:00:00	MSFT	Stock	151.34	151.34	151.18	151.3	1998.0
2019-12-11 07:00:00	MSFT	Stock	151.39	151.4	151.28	151.4	3176.0
2019-12-11 08:00:00	MSFT	Stock	151.3	151.6	151.26	151.42	20708.0
2019-12-11 09:00:00	MSFT	Stock	151.44	151.83	150.33	150.9	2642718.0
2019-12-11 10:00:00	MSFT	Stock	150.9	151.19	150.85	151.04	1931696.0
2019-12-11 11:00:00	MSFT	Stock	151.04	151.45	150.91	151.1	1837426.0
2019-12-11 12:00:00	MSFT	Stock	151.09	151.24	150.96	151.14	902750.0
2019-12-11 13:00:00	MSFT	Stock	151.145	151.18	150.994	151.12	692730.0
2019-12-11 14:00:00	MSFT	Stock	151.11	151.85	150.97	151.805	1717711.0
2019-12-11 15:00:00	MSFT	Stock	151.81	151.87	151.48	151.69	2897467.0
2019-12-11 16:00:00	MSFT	Stock	151.67	151.74	151.125	151.68	3118532.0
2019-12-11 17:00:00	MSFT	Stock	151.62	151.73	151.61	151.66	1846.0
2019-12-11 18:00:00	MSFT	Stock	151.7	151.76	151.69	151.76	1653.0
2019-12-11 19:00:00	MSFT	Stock	151.76	151.78	151.75	151.75	1567.0
2019-12-11 04:00:00	NVDA	Stock	5.3585	5.3585	5.3585	5.3585	4000.0
2019-12-11 05:00:00	NVDA	Stock	5.361	5.361	5.361	5.361	24000.0
2019-12-11 06:00:00	NVDA	Stock	5.361	5.361	5.361	5.361	20000.0
2019-12-11 07:00:00	NVDA	Stock	5.3625	5.37	5.3612	5.3665	205240.0
2019-12-11 08:00:00	NVDA	Stock	5.3658	5.3755	5.3625	5.3712	363880.0
2019-12-11 09:00:00	NVDA	Stock	5.3725	5.4002	5.3575	5.3918	29940800.0
2019-12-11 10:00:00	NVDA	Stock	5.392	5.4118	5.3828	5.384	38437640.0
2019-12-11 11:00:00	NVDA	Stock	5.384	5.4103	5.3742	5.3979	19355360.0
2019-12-11 12:00:00	NVDA	Stock	5.3965	5.408	5.394	5.3996	13940520.0
2019-12-11 13:00:00	NVDA	Stock	5.401	5.4125	5.3921	5.4096	16253520.0
2019-12-11 14:00:00	NVDA	Stock	5.4095	5.4315	5.4043	5.4274	29901760.0
2019-12-11 15:00:00	NVDA	Stock	5.4275	5.439	5.4152	5.4338	34779240.0
2019-12-11 16:00:00	NVDA	Stock	5.4335	5.435	5.4279	5.435	24941000.0
2019-12-11 17:00:00	NVDA	Stock	5.437	5.4395	5.434	5.4375	53520.0
2019-12-11 18:00:00	NVDA	Stock	5.4395	5.4395	5.435	5.4375	104880.0
2019-12-11 19:00:00	NVDA	Stock	5.4375	5.4435	5.435	5.435	55320.0
2019-12-11 07:00:00	AMZN	Stock	87.122	87.122	87.122	87.122	2840.0
2019-12-11 08:00:00	AMZN	Stock	87.122	87.1715	87.122	87.1715	24200.0
2019-12-11 09:00:00	AMZN	Stock	87.15	87.2332	86.7855	87.13	4051960.0

> showing 50 of 50,122 rows — these rows as CSV

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