PREVIEW / stock_1hour / 2023-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-27.parquet
  size:    1.3 MB
  rows:    59,406
  symbols: 1,656

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-04-27 04:00:00	AAPL	Stock	164.12	164.87	164.12	164.35	25005.0
2023-04-27 05:00:00	AAPL	Stock	164.56	164.56	164.35	164.48	4735.0
2023-04-27 06:00:00	AAPL	Stock	164.32	164.93	164.29	164.64	8046.0
2023-04-27 07:00:00	AAPL	Stock	164.62	165.07	164.54	165.05	70155.0
2023-04-27 08:00:00	AAPL	Stock	164.58	165.28	163.54	164.99	322807.0
2023-04-27 09:00:00	AAPL	Stock	165.0	166.149	164.75	165.42	6661889.0
2023-04-27 10:00:00	AAPL	Stock	165.435	166.62	165.35	166.2242	6541713.0
2023-04-27 11:00:00	AAPL	Stock	166.2225	166.905	166.12	166.6886	4916395.0
2023-04-27 12:00:00	AAPL	Stock	166.685	167.09	166.68	167.01	3792278.0
2023-04-27 13:00:00	AAPL	Stock	167.01	167.46	166.895	167.25	4003263.0
2023-04-27 14:00:00	AAPL	Stock	167.25	167.95	167.14	167.8701	4749866.0
2023-04-27 15:00:00	AAPL	Stock	167.875	168.56	167.83	168.4	12559383.0
2023-04-27 16:00:00	AAPL	Stock	168.41	169.054	167.5955	167.87	12017963.0
2023-04-27 17:00:00	AAPL	Stock	167.89	168.18	167.5	167.65	126007.0
2023-04-27 18:00:00	AAPL	Stock	167.7	167.98	167.36	167.67	149752.0
2023-04-27 19:00:00	AAPL	Stock	167.74	167.94	167.67	167.94	31246.0
2023-04-27 04:00:00	MSFT	Stock	296.45	296.6	295.47	295.78	6712.0
2023-04-27 05:00:00	MSFT	Stock	295.71	295.8	294.35	294.61	12039.0
2023-04-27 06:00:00	MSFT	Stock	294.6	295.0	294.6	295.0	5027.0
2023-04-27 07:00:00	MSFT	Stock	295.0	295.8	294.85	295.19	16803.0
2023-04-27 08:00:00	MSFT	Stock	294.86	296.36	294.6	295.1	83283.0
2023-04-27 09:00:00	MSFT	Stock	295.05	301.4	294.645	300.325	6496469.0
2023-04-27 10:00:00	MSFT	Stock	300.32	303.16	300.18	302.6108	6669933.0
2023-04-27 11:00:00	MSFT	Stock	302.62	303.75	302.01	302.715	3618444.0
2023-04-27 12:00:00	MSFT	Stock	302.72	303.07	302.41	302.648	2354389.0
2023-04-27 13:00:00	MSFT	Stock	302.65	303.52	302.1	303.28	2250549.0
2023-04-27 14:00:00	MSFT	Stock	303.29	304.09	303.22	304.05	2617347.0
2023-04-27 15:00:00	MSFT	Stock	304.05	305.2	303.94	304.68	5934922.0
2023-04-27 16:00:00	MSFT	Stock	304.83	305.66	303.8	304.74	4677179.0
2023-04-27 17:00:00	MSFT	Stock	304.73	304.85	303.7	303.74	48129.0
2023-04-27 18:00:00	MSFT	Stock	303.8	305.0	303.8	304.5	52034.0
2023-04-27 19:00:00	MSFT	Stock	304.5	305.0	304.25	304.64	28590.0
2023-04-27 04:00:00	NVDA	Stock	27.259	27.272	27.2	27.241	52530.0
2023-04-27 05:00:00	NVDA	Stock	27.266	27.4	27.266	27.333	278850.0
2023-04-27 06:00:00	NVDA	Stock	27.343	27.343	27.301	27.325	80160.0
2023-04-27 07:00:00	NVDA	Stock	27.312	27.332	27.27	27.307	258070.0
2023-04-27 08:00:00	NVDA	Stock	27.309	27.388	27.21	27.31	1340930.0
2023-04-27 09:00:00	NVDA	Stock	27.302	27.495	26.663	26.6895	48466360.0
2023-04-27 10:00:00	NVDA	Stock	26.6895	26.902	26.625	26.8026	59843090.0
2023-04-27 11:00:00	NVDA	Stock	26.8025	26.971	26.717	26.809	35491740.0
2023-04-27 12:00:00	NVDA	Stock	26.807	27.015	26.74	26.9955	33465110.0
2023-04-27 13:00:00	NVDA	Stock	26.996	27.15	26.974	27.112	30934530.0
2023-04-27 14:00:00	NVDA	Stock	27.113	27.167	27.043	27.1382	27713100.0
2023-04-27 15:00:00	NVDA	Stock	27.136	27.264	27.121	27.222	36487120.0
2023-04-27 16:00:00	NVDA	Stock	27.222	27.348	27.15	27.172	21514940.0
2023-04-27 17:00:00	NVDA	Stock	27.19	27.238	27.145	27.177	444330.0
2023-04-27 18:00:00	NVDA	Stock	27.188	27.2	27.0	27.05	897270.0
2023-04-27 19:00:00	NVDA	Stock	27.043	27.166	27.04	27.135	238330.0
2023-04-27 04:00:00	AMZN	Stock	106.5	107.39	106.5	107.27	18661.0
2023-04-27 05:00:00	AMZN	Stock	107.28	107.97	107.26	107.7	30758.0

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

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