PREVIEW / stock_1hour / 2023-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-26.parquet
  size:    1.3 MB
  rows:    59,561
  symbols: 1,706

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
2023-04-26 04:00:00	AAPL	Stock	164.84	164.84	164.18	164.47	23987.0
2023-04-26 05:00:00	AAPL	Stock	164.43	164.53	164.0	164.2	29910.0
2023-04-26 06:00:00	AAPL	Stock	164.3	164.4	163.16	163.27	54289.0
2023-04-26 07:00:00	AAPL	Stock	163.29	163.68	162.66	162.89	133870.0
2023-04-26 08:00:00	AAPL	Stock	163.4	164.55	162.75	163.91	431186.0
2023-04-26 09:00:00	AAPL	Stock	163.92	164.14	162.8	164.0291	5497236.0
2023-04-26 10:00:00	AAPL	Stock	164.02	164.2693	163.265	164.185	4830699.0
2023-04-26 11:00:00	AAPL	Stock	164.19	164.94	164.09	164.86	3906424.0
2023-04-26 12:00:00	AAPL	Stock	164.86	165.28	164.1302	164.3008	3311045.0
2023-04-26 13:00:00	AAPL	Stock	164.3071	164.53	163.38	163.5181	3198504.0
2023-04-26 14:00:00	AAPL	Stock	163.51	163.87	163.35	163.5	2919144.0
2023-04-26 15:00:00	AAPL	Stock	163.51	164.19	163.31	163.72	7012764.0
2023-04-26 16:00:00	AAPL	Stock	163.71	164.5	163.65	164.18	5181047.0
2023-04-26 17:00:00	AAPL	Stock	164.15	164.26	164.02	164.2	39811.0
2023-04-26 18:00:00	AAPL	Stock	164.2	164.2	163.9	164.0	38227.0
2023-04-26 19:00:00	AAPL	Stock	164.0	164.03	163.75	164.03	23603.0
2023-04-26 04:00:00	MSFT	Stock	296.7	297.0	295.27	296.03	169429.0
2023-04-26 05:00:00	MSFT	Stock	296.18	297.99	295.66	297.55	110554.0
2023-04-26 06:00:00	MSFT	Stock	297.5	297.64	296.0	296.62	85113.0
2023-04-26 07:00:00	MSFT	Stock	296.88	297.33	294.28	296.5	419043.0
2023-04-26 08:00:00	MSFT	Stock	296.81	299.1	294.22	298.3	949103.0
2023-04-26 09:00:00	MSFT	Stock	298.2	298.29	292.73	294.89	11219334.0
2023-04-26 10:00:00	MSFT	Stock	294.85	296.41	293.52	296.05	8669338.0
2023-04-26 11:00:00	MSFT	Stock	296.13	298.66	295.46	298.658	5933517.0
2023-04-26 12:00:00	MSFT	Stock	298.6501	299.57	296.74	296.935	5478482.0
2023-04-26 13:00:00	MSFT	Stock	296.93	297.758	295.17	296.0425	3343591.0
2023-04-26 14:00:00	MSFT	Stock	296.07	296.33	294.65	295.35	3195962.0
2023-04-26 15:00:00	MSFT	Stock	295.38	296.04	295.1	295.35	5021137.0
2023-04-26 16:00:00	MSFT	Stock	295.37	296.89	294.79	296.16	4988696.0
2023-04-26 17:00:00	MSFT	Stock	296.1015	296.44	296.05	296.1	15569.0
2023-04-26 18:00:00	MSFT	Stock	296.08	296.08	295.5	295.79	30669.0
2023-04-26 19:00:00	MSFT	Stock	295.75	295.9	295.4	295.9	20917.0
2023-04-26 04:00:00	NVDA	Stock	26.89	26.89	26.781	26.856	185690.0
2023-04-26 05:00:00	NVDA	Stock	26.835	26.868	26.767	26.8	154260.0
2023-04-26 06:00:00	NVDA	Stock	26.835	26.838	26.7	26.741	174940.0
2023-04-26 07:00:00	NVDA	Stock	26.75	26.918	26.715	26.836	1102020.0
2023-04-26 08:00:00	NVDA	Stock	26.756	27.0	26.715	26.93	1413170.0
2023-04-26 09:00:00	NVDA	Stock	26.938	27.108	26.7051	27.0149	56157460.0
2023-04-26 10:00:00	NVDA	Stock	27.011	27.1864	26.863	27.036	62218400.0
2023-04-26 11:00:00	NVDA	Stock	27.0359	27.305	27.0296	27.254	46480080.0
2023-04-26 12:00:00	NVDA	Stock	27.256	27.33	27.108	27.143	30426770.0
2023-04-26 13:00:00	NVDA	Stock	27.142	27.264	27.077	27.196	33081060.0
2023-04-26 14:00:00	NVDA	Stock	27.195	27.204	26.947	26.9609	29630380.0
2023-04-26 15:00:00	NVDA	Stock	26.961	27.024	26.853	26.956	47665470.0
2023-04-26 16:00:00	NVDA	Stock	26.956	27.165	26.95	27.085	15893310.0
2023-04-26 17:00:00	NVDA	Stock	27.08	27.161	27.078	27.132	338580.0
2023-04-26 18:00:00	NVDA	Stock	27.14	27.195	27.115	27.155	409030.0
2023-04-26 19:00:00	NVDA	Stock	27.155	27.175	27.155	27.163	199420.0
2023-04-26 04:00:00	AMZN	Stock	106.73	106.73	105.85	106.35	66197.0
2023-04-26 05:00:00	AMZN	Stock	106.45	106.45	106.02	106.35	30082.0

> showing 50 of 59,561 rows — these rows as CSV

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