PREVIEW / stock_1hour / 2023-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-06.parquet
  size:    1.4 MB
  rows:    61,033
  symbols: 1,969

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-01-06 04:00:00	AAPL	Stock	125.52	125.52	124.64	124.96	37917.0
2023-01-06 05:00:00	AAPL	Stock	124.96	125.22	124.86	124.86	21240.0
2023-01-06 06:00:00	AAPL	Stock	124.85	125.16	124.8	124.91	9728.0
2023-01-06 07:00:00	AAPL	Stock	124.91	125.08	124.77	124.9	74849.0
2023-01-06 08:00:00	AAPL	Stock	124.86	126.75	124.4	126.4	953506.0
2023-01-06 09:00:00	AAPL	Stock	126.39	127.19	124.89	125.8	10243529.0
2023-01-06 10:00:00	AAPL	Stock	125.8	127.51	125.8	127.41	11782121.0
2023-01-06 11:00:00	AAPL	Stock	127.445	128.04	127.01	127.88	8737940.0
2023-01-06 12:00:00	AAPL	Stock	127.8899	128.48	127.78	127.96	6320278.0
2023-01-06 13:00:00	AAPL	Stock	127.96	128.88	127.89	128.845	5386455.0
2023-01-06 14:00:00	AAPL	Stock	128.85	129.99	128.7833	129.8491	8481302.0
2023-01-06 15:00:00	AAPL	Stock	129.85	130.29	129.34	129.5	13965613.0
2023-01-06 16:00:00	AAPL	Stock	129.49	129.66	129.18	129.341	10401451.0
2023-01-06 17:00:00	AAPL	Stock	129.32	129.35	129.24	129.32	38676.0
2023-01-06 18:00:00	AAPL	Stock	129.29	129.38	129.29	129.35	22396.0
2023-01-06 19:00:00	AAPL	Stock	129.37	129.38	129.26	129.26	35416.0
2023-01-06 04:00:00	MSFT	Stock	222.47	222.55	221.34	221.59	10574.0
2023-01-06 05:00:00	MSFT	Stock	221.85	222.2	221.68	222.1	2545.0
2023-01-06 06:00:00	MSFT	Stock	221.99	222.0	221.71	221.8	3359.0
2023-01-06 07:00:00	MSFT	Stock	221.93	222.28	221.41	222.23	15585.0
2023-01-06 08:00:00	MSFT	Stock	221.71	225.99	221.4	225.25	285214.0
2023-01-06 09:00:00	MSFT	Stock	225.15	225.31	219.35	220.015	5382175.0
2023-01-06 10:00:00	MSFT	Stock	220.1	223.17	220.0	222.82	4932171.0
2023-01-06 11:00:00	MSFT	Stock	222.85	223.46	221.86	222.904	3361122.0
2023-01-06 12:00:00	MSFT	Stock	222.905	223.0699	221.9099	222.3381	2512839.0
2023-01-06 13:00:00	MSFT	Stock	222.32	224.12	222.29	224.04	2572110.0
2023-01-06 14:00:00	MSFT	Stock	224.04	225.72	223.95	225.44	3951277.0
2023-01-06 15:00:00	MSFT	Stock	225.45	225.7601	224.59	224.87	5675529.0
2023-01-06 16:00:00	MSFT	Stock	224.86	225.05	224.71	224.97	5487554.0
2023-01-06 17:00:00	MSFT	Stock	224.97	225.0	224.82	224.8301	6688.0
2023-01-06 18:00:00	MSFT	Stock	224.98	225.05	224.98	225.0	4280.0
2023-01-06 19:00:00	MSFT	Stock	225.05	225.05	224.9	225.04	7596.0
2023-01-06 04:00:00	NVDA	Stock	14.315	14.315	14.112	14.198	269900.0
2023-01-06 05:00:00	NVDA	Stock	14.207	14.207	14.177	14.207	5440.0
2023-01-06 06:00:00	NVDA	Stock	14.19	14.193	14.165	14.165	19770.0
2023-01-06 07:00:00	NVDA	Stock	14.17	14.217	14.14	14.217	176960.0
2023-01-06 08:00:00	NVDA	Stock	14.171	14.548	14.13	14.45	3075800.0
2023-01-06 09:00:00	NVDA	Stock	14.488	14.489	14.034	14.094	54716010.0
2023-01-06 10:00:00	NVDA	Stock	14.099	14.579	14.096	14.539	71782100.0
2023-01-06 11:00:00	NVDA	Stock	14.541	14.7667	14.487	14.703	44981370.0
2023-01-06 12:00:00	NVDA	Stock	14.705	14.721	14.635	14.662	27346750.0
2023-01-06 13:00:00	NVDA	Stock	14.663	14.811	14.65	14.796	25664810.0
2023-01-06 14:00:00	NVDA	Stock	14.799	14.968	14.792	14.943	33315620.0
2023-01-06 15:00:00	NVDA	Stock	14.943	15.01	14.8164	14.8594	54031530.0
2023-01-06 16:00:00	NVDA	Stock	14.857	14.866	14.825	14.859	30890480.0
2023-01-06 17:00:00	NVDA	Stock	14.84	14.847	14.833	14.84	96610.0
2023-01-06 18:00:00	NVDA	Stock	14.845	14.847	14.838	14.846	88890.0
2023-01-06 19:00:00	NVDA	Stock	14.847	14.859	14.836	14.859	90740.0
2023-01-06 04:00:00	AMZN	Stock	83.45	83.45	82.88	83.05	23737.0
2023-01-06 05:00:00	AMZN	Stock	83.0	83.1	82.91	82.92	10673.0

> showing 50 of 61,033 rows — these rows as CSV

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