PREVIEW / stock_1hour / 2020-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-02.parquet
  size:    1.2 MB
  rows:    53,719
  symbols: 2,408

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-04-02 04:00:00	AAPL	Stock	61.1525	61.55	61.1	61.355	32548.0
2020-04-02 05:00:00	AAPL	Stock	61.355	61.3825	60.8	60.8775	20440.0
2020-04-02 06:00:00	AAPL	Stock	60.9225	61.3	60.8	61.125	48120.0
2020-04-02 07:00:00	AAPL	Stock	61.17	61.28	60.825	61.28	412036.0
2020-04-02 08:00:00	AAPL	Stock	61.25	61.3175	60.05	60.2775	1023812.0
2020-04-02 09:00:00	AAPL	Stock	60.275	60.525	59.395	59.8388	19194592.0
2020-04-02 10:00:00	AAPL	Stock	59.8475	61.0875	59.7275	60.65	23455040.0
2020-04-02 11:00:00	AAPL	Stock	60.6425	60.8275	60.3	60.675	14260428.0
2020-04-02 12:00:00	AAPL	Stock	60.685	60.8825	60.425	60.6638	10135024.0
2020-04-02 13:00:00	AAPL	Stock	60.6725	60.8125	59.74	60.0375	13379820.0
2020-04-02 14:00:00	AAPL	Stock	60.0475	60.2775	59.225	60.24	18620696.0
2020-04-02 15:00:00	AAPL	Stock	60.25	61.2875	60.125	61.2325	29808672.0
2020-04-02 16:00:00	AAPL	Stock	61.2325	61.43	61.1625	61.28	11436824.0
2020-04-02 17:00:00	AAPL	Stock	61.275	61.3625	61.225	61.3625	124548.0
2020-04-02 18:00:00	AAPL	Stock	61.3275	61.375	61.13	61.25	142252.0
2020-04-02 19:00:00	AAPL	Stock	61.2812	61.3275	60.9	60.975	135664.0
2020-04-02 04:00:00	MSFT	Stock	154.81	155.5	154.7	154.95	7611.0
2020-04-02 05:00:00	MSFT	Stock	155.0	155.0	154.0	154.0	8231.0
2020-04-02 06:00:00	MSFT	Stock	154.0	154.75	153.53	153.88	9666.0
2020-04-02 07:00:00	MSFT	Stock	154.24	154.9	153.6	154.9	76549.0
2020-04-02 08:00:00	MSFT	Stock	154.0	155.2	151.8	152.4	299797.0
2020-04-02 09:00:00	MSFT	Stock	152.4	155.12	150.36	151.674	6362062.0
2020-04-02 10:00:00	MSFT	Stock	151.665	154.55	151.36	153.425	6781915.0
2020-04-02 11:00:00	MSFT	Stock	153.41	155.01	152.86	154.86	4192561.0
2020-04-02 12:00:00	MSFT	Stock	154.91	155.48	153.74	154.26	3497207.0
2020-04-02 13:00:00	MSFT	Stock	154.28	154.935	151.86	152.95	4047854.0
2020-04-02 14:00:00	MSFT	Stock	152.94	153.09	151.3	153.02	4504811.0
2020-04-02 15:00:00	MSFT	Stock	153.03	155.48	152.53	155.26	7723593.0
2020-04-02 16:00:00	MSFT	Stock	155.26	155.69	153.622	155.21	4740386.0
2020-04-02 17:00:00	MSFT	Stock	155.2	155.3	155.0	155.3	20016.0
2020-04-02 18:00:00	MSFT	Stock	155.3	155.65	155.0	155.2	17089.0
2020-04-02 19:00:00	MSFT	Stock	155.39	155.48	154.1	154.25	23715.0
2020-04-02 04:00:00	NVDA	Stock	6.2575	6.2575	6.2385	6.2385	46040.0
2020-04-02 05:00:00	NVDA	Stock	6.2388	6.2388	6.225	6.23	94600.0
2020-04-02 07:00:00	NVDA	Stock	6.2125	6.2312	6.1928	6.2308	1627600.0
2020-04-02 08:00:00	NVDA	Stock	6.215	6.2425	6.0803	6.1188	3379480.0
2020-04-02 09:00:00	NVDA	Stock	6.103	6.2468	6.0132	6.1603	86373600.0
2020-04-02 10:00:00	NVDA	Stock	6.1625	6.315	6.1155	6.2361	94914840.0
2020-04-02 11:00:00	NVDA	Stock	6.2338	6.3612	6.2205	6.3346	80611280.0
2020-04-02 12:00:00	NVDA	Stock	6.3365	6.3612	6.2648	6.293	61251320.0
2020-04-02 13:00:00	NVDA	Stock	6.2965	6.3173	6.1712	6.224	63631680.0
2020-04-02 14:00:00	NVDA	Stock	6.2228	6.2948	6.1455	6.2868	61584320.0
2020-04-02 15:00:00	NVDA	Stock	6.2888	6.4	6.273	6.3893	109458840.0
2020-04-02 16:00:00	NVDA	Stock	6.3868	6.42	6.375	6.3882	22895880.0
2020-04-02 17:00:00	NVDA	Stock	6.3875	6.3925	6.375	6.39	527440.0
2020-04-02 18:00:00	NVDA	Stock	6.39	6.4075	6.3768	6.3958	636560.0
2020-04-02 19:00:00	NVDA	Stock	6.3958	6.4062	6.3395	6.3532	845080.0
2020-04-02 04:00:00	AMZN	Stock	96.4	96.7	96.4	96.5345	11880.0
2020-04-02 06:00:00	AMZN	Stock	96.2	96.2	96.2	96.2	2940.0
2020-04-02 07:00:00	AMZN	Stock	96.15	96.15	95.9	96.0875	49840.0

> showing 50 of 53,719 rows — these rows as CSV

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