PREVIEW / stock_1hour / 2023-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-02.parquet
  size:    1.4 MB
  rows:    61,445
  symbols: 1,504

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-08-02 04:00:00	AAPL	Stock	193.56	194.09	193.12	193.49	50965.0
2023-08-02 05:00:00	AAPL	Stock	193.52	194.1	193.5	193.82	21967.0
2023-08-02 06:00:00	AAPL	Stock	193.9	194.75	193.76	194.55	70394.0
2023-08-02 07:00:00	AAPL	Stock	194.6	194.95	194.53	194.74	80618.0
2023-08-02 08:00:00	AAPL	Stock	194.7899	194.98	193.825	194.69	175824.0
2023-08-02 09:00:00	AAPL	Stock	194.64	195.18	193.37	194.0	5250055.0
2023-08-02 10:00:00	AAPL	Stock	194.0	194.27	192.75	192.8001	5204924.0
2023-08-02 11:00:00	AAPL	Stock	192.8	193.2712	192.52	192.58	4237603.0
2023-08-02 12:00:00	AAPL	Stock	192.588	192.84	191.8507	192.84	4524622.0
2023-08-02 13:00:00	AAPL	Stock	192.83	193.25	192.69	192.8301	2592191.0
2023-08-02 14:00:00	AAPL	Stock	192.84	193.26	192.59	192.77	2512772.0
2023-08-02 15:00:00	AAPL	Stock	192.765	192.98	192.22	192.59	7043481.0
2023-08-02 16:00:00	AAPL	Stock	192.59	192.68	192.06	192.32	7531235.0
2023-08-02 17:00:00	AAPL	Stock	192.32	192.58	192.03	192.25	537276.0
2023-08-02 18:00:00	AAPL	Stock	192.28	192.9	192.28	192.88	73195.0
2023-08-02 19:00:00	AAPL	Stock	192.9	192.97	192.66	192.81	58334.0
2023-08-02 04:00:00	MSFT	Stock	332.0	332.35	331.0	331.7	12511.0
2023-08-02 05:00:00	MSFT	Stock	332.05	332.65	332.0	332.37	5071.0
2023-08-02 06:00:00	MSFT	Stock	332.47	333.9	332.47	333.9	10618.0
2023-08-02 07:00:00	MSFT	Stock	333.85	334.41	333.65	333.7	19195.0
2023-08-02 08:00:00	MSFT	Stock	333.73	334.4	332.98	333.33	49115.0
2023-08-02 09:00:00	MSFT	Stock	333.3	334.21	331.0901	331.45	2280365.0
2023-08-02 10:00:00	MSFT	Stock	331.45	331.67	328.92	329.17	3063507.0
2023-08-02 11:00:00	MSFT	Stock	329.14	330.47	328.05	328.05	2292964.0
2023-08-02 12:00:00	MSFT	Stock	328.045	328.418	326.3551	328.12	2705775.0
2023-08-02 13:00:00	MSFT	Stock	328.11	328.69	327.56	328.06	1309768.0
2023-08-02 14:00:00	MSFT	Stock	328.1	329.05	327.8647	328.42	1206836.0
2023-08-02 15:00:00	MSFT	Stock	328.44	328.5664	326.62	327.51	3476552.0
2023-08-02 16:00:00	MSFT	Stock	327.51	328.8542	326.75	326.8	3637242.0
2023-08-02 17:00:00	MSFT	Stock	326.75	327.5	326.2	327.0	231802.0
2023-08-02 18:00:00	MSFT	Stock	327.2484	328.25	327.0	328.1	21005.0
2023-08-02 19:00:00	MSFT	Stock	328.25	328.5	328.03	328.5	11209.0
2023-08-02 04:00:00	NVDA	Stock	45.567	46.048	45.333	45.551	266440.0
2023-08-02 05:00:00	NVDA	Stock	45.551	45.67	45.402	45.65	277620.0
2023-08-02 06:00:00	NVDA	Stock	45.64	45.826	45.5	45.752	222810.0
2023-08-02 07:00:00	NVDA	Stock	45.75	46.041	45.75	45.825	613360.0
2023-08-02 08:00:00	NVDA	Stock	45.799	46.03	45.5287	45.801	1472180.0
2023-08-02 09:00:00	NVDA	Stock	45.8	45.93	45.118	45.2745	50098270.0
2023-08-02 10:00:00	NVDA	Stock	45.281	45.29	44.759	44.8046	57545560.0
2023-08-02 11:00:00	NVDA	Stock	44.8	44.81	44.004	44.007	61983250.0
2023-08-02 12:00:00	NVDA	Stock	44.004	44.011	43.387	43.974	83386130.0
2023-08-02 13:00:00	NVDA	Stock	43.974	44.333	43.944	44.064	43243930.0
2023-08-02 14:00:00	NVDA	Stock	44.057	44.46	44.051	44.42	35924470.0
2023-08-02 15:00:00	NVDA	Stock	44.424	44.48	44.0041	44.263	50925550.0
2023-08-02 16:00:00	NVDA	Stock	44.281	44.365	43.95	43.963	19709730.0
2023-08-02 17:00:00	NVDA	Stock	43.996	44.269	43.97	44.08	1100060.0
2023-08-02 18:00:00	NVDA	Stock	44.1	44.401	44.1	44.375	587920.0
2023-08-02 19:00:00	NVDA	Stock	44.393	44.437	44.294	44.296	381350.0
2023-08-02 04:00:00	AMZN	Stock	130.72	130.9	129.0	130.16	38929.0
2023-08-02 05:00:00	AMZN	Stock	130.16	130.5	130.0	130.4	21636.0

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

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