PREVIEW / stock_1hour / 2022-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-02.parquet
  size:    1.3 MB
  rows:    60,747
  symbols: 2,084

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
2022-11-02 04:00:00	AAPL	Stock	150.72	150.93	150.41	150.6	21777.0
2022-11-02 05:00:00	AAPL	Stock	150.6	150.6	150.15	150.38	11178.0
2022-11-02 06:00:00	AAPL	Stock	150.34	150.4	149.69	149.8	57336.0
2022-11-02 07:00:00	AAPL	Stock	149.95	150.0	149.22	149.38	99518.0
2022-11-02 08:00:00	AAPL	Stock	149.9	150.0	148.45	148.86	365678.0
2022-11-02 09:00:00	AAPL	Stock	148.86	150.6	148.44	148.68	7903546.0
2022-11-02 10:00:00	AAPL	Stock	148.68	149.64	148.67	149.3	7040783.0
2022-11-02 11:00:00	AAPL	Stock	149.3	149.4499	148.33	148.9146	6328482.0
2022-11-02 12:00:00	AAPL	Stock	148.925	149.26	148.19	149.21	5250391.0
2022-11-02 13:00:00	AAPL	Stock	149.205	149.66	148.7	149.03	5036628.0
2022-11-02 14:00:00	AAPL	Stock	149.04	152.17	147.35	147.785	19890348.0
2022-11-02 15:00:00	AAPL	Stock	147.7589	148.8324	145.0	145.01	19718274.0
2022-11-02 16:00:00	AAPL	Stock	145.03	145.22	144.15	144.5	10298939.0
2022-11-02 17:00:00	AAPL	Stock	144.51	144.91	144.5	144.55	165261.0
2022-11-02 18:00:00	AAPL	Stock	144.54	144.57	144.1	144.25	115741.0
2022-11-02 19:00:00	AAPL	Stock	144.25	144.29	144.09	144.1	58241.0
2022-11-02 04:00:00	MSFT	Stock	228.01	228.83	228.01	228.5	1312.0
2022-11-02 05:00:00	MSFT	Stock	228.77	228.77	228.39	228.5	7677.0
2022-11-02 06:00:00	MSFT	Stock	228.6	228.6	228.34	228.34	2079.0
2022-11-02 07:00:00	MSFT	Stock	228.21	228.65	228.0	228.6	12295.0
2022-11-02 08:00:00	MSFT	Stock	228.1	228.99	227.68	228.7158	60902.0
2022-11-02 09:00:00	MSFT	Stock	228.75	229.46	226.45	226.475	2281546.0
2022-11-02 10:00:00	MSFT	Stock	226.475	227.12	226.01	226.42	2339586.0
2022-11-02 11:00:00	MSFT	Stock	226.405	226.68	224.68	225.04	2657513.0
2022-11-02 12:00:00	MSFT	Stock	225.05	225.78	224.5	225.575	1950685.0
2022-11-02 13:00:00	MSFT	Stock	225.56	227.18	225.1967	226.6444	1749800.0
2022-11-02 14:00:00	MSFT	Stock	226.71	231.3	224.22	224.95	6210041.0
2022-11-02 15:00:00	MSFT	Stock	224.95	226.47	220.04	220.07	7165759.0
2022-11-02 16:00:00	MSFT	Stock	220.1	220.89	219.78	220.64	5438480.0
2022-11-02 17:00:00	MSFT	Stock	220.5	220.63	220.3	220.42	29658.0
2022-11-02 18:00:00	MSFT	Stock	220.41	220.41	219.81	220.29	20337.0
2022-11-02 19:00:00	MSFT	Stock	220.1	220.37	219.86	220.1	13747.0
2022-11-02 04:00:00	NVDA	Stock	13.641	13.778	13.641	13.746	26580.0
2022-11-02 05:00:00	NVDA	Stock	13.759	13.759	13.726	13.732	12890.0
2022-11-02 06:00:00	NVDA	Stock	13.74	13.74	13.672	13.672	37640.0
2022-11-02 07:00:00	NVDA	Stock	13.7	13.776	13.69	13.75	169570.0
2022-11-02 08:00:00	NVDA	Stock	13.727	13.786	13.7	13.735	846840.0
2022-11-02 09:00:00	NVDA	Stock	13.727	14.157	13.681	14.0067	88832740.0
2022-11-02 10:00:00	NVDA	Stock	14.006	14.07	13.793	13.956	83237480.0
2022-11-02 11:00:00	NVDA	Stock	13.957	13.99	13.812	13.8475	51052800.0
2022-11-02 12:00:00	NVDA	Stock	13.851	13.902	13.717	13.782	41896430.0
2022-11-02 13:00:00	NVDA	Stock	13.782	13.83	13.706	13.826	32301160.0
2022-11-02 14:00:00	NVDA	Stock	13.824	14.21	13.582	13.68	127933580.0
2022-11-02 15:00:00	NVDA	Stock	13.678	13.874	13.2112	13.222	111724860.0
2022-11-02 16:00:00	NVDA	Stock	13.219	13.274	13.148	13.245	31896680.0
2022-11-02 17:00:00	NVDA	Stock	13.245	13.275	13.22	13.22	344570.0
2022-11-02 18:00:00	NVDA	Stock	13.223	13.224	13.18	13.18	322570.0
2022-11-02 19:00:00	NVDA	Stock	13.181	13.197	13.145	13.17	339710.0
2022-11-02 04:00:00	AMZN	Stock	97.67	97.68	97.1	97.41	31484.0
2022-11-02 05:00:00	AMZN	Stock	97.41	97.49	96.86	97.2	35724.0

> showing 50 of 60,747 rows — these rows as CSV

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