PREVIEW / stock_1hour / 2022-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-31.parquet
  size:    1.4 MB
  rows:    65,215
  symbols: 2,546

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-03-31 04:00:00	AAPL	Stock	178.4	179.01	178.08	178.55	26587.0
2022-03-31 05:00:00	AAPL	Stock	178.44	178.5	178.39	178.43	8499.0
2022-03-31 06:00:00	AAPL	Stock	178.42	178.5	178.29	178.32	7954.0
2022-03-31 07:00:00	AAPL	Stock	178.34	178.34	177.75	178.21	94296.0
2022-03-31 08:00:00	AAPL	Stock	177.9604	178.89	177.326	178.15	501809.0
2022-03-31 09:00:00	AAPL	Stock	178.1299	178.18	175.6119	176.24	10282931.0
2022-03-31 10:00:00	AAPL	Stock	176.24	177.17	175.529	176.94	10624750.0
2022-03-31 11:00:00	AAPL	Stock	176.95	177.11	176.3501	177.09	6302537.0
2022-03-31 12:00:00	AAPL	Stock	177.095	177.25	176.45	176.54	4996188.0
2022-03-31 13:00:00	AAPL	Stock	176.5216	176.99	176.14	176.629	5472178.0
2022-03-31 14:00:00	AAPL	Stock	176.625	176.92	176.23	176.905	6099264.0
2022-03-31 15:00:00	AAPL	Stock	176.905	177.24	174.4	174.68	22997402.0
2022-03-31 16:00:00	AAPL	Stock	174.61	175.1	174.5	174.83	20761015.0
2022-03-31 17:00:00	AAPL	Stock	174.87	174.94	174.63	174.69	149628.0
2022-03-31 18:00:00	AAPL	Stock	174.7	174.86	174.65	174.8	65501.0
2022-03-31 19:00:00	AAPL	Stock	174.78	175.0	174.78	174.86	43697.0
2022-03-31 04:00:00	MSFT	Stock	315.0	315.3	315.0	315.0	2275.0
2022-03-31 05:00:00	MSFT	Stock	315.07	315.41	315.07	315.2	3292.0
2022-03-31 06:00:00	MSFT	Stock	315.1	315.1	314.7	314.7	1578.0
2022-03-31 07:00:00	MSFT	Stock	314.98	314.98	314.11	314.87	14337.0
2022-03-31 08:00:00	MSFT	Stock	315.0	315.1	313.076	314.95	45216.0
2022-03-31 09:00:00	MSFT	Stock	314.51	315.14	311.29	311.885	2180885.0
2022-03-31 10:00:00	MSFT	Stock	311.86	313.86	310.9801	313.32	2658497.0
2022-03-31 11:00:00	MSFT	Stock	313.32	313.77	311.92	312.39	1507547.0
2022-03-31 12:00:00	MSFT	Stock	312.39	312.5	310.58	310.83	1140219.0
2022-03-31 13:00:00	MSFT	Stock	310.821	312.05	310.7179	311.46	1262750.0
2022-03-31 14:00:00	MSFT	Stock	311.46	312.13	310.47	312.12	1462082.0
2022-03-31 15:00:00	MSFT	Stock	312.14	312.8083	307.89	308.08	6395610.0
2022-03-31 16:00:00	MSFT	Stock	308.08	310.42	308.02	310.0	9298805.0
2022-03-31 17:00:00	MSFT	Stock	309.92	309.9599	309.07	309.62	28640.0
2022-03-31 18:00:00	MSFT	Stock	309.64	309.95	309.63	309.94	12067.0
2022-03-31 19:00:00	MSFT	Stock	309.77	310.25	309.7	310.24	9898.0
2022-03-31 04:00:00	NVDA	Stock	27.974	28.08	27.892	27.992	257030.0
2022-03-31 05:00:00	NVDA	Stock	28.019	28.17	27.961	28.12	252770.0
2022-03-31 06:00:00	NVDA	Stock	28.087	28.1	27.9	27.931	163830.0
2022-03-31 07:00:00	NVDA	Stock	27.91	27.944	27.767	27.85	580690.0
2022-03-31 08:00:00	NVDA	Stock	27.7836	28.0	27.73	27.83	972620.0
2022-03-31 09:00:00	NVDA	Stock	27.83	27.887	27.37	27.749	45388250.0
2022-03-31 10:00:00	NVDA	Stock	27.747	28.248	27.5303	28.106	76652810.0
2022-03-31 11:00:00	NVDA	Stock	28.107	28.23	27.941	28.013	41068270.0
2022-03-31 12:00:00	NVDA	Stock	28.0131	28.03	27.61	27.6495	36141810.0
2022-03-31 13:00:00	NVDA	Stock	27.6485	27.768	27.467	27.724	32685680.0
2022-03-31 14:00:00	NVDA	Stock	27.7235	27.914	27.625	27.86	37784340.0
2022-03-31 15:00:00	NVDA	Stock	27.863	27.987	27.27	27.274	72869210.0
2022-03-31 16:00:00	NVDA	Stock	27.286	27.462	27.286	27.41	48252910.0
2022-03-31 17:00:00	NVDA	Stock	27.3942	27.417	27.309	27.3406	421300.0
2022-03-31 18:00:00	NVDA	Stock	27.37	27.39	27.332	27.346	167730.0
2022-03-31 19:00:00	NVDA	Stock	27.357	27.4	27.34	27.4	217340.0
2022-03-31 07:00:00	AMZN	Stock	167.0	167.005	167.0	167.0	11140.0
2022-03-31 08:00:00	AMZN	Stock	166.75	167.1	166.75	167.1	24060.0

> showing 50 of 65,215 rows — these rows as CSV

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