PREVIEW / stock_1hour / 2021-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-02.parquet
  size:    1.4 MB
  rows:    66,184
  symbols: 2,955

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-06-02 04:00:00	AAPL	Stock	124.24	124.24	123.98	124.0	12496.0
2021-06-02 05:00:00	AAPL	Stock	124.0	124.18	124.0	124.18	7457.0
2021-06-02 06:00:00	AAPL	Stock	124.12	124.24	124.12	124.24	3287.0
2021-06-02 07:00:00	AAPL	Stock	124.19	124.37	124.1	124.32	77283.0
2021-06-02 08:00:00	AAPL	Stock	124.21	124.59	124.11	124.45	248412.0
2021-06-02 09:00:00	AAPL	Stock	124.45	125.13	124.11	125.035	9294966.0
2021-06-02 10:00:00	AAPL	Stock	125.035	125.24	124.75	124.905	8715633.0
2021-06-02 11:00:00	AAPL	Stock	124.89	125.18	124.65	124.985	5977435.0
2021-06-02 12:00:00	AAPL	Stock	124.99	125.02	124.41	124.415	4518083.0
2021-06-02 13:00:00	AAPL	Stock	124.41	124.56	124.07	124.31	4793817.0
2021-06-02 14:00:00	AAPL	Stock	124.31	124.695	124.05	124.6822	4994172.0
2021-06-02 15:00:00	AAPL	Stock	124.68	125.169	124.51	125.09	8293843.0
2021-06-02 16:00:00	AAPL	Stock	125.06	125.16	124.9	124.96	4421157.0
2021-06-02 17:00:00	AAPL	Stock	124.98	125.04	124.9	124.97	42801.0
2021-06-02 18:00:00	AAPL	Stock	124.97	125.05	124.97	125.02	34960.0
2021-06-02 19:00:00	AAPL	Stock	125.02	125.09	125.0	125.08	45482.0
2021-06-02 04:00:00	MSFT	Stock	247.14	247.4	246.29	246.5	1727.0
2021-06-02 05:00:00	MSFT	Stock	247.0	247.0	247.0	247.0	160.0
2021-06-02 06:00:00	MSFT	Stock	247.21	247.21	247.21	247.21	166.0
2021-06-02 07:00:00	MSFT	Stock	247.36	247.72	247.29	247.65	7110.0
2021-06-02 08:00:00	MSFT	Stock	247.51	247.8	247.4	247.66	17190.0
2021-06-02 09:00:00	MSFT	Stock	247.7	248.91	247.26	248.49	2360118.0
2021-06-02 10:00:00	MSFT	Stock	248.48	249.27	247.94	248.665	2442647.0
2021-06-02 11:00:00	MSFT	Stock	248.67	248.92	248.07	248.12	1531106.0
2021-06-02 12:00:00	MSFT	Stock	248.13	248.29	247.16	247.305	1540303.0
2021-06-02 13:00:00	MSFT	Stock	247.31	247.33	245.97	246.29	1464240.0
2021-06-02 14:00:00	MSFT	Stock	246.29	246.47	245.84	246.46	1168683.0
2021-06-02 15:00:00	MSFT	Stock	246.46	247.45	246.25	247.35	2312762.0
2021-06-02 16:00:00	MSFT	Stock	247.32	247.4	247.16	247.26	2164543.0
2021-06-02 17:00:00	MSFT	Stock	247.17	247.38	247.17	247.3	2295.0
2021-06-02 18:00:00	MSFT	Stock	247.3	247.38	247.25	247.3	7047.0
2021-06-02 19:00:00	MSFT	Stock	247.3	247.46	247.25	247.43	11955.0
2021-06-02 04:00:00	NVDA	Stock	16.2623	16.2623	16.26	16.26	8000.0
2021-06-02 06:00:00	NVDA	Stock	16.2348	16.2348	16.2348	16.2348	12920.0
2021-06-02 07:00:00	NVDA	Stock	16.2423	16.2795	16.225	16.266	125040.0
2021-06-02 08:00:00	NVDA	Stock	16.275	16.2973	16.2275	16.2738	493200.0
2021-06-02 09:00:00	NVDA	Stock	16.275	16.681	16.2125	16.5692	90708920.0
2021-06-02 10:00:00	NVDA	Stock	16.5642	16.783	16.5145	16.7046	97052320.0
2021-06-02 11:00:00	NVDA	Stock	16.7053	16.9189	16.68	16.9	56847240.0
2021-06-02 12:00:00	NVDA	Stock	16.9017	16.9175	16.783	16.8131	35255040.0
2021-06-02 13:00:00	NVDA	Stock	16.8123	16.826	16.6795	16.696	30565760.0
2021-06-02 14:00:00	NVDA	Stock	16.6955	16.7785	16.668	16.7225	29483800.0
2021-06-02 15:00:00	NVDA	Stock	16.722	16.8095	16.6914	16.7818	43661880.0
2021-06-02 16:00:00	NVDA	Stock	16.7782	16.7973	16.75	16.75	14253360.0
2021-06-02 17:00:00	NVDA	Stock	16.7405	16.8372	16.73	16.8243	399040.0
2021-06-02 18:00:00	NVDA	Stock	16.8248	16.8488	16.815	16.8425	303960.0
2021-06-02 19:00:00	NVDA	Stock	16.8432	16.8585	16.8393	16.85	418200.0
2021-06-02 07:00:00	AMZN	Stock	161.15	161.3	161.15	161.3	23520.0
2021-06-02 08:00:00	AMZN	Stock	161.0505	161.3	161.0505	161.3	34000.0
2021-06-02 09:00:00	AMZN	Stock	160.9325	161.5078	160.601	160.6905	2445900.0

> showing 50 of 66,184 rows — these rows as CSV

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