PREVIEW / stock_1hour / 2022-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-31.parquet
  size:    1.4 MB
  rows:    64,806
  symbols: 2,414

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
2022-05-31 04:00:00	AAPL	Stock	150.0	151.0	148.89	150.01	63974.0
2022-05-31 05:00:00	AAPL	Stock	150.0	150.0	148.99	149.05	45883.0
2022-05-31 06:00:00	AAPL	Stock	149.01	149.37	148.73	149.23	35437.0
2022-05-31 07:00:00	AAPL	Stock	149.25	149.78	149.18	149.5	97753.0
2022-05-31 08:00:00	AAPL	Stock	149.44	150.69	148.59	148.6898	597543.0
2022-05-31 09:00:00	AAPL	Stock	148.65	150.26	147.58	147.881	11153590.0
2022-05-31 10:00:00	AAPL	Stock	147.875	148.79	146.84	148.519	10180480.0
2022-05-31 11:00:00	AAPL	Stock	148.51	150.2401	147.855	149.973	8428001.0
2022-05-31 12:00:00	AAPL	Stock	149.9796	150.58	149.23	149.9699	9449841.0
2022-05-31 13:00:00	AAPL	Stock	149.96	150.66	149.36	150.235	7258362.0
2022-05-31 14:00:00	AAPL	Stock	150.23	150.49	148.765	149.095	6164757.0
2022-05-31 15:00:00	AAPL	Stock	149.0901	150.51	148.73	148.84	12235298.0
2022-05-31 16:00:00	AAPL	Stock	148.76	149.28	148.5	148.9102	21771828.0
2022-05-31 17:00:00	AAPL	Stock	148.9548	148.99	148.85	148.93	28955.0
2022-05-31 18:00:00	AAPL	Stock	148.95	149.59	148.93	149.33	48590.0
2022-05-31 19:00:00	AAPL	Stock	149.33	149.6	149.25	149.5	50519.0
2022-05-31 04:00:00	MSFT	Stock	273.64	274.35	272.21	274.02	6160.0
2022-05-31 05:00:00	MSFT	Stock	273.53	273.53	271.87	272.25	5149.0
2022-05-31 06:00:00	MSFT	Stock	271.97	272.7	271.68	272.6	9644.0
2022-05-31 07:00:00	MSFT	Stock	272.7	273.08	272.25	272.6	25899.0
2022-05-31 08:00:00	MSFT	Stock	272.65	275.41	271.01	271.5	51343.0
2022-05-31 09:00:00	MSFT	Stock	271.3001	273.15	269.315	270.785	3038946.0
2022-05-31 10:00:00	MSFT	Stock	270.76	271.41	268.93	271.14	2394478.0
2022-05-31 11:00:00	MSFT	Stock	271.1525	273.42	270.18	272.99	1908650.0
2022-05-31 12:00:00	MSFT	Stock	272.97	273.9	272.02	273.3268	1636071.0
2022-05-31 13:00:00	MSFT	Stock	273.3299	273.5	271.61	273.27	1719340.0
2022-05-31 14:00:00	MSFT	Stock	273.25	273.8	271.1211	271.57	1552370.0
2022-05-31 15:00:00	MSFT	Stock	271.53	274.77	270.98	271.98	4461801.0
2022-05-31 16:00:00	MSFT	Stock	271.87	272.8	270.95	272.02	9343008.0
2022-05-31 17:00:00	MSFT	Stock	272.1	272.8	272.09	272.8	15557.0
2022-05-31 18:00:00	MSFT	Stock	272.88	273.2	272.61	273.2	5732.0
2022-05-31 19:00:00	MSFT	Stock	273.0	273.4	273.0	273.4	2734.0
2022-05-31 04:00:00	NVDA	Stock	19.05	19.2	18.799	18.963	329970.0
2022-05-31 05:00:00	NVDA	Stock	18.972	18.972	18.705	18.74	386860.0
2022-05-31 06:00:00	NVDA	Stock	18.733	18.838	18.695	18.8	248340.0
2022-05-31 07:00:00	NVDA	Stock	18.817	18.885	18.765	18.84	832270.0
2022-05-31 08:00:00	NVDA	Stock	18.843	19.0	18.674	18.716	2268950.0
2022-05-31 09:00:00	NVDA	Stock	18.72	19.2	18.35	18.568	80706430.0
2022-05-31 10:00:00	NVDA	Stock	18.568	18.994	18.358	18.829	91207510.0
2022-05-31 11:00:00	NVDA	Stock	18.825	19.0175	18.629	18.953	65391370.0
2022-05-31 12:00:00	NVDA	Stock	18.951	19.0742	18.7825	18.966	53219580.0
2022-05-31 13:00:00	NVDA	Stock	18.9645	18.984	18.769	18.9271	39646050.0
2022-05-31 14:00:00	NVDA	Stock	18.926	18.945	18.485	18.564	51335140.0
2022-05-31 15:00:00	NVDA	Stock	18.5592	18.844	18.501	18.671	65234730.0
2022-05-31 16:00:00	NVDA	Stock	18.668	18.685	18.603	18.637	69449320.0
2022-05-31 17:00:00	NVDA	Stock	18.645	18.655	18.6331	18.655	111420.0
2022-05-31 18:00:00	NVDA	Stock	18.658	18.704	18.644	18.685	381900.0
2022-05-31 19:00:00	NVDA	Stock	18.68	18.798	18.68	18.798	428770.0
2022-05-31 04:00:00	AMZN	Stock	114.75	116.0	114.75	115.855	30140.0
2022-05-31 05:00:00	AMZN	Stock	115.5	115.5	115.1465	115.1465	9000.0

> showing 50 of 64,806 rows — these rows as CSV

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