PREVIEW / stock_1hour / 2023-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-08.parquet
  size:    1.4 MB
  rows:    60,993
  symbols: 1,849

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-08 04:00:00	AAPL	Stock	154.15	154.38	153.55	153.68	52451.0
2023-02-08 05:00:00	AAPL	Stock	153.86	153.88	153.5	153.76	43408.0
2023-02-08 06:00:00	AAPL	Stock	153.76	153.88	153.52	153.76	16694.0
2023-02-08 07:00:00	AAPL	Stock	153.74	154.24	153.7	153.83	78523.0
2023-02-08 08:00:00	AAPL	Stock	153.9108	154.5	153.5515	153.94	233818.0
2023-02-08 09:00:00	AAPL	Stock	153.9	154.58	153.16	153.45	6913369.0
2023-02-08 10:00:00	AAPL	Stock	153.44	153.77	152.25	153.1612	8314726.0
2023-02-08 11:00:00	AAPL	Stock	153.1606	153.19	151.46	152.23	7146117.0
2023-02-08 12:00:00	AAPL	Stock	152.237	152.25	151.168	151.783	4284110.0
2023-02-08 13:00:00	AAPL	Stock	151.78	152.14	151.22	151.96	4236047.0
2023-02-08 14:00:00	AAPL	Stock	151.96	152.31	151.67	152.19	4137933.0
2023-02-08 15:00:00	AAPL	Stock	152.19	152.3	151.49	151.945	9838134.0
2023-02-08 16:00:00	AAPL	Stock	151.96	152.49	151.92	152.43	9787577.0
2023-02-08 17:00:00	AAPL	Stock	152.43	152.43	151.92	152.14	61428.0
2023-02-08 18:00:00	AAPL	Stock	152.14	152.36	152.1	152.31	41997.0
2023-02-08 19:00:00	AAPL	Stock	152.33	152.5	152.33	152.4	28960.0
2023-02-08 04:00:00	MSFT	Stock	270.0	272.94	269.4	272.35	74332.0
2023-02-08 05:00:00	MSFT	Stock	272.47	273.6	271.58	273.4	38190.0
2023-02-08 06:00:00	MSFT	Stock	273.56	273.56	271.87	271.87	71052.0
2023-02-08 07:00:00	MSFT	Stock	271.97	272.58	270.26	270.9	190169.0
2023-02-08 08:00:00	MSFT	Stock	272.5685	273.0115	266.892	271.48	441601.0
2023-02-08 09:00:00	MSFT	Stock	271.48	276.76	271.02	272.68	10864176.0
2023-02-08 10:00:00	MSFT	Stock	272.69	274.33	270.07	270.325	6841061.0
2023-02-08 11:00:00	MSFT	Stock	270.3101	270.53	267.56	269.6799	5525766.0
2023-02-08 12:00:00	MSFT	Stock	269.65	270.25	268.52	269.7098	2739487.0
2023-02-08 13:00:00	MSFT	Stock	269.71	270.59	268.07	268.86	2874068.0
2023-02-08 14:00:00	MSFT	Stock	268.88	269.6	266.66	267.47	2803352.0
2023-02-08 15:00:00	MSFT	Stock	267.47	267.77	266.21	266.68	5408232.0
2023-02-08 16:00:00	MSFT	Stock	266.75	268.9386	266.73	267.6199	3888123.0
2023-02-08 17:00:00	MSFT	Stock	267.61	267.62	266.73	267.0101	17213.0
2023-02-08 18:00:00	MSFT	Stock	267.1	267.63	267.1	267.5	11284.0
2023-02-08 19:00:00	MSFT	Stock	267.5499	268.1	267.5499	268.07	15426.0
2023-02-08 04:00:00	NVDA	Stock	22.25	22.46	22.25	22.42	221670.0
2023-02-08 05:00:00	NVDA	Stock	22.425	22.432	22.351	22.417	122130.0
2023-02-08 06:00:00	NVDA	Stock	22.381	22.412	22.353	22.379	99170.0
2023-02-08 07:00:00	NVDA	Stock	22.4	22.52	22.36	22.4	1030180.0
2023-02-08 08:00:00	NVDA	Stock	22.462	22.525	22.1176	22.37	3148030.0
2023-02-08 09:00:00	NVDA	Stock	22.37	22.878	22.285	22.6235	87483320.0
2023-02-08 10:00:00	NVDA	Stock	22.615	22.698	22.172	22.209	89324440.0
2023-02-08 11:00:00	NVDA	Stock	22.205	22.3859	22.12	22.362	68639720.0
2023-02-08 12:00:00	NVDA	Stock	22.356	22.5669	22.237	22.5015	49984000.0
2023-02-08 13:00:00	NVDA	Stock	22.499	22.56	22.357	22.39	32790510.0
2023-02-08 14:00:00	NVDA	Stock	22.39	22.424	22.152	22.2233	33284660.0
2023-02-08 15:00:00	NVDA	Stock	22.222	22.325	22.008	22.206	60896920.0
2023-02-08 16:00:00	NVDA	Stock	22.21	22.21	22.175	22.195	21223360.0
2023-02-08 17:00:00	NVDA	Stock	22.195	22.205	22.15	22.16	267730.0
2023-02-08 18:00:00	NVDA	Stock	22.159	22.195	22.107	22.195	196600.0
2023-02-08 19:00:00	NVDA	Stock	22.195	22.232	22.169	22.205	307990.0
2023-02-08 04:00:00	AMZN	Stock	101.9	101.9	101.05	101.41	26451.0
2023-02-08 05:00:00	AMZN	Stock	101.3	101.59	101.18	101.5	18234.0

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

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