PREVIEW / stock_1hour / 2020-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-02.parquet
  size:    1.3 MB
  rows:    61,154
  symbols: 2,614

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-12-02 04:00:00	AAPL	Stock	122.5	122.55	122.05	122.45	16661.0
2020-12-02 05:00:00	AAPL	Stock	122.45	122.67	122.4	122.61	6749.0
2020-12-02 06:00:00	AAPL	Stock	122.61	122.65	122.36	122.57	11266.0
2020-12-02 07:00:00	AAPL	Stock	122.51	122.65	121.76	122.04	263045.0
2020-12-02 08:00:00	AAPL	Stock	122.55	123.02	121.76	122.15	504325.0
2020-12-02 09:00:00	AAPL	Stock	122.15	122.773	120.89	122.015	15251169.0
2020-12-02 10:00:00	AAPL	Stock	122.01	122.5	121.56	121.995	11743149.0
2020-12-02 11:00:00	AAPL	Stock	122.01	122.82	121.7	122.55	8115431.0
2020-12-02 12:00:00	AAPL	Stock	122.544	123.25	122.49	122.915	8045554.0
2020-12-02 13:00:00	AAPL	Stock	122.92	123.37	122.7	122.955	7514473.0
2020-12-02 14:00:00	AAPL	Stock	122.95	123.13	122.65	122.95	6712977.0
2020-12-02 15:00:00	AAPL	Stock	122.95	123.24	122.88	123.08	10260960.0
2020-12-02 16:00:00	AAPL	Stock	123.08	123.3	123.05	123.18	9614838.0
2020-12-02 17:00:00	AAPL	Stock	123.16	123.21	123.08	123.1	85699.0
2020-12-02 18:00:00	AAPL	Stock	123.08	123.18	122.9	123.01	99853.0
2020-12-02 19:00:00	AAPL	Stock	123.02	123.23	123.0	123.23	73024.0
2020-12-02 04:00:00	MSFT	Stock	216.5	216.73	216.48	216.5	6625.0
2020-12-02 05:00:00	MSFT	Stock	216.5	216.5	216.35	216.35	1079.0
2020-12-02 06:00:00	MSFT	Stock	216.06	216.22	215.94	216.18	3343.0
2020-12-02 07:00:00	MSFT	Stock	216.18	216.19	215.0	215.3	18321.0
2020-12-02 08:00:00	MSFT	Stock	215.8	215.96	215.1	215.6	36001.0
2020-12-02 09:00:00	MSFT	Stock	215.65	215.69	212.8	213.835	3153345.0
2020-12-02 10:00:00	MSFT	Stock	213.82	214.666	213.115	214.11	2981788.0
2020-12-02 11:00:00	MSFT	Stock	214.12	214.84	213.75	214.73	1938189.0
2020-12-02 12:00:00	MSFT	Stock	214.725	214.75	213.86	213.958	1399972.0
2020-12-02 13:00:00	MSFT	Stock	213.96	214.5	213.77	214.324	1154323.0
2020-12-02 14:00:00	MSFT	Stock	214.33	215.12	214.25	215.12	1435812.0
2020-12-02 15:00:00	MSFT	Stock	215.125	215.47	214.7	215.42	2042772.0
2020-12-02 16:00:00	MSFT	Stock	215.37	215.53	215.15	215.3	4988229.0
2020-12-02 17:00:00	MSFT	Stock	215.3	215.5	215.26	215.39	11326.0
2020-12-02 18:00:00	MSFT	Stock	215.45	215.45	215.26	215.26	7930.0
2020-12-02 19:00:00	MSFT	Stock	215.26	215.38	215.15	215.38	3858.0
2020-12-02 06:00:00	NVDA	Stock	13.35	13.35	13.35	13.35	21160.0
2020-12-02 07:00:00	NVDA	Stock	13.36	13.36	13.2932	13.3	445560.0
2020-12-02 08:00:00	NVDA	Stock	13.3325	13.3335	13.26	13.2912	334800.0
2020-12-02 09:00:00	NVDA	Stock	13.2804	13.3885	13.2342	13.3662	37808440.0
2020-12-02 10:00:00	NVDA	Stock	13.3648	13.6385	13.3588	13.5728	62974880.0
2020-12-02 11:00:00	NVDA	Stock	13.574	13.6734	13.5655	13.62	43788280.0
2020-12-02 12:00:00	NVDA	Stock	13.618	13.6185	13.5252	13.5301	20272240.0
2020-12-02 13:00:00	NVDA	Stock	13.5326	13.62	13.515	13.5312	16585840.0
2020-12-02 14:00:00	NVDA	Stock	13.5358	13.6125	13.5158	13.612	12776600.0
2020-12-02 15:00:00	NVDA	Stock	13.6125	13.6175	13.525	13.5442	23462120.0
2020-12-02 16:00:00	NVDA	Stock	13.5445	13.5618	13.5275	13.5588	15360520.0
2020-12-02 17:00:00	NVDA	Stock	13.5575	13.5575	13.5512	13.5512	84080.0
2020-12-02 18:00:00	NVDA	Stock	13.5562	13.5562	13.5375	13.5525	323120.0
2020-12-02 19:00:00	NVDA	Stock	13.5522	13.554	13.5452	13.5512	94440.0
2020-12-02 04:00:00	AMZN	Stock	161.0	161.0	161.0	161.0	4160.0
2020-12-02 06:00:00	AMZN	Stock	160.55	160.7505	160.55	160.75	10900.0
2020-12-02 07:00:00	AMZN	Stock	160.75	161.85	160.75	161.65	369220.0
2020-12-02 08:00:00	AMZN	Stock	161.0	161.7	160.994	161.4	276100.0

> showing 50 of 61,154 rows — these rows as CSV

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