PREVIEW / stock_1hour / 2022-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-25.parquet
  size:    1.4 MB
  rows:    64,134
  symbols: 2,484

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-25 04:00:00	AAPL	Stock	173.81	173.88	172.74	173.28	55484.0
2022-03-25 05:00:00	AAPL	Stock	173.37	173.8	173.27	173.77	22124.0
2022-03-25 06:00:00	AAPL	Stock	173.82	174.31	173.76	174.25	25498.0
2022-03-25 07:00:00	AAPL	Stock	174.1	174.76	174.09	174.62	146532.0
2022-03-25 08:00:00	AAPL	Stock	174.24	174.76	172.8	174.05	605030.0
2022-03-25 09:00:00	AAPL	Stock	174.0501	174.65	173.03	173.8	9943325.0
2022-03-25 10:00:00	AAPL	Stock	173.781	175.28	173.55	174.56	13109220.0
2022-03-25 11:00:00	AAPL	Stock	174.57	174.6585	172.75	173.08	10555289.0
2022-03-25 12:00:00	AAPL	Stock	173.0983	173.75	172.845	173.275	6547757.0
2022-03-25 13:00:00	AAPL	Stock	173.28	174.3299	172.91	174.29	5999880.0
2022-03-25 14:00:00	AAPL	Stock	174.29	174.78	174.17	174.715	5984504.0
2022-03-25 15:00:00	AAPL	Stock	174.715	174.8	173.33	174.73	11575424.0
2022-03-25 16:00:00	AAPL	Stock	174.73	174.77	174.5	174.55	5674137.0
2022-03-25 17:00:00	AAPL	Stock	174.53	174.69	174.52	174.69	54229.0
2022-03-25 18:00:00	AAPL	Stock	174.69	174.93	174.68	174.85	32818.0
2022-03-25 19:00:00	AAPL	Stock	174.93	175.0	174.7601	175.0	39694.0
2022-03-25 04:00:00	MSFT	Stock	304.07	304.12	303.32	304.02	6354.0
2022-03-25 05:00:00	MSFT	Stock	304.1	304.66	303.61	304.1	2749.0
2022-03-25 06:00:00	MSFT	Stock	304.5	305.0	304.5	305.0	1768.0
2022-03-25 07:00:00	MSFT	Stock	304.9	306.21	304.6	306.0	16548.0
2022-03-25 08:00:00	MSFT	Stock	304.9278	306.2	304.6	305.6	42509.0
2022-03-25 09:00:00	MSFT	Stock	305.56	305.66	302.92	302.9533	1822964.0
2022-03-25 10:00:00	MSFT	Stock	303.0	305.1905	301.82	303.56	2146769.0
2022-03-25 11:00:00	MSFT	Stock	303.57	303.77	299.2855	299.9386	2630982.0
2022-03-25 12:00:00	MSFT	Stock	299.959	301.6199	299.77	301.13	1584444.0
2022-03-25 13:00:00	MSFT	Stock	301.15	302.47	300.67	302.4	1175115.0
2022-03-25 14:00:00	MSFT	Stock	302.42	302.9	302.01	302.86	1353886.0
2022-03-25 15:00:00	MSFT	Stock	302.84	303.79	300.94	303.69	2859559.0
2022-03-25 16:00:00	MSFT	Stock	303.68	304.0	303.26	303.4	2800256.0
2022-03-25 17:00:00	MSFT	Stock	303.45	303.65	303.42	303.49	10772.0
2022-03-25 18:00:00	MSFT	Stock	303.45	303.86	303.45	303.51	2974.0
2022-03-25 19:00:00	MSFT	Stock	303.76	303.85	303.6	303.75	7941.0
2022-03-25 04:00:00	NVDA	Stock	28.31	28.83	27.754	27.93	403270.0
2022-03-25 05:00:00	NVDA	Stock	27.979	28.075	27.834	28.073	70690.0
2022-03-25 06:00:00	NVDA	Stock	28.05	28.239	28.045	28.218	149920.0
2022-03-25 07:00:00	NVDA	Stock	28.201	28.221	28.07	28.171	733230.0
2022-03-25 08:00:00	NVDA	Stock	28.1998	28.299	27.86	28.21	1677840.0
2022-03-25 09:00:00	NVDA	Stock	28.204	28.358	27.703	27.817	79536890.0
2022-03-25 10:00:00	NVDA	Stock	27.825	28.05	27.6	27.826	81573570.0
2022-03-25 11:00:00	NVDA	Stock	27.83	27.863	27.361	27.4541	60246420.0
2022-03-25 12:00:00	NVDA	Stock	27.455	27.684	27.271	27.573	45400710.0
2022-03-25 13:00:00	NVDA	Stock	27.575	27.746	27.471	27.735	33299310.0
2022-03-25 14:00:00	NVDA	Stock	27.74	27.913	27.701	27.823	51055290.0
2022-03-25 15:00:00	NVDA	Stock	27.828	27.847	27.377	27.717	70851490.0
2022-03-25 16:00:00	NVDA	Stock	27.692	27.75	27.62	27.689	16939010.0
2022-03-25 17:00:00	NVDA	Stock	27.685	27.689	27.6537	27.678	191880.0
2022-03-25 18:00:00	NVDA	Stock	27.67	27.685	27.62	27.681	187270.0
2022-03-25 19:00:00	NVDA	Stock	27.681	27.69	27.65	27.683	260430.0
2022-03-25 04:00:00	AMZN	Stock	163.1	163.1	163.1	163.1	4000.0
2022-03-25 07:00:00	AMZN	Stock	163.748	164.0	163.748	164.0	11180.0

> showing 50 of 64,134 rows — these rows as CSV

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