PREVIEW / stock_1hour / 2023-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-06.parquet
  size:    1.4 MB
  rows:    62,464
  symbols: 1,874

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-02-06 04:00:00	AAPL	Stock	153.51	153.51	152.87	152.96	72077.0
2023-02-06 05:00:00	AAPL	Stock	153.03	153.04	152.65	152.93	38613.0
2023-02-06 06:00:00	AAPL	Stock	152.84	152.93	152.5	152.7	45878.0
2023-02-06 07:00:00	AAPL	Stock	152.85	153.24	152.6	152.97	160979.0
2023-02-06 08:00:00	AAPL	Stock	152.9731	154.114	152.55	152.87	392597.0
2023-02-06 09:00:00	AAPL	Stock	152.89	153.24	151.71	152.48	10051748.0
2023-02-06 10:00:00	AAPL	Stock	152.48	152.7101	150.9	152.27	10437799.0
2023-02-06 11:00:00	AAPL	Stock	152.28	153.1	151.98	152.04	6266543.0
2023-02-06 12:00:00	AAPL	Stock	152.0301	152.79	151.81	152.428	4319211.0
2023-02-06 13:00:00	AAPL	Stock	152.42	152.5194	151.585	152.154	4593403.0
2023-02-06 14:00:00	AAPL	Stock	152.159	152.52	151.51	151.645	5253403.0
2023-02-06 15:00:00	AAPL	Stock	151.64	151.91	150.78	151.68	8835988.0
2023-02-06 16:00:00	AAPL	Stock	151.68	152.03	151.58	151.65	6330552.0
2023-02-06 17:00:00	AAPL	Stock	151.67	151.73	151.63	151.7	22207.0
2023-02-06 18:00:00	AAPL	Stock	151.68	151.89	151.64	151.74	37973.0
2023-02-06 19:00:00	AAPL	Stock	151.82	152.0	151.82	151.98	38777.0
2023-02-06 04:00:00	MSFT	Stock	257.34	258.33	256.25	256.25	7290.0
2023-02-06 05:00:00	MSFT	Stock	256.08	256.08	255.14	256.0	5489.0
2023-02-06 06:00:00	MSFT	Stock	255.59	255.91	255.33	255.89	9979.0
2023-02-06 07:00:00	MSFT	Stock	255.99	256.6	255.83	256.2	22890.0
2023-02-06 08:00:00	MSFT	Stock	256.55	258.35	255.0	255.3	121164.0
2023-02-06 09:00:00	MSFT	Stock	255.2	257.75	255.2	256.64	2141209.0
2023-02-06 10:00:00	MSFT	Stock	256.67	257.93	254.78	257.13	2449478.0
2023-02-06 11:00:00	MSFT	Stock	257.15	258.3	256.78	257.02	1404560.0
2023-02-06 12:00:00	MSFT	Stock	256.98	257.36	256.48	256.8	1385643.0
2023-02-06 13:00:00	MSFT	Stock	256.78	257.07	255.6985	256.235	1459703.0
2023-02-06 14:00:00	MSFT	Stock	256.215	257.27	256.19	257.01	1820726.0
2023-02-06 15:00:00	MSFT	Stock	257.0038	257.23	256.06	256.76	2453262.0
2023-02-06 16:00:00	MSFT	Stock	256.77	257.09	256.64	256.77	2919069.0
2023-02-06 17:00:00	MSFT	Stock	256.69	256.98	256.61	256.85	13675.0
2023-02-06 18:00:00	MSFT	Stock	256.89	257.33	256.88	257.19	15473.0
2023-02-06 19:00:00	MSFT	Stock	257.24	257.89	257.21	257.89	17080.0
2023-02-06 04:00:00	NVDA	Stock	20.973	20.973	20.618	20.618	142980.0
2023-02-06 05:00:00	NVDA	Stock	20.616	20.676	20.6	20.676	71850.0
2023-02-06 06:00:00	NVDA	Stock	20.688	20.69	20.62	20.69	55930.0
2023-02-06 07:00:00	NVDA	Stock	20.698	20.915	20.649	20.846	569030.0
2023-02-06 08:00:00	NVDA	Stock	20.7291	20.999	20.7	20.7866	1026630.0
2023-02-06 09:00:00	NVDA	Stock	20.776	21.414	20.739	21.263	66035780.0
2023-02-06 10:00:00	NVDA	Stock	21.271	21.434	20.965	21.243	74377690.0
2023-02-06 11:00:00	NVDA	Stock	21.243	21.57	21.17	21.341	58901510.0
2023-02-06 12:00:00	NVDA	Stock	21.3385	21.419	21.181	21.215	36526430.0
2023-02-06 13:00:00	NVDA	Stock	21.2153	21.2191	21.05	21.1535	35330770.0
2023-02-06 14:00:00	NVDA	Stock	21.157	21.32	21.022	21.2479	42919850.0
2023-02-06 15:00:00	NVDA	Stock	21.246	21.2515	20.9975	21.084	42593470.0
2023-02-06 16:00:00	NVDA	Stock	21.089	21.114	21.052	21.105	17206420.0
2023-02-06 17:00:00	NVDA	Stock	21.1	21.112	21.089	21.11	153750.0
2023-02-06 18:00:00	NVDA	Stock	21.11	21.185	21.105	21.175	176550.0
2023-02-06 19:00:00	NVDA	Stock	21.17	21.233	21.145	21.22	299380.0
2023-02-06 04:00:00	AMZN	Stock	102.95	103.0	102.32	102.35	52363.0
2023-02-06 05:00:00	AMZN	Stock	102.33	102.33	101.88	102.25	37558.0

> showing 50 of 62,464 rows — these rows as CSV

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