PREVIEW / stock_1hour / 2023-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-01.parquet
  size:    1.4 MB
  rows:    60,768
  symbols: 1,659

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-05-01 04:00:00	AAPL	Stock	168.4	169.8	168.26	169.0	21769.0
2023-05-01 05:00:00	AAPL	Stock	169.1	169.37	168.97	168.97	12461.0
2023-05-01 06:00:00	AAPL	Stock	168.9	169.09	168.77	168.85	3494.0
2023-05-01 07:00:00	AAPL	Stock	168.95	169.3	168.93	168.94	57020.0
2023-05-01 08:00:00	AAPL	Stock	169.15	169.49	168.88	169.49	148460.0
2023-05-01 09:00:00	AAPL	Stock	169.46	170.29	169.0	169.48	7697369.0
2023-05-01 10:00:00	AAPL	Stock	169.47	169.67	168.64	169.5199	5968302.0
2023-05-01 11:00:00	AAPL	Stock	169.515	169.83	168.93	169.65	4520809.0
2023-05-01 12:00:00	AAPL	Stock	169.6304	170.42	169.5801	170.35	4631121.0
2023-05-01 13:00:00	AAPL	Stock	170.3577	170.45	170.0701	170.1499	3785588.0
2023-05-01 14:00:00	AAPL	Stock	170.145	170.178	169.2	169.5343	4208035.0
2023-05-01 15:00:00	AAPL	Stock	169.53	169.9	169.25	169.56	6262389.0
2023-05-01 16:00:00	AAPL	Stock	169.55	169.74	169.5	169.52	4165510.0
2023-05-01 17:00:00	AAPL	Stock	169.52	169.57	169.39	169.39	27085.0
2023-05-01 18:00:00	AAPL	Stock	169.39	169.57	169.34	169.4	14271.0
2023-05-01 19:00:00	AAPL	Stock	169.45	169.53	169.39	169.4	20874.0
2023-05-01 04:00:00	MSFT	Stock	307.5	307.5	306.99	307.08	2432.0
2023-05-01 05:00:00	MSFT	Stock	307.01	307.49	306.91	307.26	2599.0
2023-05-01 06:00:00	MSFT	Stock	307.2	307.35	307.0	307.0	951.0
2023-05-01 07:00:00	MSFT	Stock	307.0	307.11	306.47	306.5	3485.0
2023-05-01 08:00:00	MSFT	Stock	306.9	307.8	306.05	306.19	33876.0
2023-05-01 09:00:00	MSFT	Stock	306.23	308.6	305.9	307.6929	2343674.0
2023-05-01 10:00:00	MSFT	Stock	307.64	307.64	305.77	307.13	2621630.0
2023-05-01 11:00:00	MSFT	Stock	307.13	307.5527	306.07	307.05	2143202.0
2023-05-01 12:00:00	MSFT	Stock	307.03	308.01	306.85	307.88	1680014.0
2023-05-01 13:00:00	MSFT	Stock	307.88	308.05	307.11	307.2329	1210659.0
2023-05-01 14:00:00	MSFT	Stock	307.22	307.47	305.79	306.34	1360849.0
2023-05-01 15:00:00	MSFT	Stock	306.33	306.39	305.15	305.55	2525245.0
2023-05-01 16:00:00	MSFT	Stock	305.56	305.94	305.31	305.44	2529506.0
2023-05-01 17:00:00	MSFT	Stock	305.48	305.51	305.18	305.21	7150.0
2023-05-01 18:00:00	MSFT	Stock	305.21	305.55	305.1385	305.38	6719.0
2023-05-01 19:00:00	MSFT	Stock	305.55	305.78	305.3	305.48	6512.0
2023-05-01 04:00:00	NVDA	Stock	27.734	27.75	27.709	27.709	12020.0
2023-05-01 05:00:00	NVDA	Stock	27.742	27.768	27.73	27.748	19210.0
2023-05-01 06:00:00	NVDA	Stock	27.749	27.78	27.745	27.78	22590.0
2023-05-01 07:00:00	NVDA	Stock	27.77	27.895	27.765	27.84	216620.0
2023-05-01 08:00:00	NVDA	Stock	27.787	27.9	27.773	27.87	710650.0
2023-05-01 09:00:00	NVDA	Stock	27.859	28.25	27.78	28.237	56563080.0
2023-05-01 10:00:00	NVDA	Stock	28.222	28.633	28.109	28.629	88067960.0
2023-05-01 11:00:00	NVDA	Stock	28.63	28.68	28.4261	28.635	70117340.0
2023-05-01 12:00:00	NVDA	Stock	28.638	28.774	28.585	28.7737	47790900.0
2023-05-01 13:00:00	NVDA	Stock	28.77	28.934	28.757	28.9241	56722730.0
2023-05-01 14:00:00	NVDA	Stock	28.926	29.0584	28.755	28.9342	64440130.0
2023-05-01 15:00:00	NVDA	Stock	28.935	28.996	28.823	28.905	62092160.0
2023-05-01 16:00:00	NVDA	Stock	28.91	28.95	28.861	28.861	12758700.0
2023-05-01 17:00:00	NVDA	Stock	28.87	28.9	28.796	28.82	583990.0
2023-05-01 18:00:00	NVDA	Stock	28.809	28.869	28.805	28.84	247210.0
2023-05-01 19:00:00	NVDA	Stock	28.848	28.85	28.76	28.76	431130.0
2023-05-01 04:00:00	AMZN	Stock	108.0	108.0	104.9	105.12	10404.0
2023-05-01 05:00:00	AMZN	Stock	105.19	105.43	105.19	105.23	6946.0

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

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