PREVIEW / stock_1hour / 2023-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-02.parquet
  size:    1.4 MB
  rows:    60,980
  symbols: 1,634

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-02 04:00:00	AAPL	Stock	180.68	181.02	180.52	181.02	31898.0
2023-06-02 05:00:00	AAPL	Stock	181.0	181.38	180.95	181.25	23515.0
2023-06-02 06:00:00	AAPL	Stock	181.25	181.35	181.01	181.09	34461.0
2023-06-02 07:00:00	AAPL	Stock	181.01	181.45	181.0	181.31	100720.0
2023-06-02 08:00:00	AAPL	Stock	181.04	181.45	180.52	180.96	442596.0
2023-06-02 09:00:00	AAPL	Stock	180.9	181.78	179.69	179.81	9603474.0
2023-06-02 10:00:00	AAPL	Stock	179.81	180.64	179.26	180.52	8168744.0
2023-06-02 11:00:00	AAPL	Stock	180.53	180.99	180.14	180.9704	5152976.0
2023-06-02 12:00:00	AAPL	Stock	180.98	181.0499	180.47	180.85	4216504.0
2023-06-02 13:00:00	AAPL	Stock	180.86	180.88	180.3	180.505	3826865.0
2023-06-02 14:00:00	AAPL	Stock	180.51	180.83	180.06	180.63	4303117.0
2023-06-02 15:00:00	AAPL	Stock	180.625	181.1	180.59	180.95	8640553.0
2023-06-02 16:00:00	AAPL	Stock	180.95	181.09	180.83	181.06	5923891.0
2023-06-02 17:00:00	AAPL	Stock	181.06	181.11	180.94	180.98	43979.0
2023-06-02 18:00:00	AAPL	Stock	180.98	181.06	180.95	181.06	17213.0
2023-06-02 19:00:00	AAPL	Stock	181.01	181.11	180.96	181.11	18719.0
2023-06-02 04:00:00	MSFT	Stock	334.3	334.3	333.01	333.54	7098.0
2023-06-02 05:00:00	MSFT	Stock	333.8	334.25	333.33	333.41	5555.0
2023-06-02 06:00:00	MSFT	Stock	333.35	333.62	332.91	333.25	4503.0
2023-06-02 07:00:00	MSFT	Stock	333.19	333.85	333.19	333.58	15205.0
2023-06-02 08:00:00	MSFT	Stock	333.17	335.0	330.91	331.5681	82301.0
2023-06-02 09:00:00	MSFT	Stock	331.78	337.5	331.78	333.25	3528416.0
2023-06-02 10:00:00	MSFT	Stock	333.3	334.98	332.55	334.785	2442623.0
2023-06-02 11:00:00	MSFT	Stock	334.785	335.25	334.07	334.885	1558772.0
2023-06-02 12:00:00	MSFT	Stock	334.8827	334.98	333.48	334.49	1464910.0
2023-06-02 13:00:00	MSFT	Stock	334.52	334.7	333.84	334.64	1128919.0
2023-06-02 14:00:00	MSFT	Stock	334.66	336.7436	334.17	336.1305	1856848.0
2023-06-02 15:00:00	MSFT	Stock	336.15	336.76	335.1	335.34	2704593.0
2023-06-02 16:00:00	MSFT	Stock	335.4	335.75	335.07	335.47	3016416.0
2023-06-02 17:00:00	MSFT	Stock	335.47	335.4857	335.06	335.3781	7298.0
2023-06-02 18:00:00	MSFT	Stock	335.4	335.4	335.18	335.18	3717.0
2023-06-02 19:00:00	MSFT	Stock	335.3	335.3	335.1	335.1	1353.0
2023-06-02 04:00:00	NVDA	Stock	40.022	40.395	40.022	40.378	257710.0
2023-06-02 05:00:00	NVDA	Stock	40.359	40.489	40.326	40.43	180530.0
2023-06-02 06:00:00	NVDA	Stock	40.43	40.431	40.261	40.261	153790.0
2023-06-02 07:00:00	NVDA	Stock	40.273	40.5	40.256	40.425	1028750.0
2023-06-02 08:00:00	NVDA	Stock	40.3	40.5	40.0234	40.075	3863630.0
2023-06-02 09:00:00	NVDA	Stock	40.078	40.5	39.155	39.277	83199410.0
2023-06-02 10:00:00	NVDA	Stock	39.279	39.865	39.178	39.823	70322820.0
2023-06-02 11:00:00	NVDA	Stock	39.829	39.92	39.511	39.614	40668180.0
2023-06-02 12:00:00	NVDA	Stock	39.613	39.672	39.363	39.366	31103840.0
2023-06-02 13:00:00	NVDA	Stock	39.3712	39.533	39.291	39.3447	30699430.0
2023-06-02 14:00:00	NVDA	Stock	39.3485	39.366	39.058	39.249	43403050.0
2023-06-02 15:00:00	NVDA	Stock	39.25	39.42	39.198	39.324	42716610.0
2023-06-02 16:00:00	NVDA	Stock	39.327	39.38	39.228	39.274	21590300.0
2023-06-02 17:00:00	NVDA	Stock	39.269	39.288	39.232	39.249	182280.0
2023-06-02 18:00:00	NVDA	Stock	39.229	39.2688	39.2	39.2688	309170.0
2023-06-02 19:00:00	NVDA	Stock	39.275	39.288	39.218	39.225	433970.0
2023-06-02 04:00:00	AMZN	Stock	123.2	123.72	123.2	123.72	15177.0
2023-06-02 05:00:00	AMZN	Stock	123.72	123.96	123.69	123.69	9622.0

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

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