PREVIEW / stock_1hour / 2023-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-06.parquet
  size:    1.3 MB
  rows:    59,869
  symbols: 1,603

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-06-06 04:00:00	AAPL	Stock	179.05	179.51	178.49	178.87	73423.0
2023-06-06 05:00:00	AAPL	Stock	178.86	178.9	178.17	178.22	45874.0
2023-06-06 06:00:00	AAPL	Stock	178.27	178.53	178.2	178.45	28922.0
2023-06-06 07:00:00	AAPL	Stock	178.45	179.0	178.33	178.77	113400.0
2023-06-06 08:00:00	AAPL	Stock	178.4393	180.21	178.39	179.08	224478.0
2023-06-06 09:00:00	AAPL	Stock	179.1	180.4	177.58	177.88	9923018.0
2023-06-06 10:00:00	AAPL	Stock	177.875	179.2123	177.43	178.52	10289452.0
2023-06-06 11:00:00	AAPL	Stock	178.52	178.86	177.665	178.83	6650031.0
2023-06-06 12:00:00	AAPL	Stock	178.8201	179.11	178.04	178.091	5156361.0
2023-06-06 13:00:00	AAPL	Stock	178.11	179.28	178.03	178.83	5118263.0
2023-06-06 14:00:00	AAPL	Stock	178.84	179.48	178.71	179.4	4024733.0
2023-06-06 15:00:00	AAPL	Stock	179.39	179.7	179.05	179.16	6646384.0
2023-06-06 16:00:00	AAPL	Stock	179.15	179.3	178.93	179.04	4312213.0
2023-06-06 17:00:00	AAPL	Stock	179.04	179.14	179.0	179.1	29742.0
2023-06-06 18:00:00	AAPL	Stock	179.1	179.1	178.89	178.9	28539.0
2023-06-06 19:00:00	AAPL	Stock	178.92	179.05	178.9	179.0	21787.0
2023-06-06 04:00:00	MSFT	Stock	335.58	336.3	335.58	335.7	1339.0
2023-06-06 05:00:00	MSFT	Stock	335.9	336.1	335.9	336.1	421.0
2023-06-06 06:00:00	MSFT	Stock	335.76	335.77	335.65	335.77	351.0
2023-06-06 07:00:00	MSFT	Stock	335.99	336.0	335.62	336.0	7096.0
2023-06-06 08:00:00	MSFT	Stock	335.95	336.41	335.62	336.22	13267.0
2023-06-06 09:00:00	MSFT	Stock	336.27	336.5	332.77	333.755	2171807.0
2023-06-06 10:00:00	MSFT	Stock	333.765	334.88	333.25	333.85	2348805.0
2023-06-06 11:00:00	MSFT	Stock	333.89	334.5	332.17	334.4263	2018158.0
2023-06-06 12:00:00	MSFT	Stock	334.44	334.63	332.59	332.73	1236095.0
2023-06-06 13:00:00	MSFT	Stock	332.74	333.84	332.46	332.98	1222956.0
2023-06-06 14:00:00	MSFT	Stock	333.0	333.98	332.88	333.88	1170410.0
2023-06-06 15:00:00	MSFT	Stock	333.9	334.35	333.32	333.67	1982541.0
2023-06-06 16:00:00	MSFT	Stock	333.66	333.9	333.04	333.53	2455782.0
2023-06-06 17:00:00	MSFT	Stock	333.45	333.71	333.45	333.5214	3064.0
2023-06-06 18:00:00	MSFT	Stock	333.24	333.68	333.05	333.13	4977.0
2023-06-06 19:00:00	MSFT	Stock	333.13	333.5	333.08	333.33	8077.0
2023-06-06 04:00:00	NVDA	Stock	39.148	39.148	38.933	38.95	36220.0
2023-06-06 05:00:00	NVDA	Stock	38.965	39.02	38.96	39.0	56070.0
2023-06-06 06:00:00	NVDA	Stock	38.973	39.05	38.942	39.05	39530.0
2023-06-06 07:00:00	NVDA	Stock	39.013	39.075	38.96	39.038	315850.0
2023-06-06 08:00:00	NVDA	Stock	39.063	39.171	38.933	38.975	1155240.0
2023-06-06 09:00:00	NVDA	Stock	38.975	39.16	38.635	39.0459	43215650.0
2023-06-06 10:00:00	NVDA	Stock	39.0405	39.0574	38.769	38.9688	39983990.0
2023-06-06 11:00:00	NVDA	Stock	38.968	39.09	38.778	38.8551	31161860.0
2023-06-06 12:00:00	NVDA	Stock	38.856	38.92	38.148	38.174	46523840.0
2023-06-06 13:00:00	NVDA	Stock	38.1705	38.645	38.15	38.493	45730350.0
2023-06-06 14:00:00	NVDA	Stock	38.496	38.682	38.403	38.665	27318420.0
2023-06-06 15:00:00	NVDA	Stock	38.669	38.872	38.495	38.654	48923680.0
2023-06-06 16:00:00	NVDA	Stock	38.654	38.6887	38.637	38.6673	11744100.0
2023-06-06 17:00:00	NVDA	Stock	38.672	38.795	38.67	38.783	312130.0
2023-06-06 18:00:00	NVDA	Stock	38.765	38.765	38.6752	38.71	162740.0
2023-06-06 19:00:00	NVDA	Stock	38.704	38.797	38.7	38.792	301140.0
2023-06-06 04:00:00	AMZN	Stock	125.26	125.71	125.26	125.39	12070.0
2023-06-06 05:00:00	AMZN	Stock	125.58	125.6	125.51	125.56	1762.0

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

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