PREVIEW / stock_1hour / 2022-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-22.parquet
  size:    1.4 MB
  rows:    62,978
  symbols: 2,451

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-04-22 04:00:00	AAPL	Stock	166.52	166.84	166.01	166.01	22288.0
2022-04-22 05:00:00	AAPL	Stock	166.1	166.35	165.54	165.54	17439.0
2022-04-22 06:00:00	AAPL	Stock	165.71	166.01	165.61	165.9	11558.0
2022-04-22 07:00:00	AAPL	Stock	166.0	167.24	165.93	166.96	80488.0
2022-04-22 08:00:00	AAPL	Stock	166.1801	167.6	165.89	166.66	554284.0
2022-04-22 09:00:00	AAPL	Stock	166.66	167.8699	165.81	166.33	8071610.0
2022-04-22 10:00:00	AAPL	Stock	166.34	167.05	165.24	165.9258	9052512.0
2022-04-22 11:00:00	AAPL	Stock	165.925	166.56	164.51	164.53	6905226.0
2022-04-22 12:00:00	AAPL	Stock	164.52	165.335	164.14	164.7132	6641677.0
2022-04-22 13:00:00	AAPL	Stock	164.71	164.76	163.72	163.7216	5595086.0
2022-04-22 14:00:00	AAPL	Stock	163.72	164.27	162.56	162.9699	7419579.0
2022-04-22 15:00:00	AAPL	Stock	162.9641	164.16	161.5	161.83	16369278.0
2022-04-22 16:00:00	AAPL	Stock	161.82	163.62	161.2	161.5	9682859.0
2022-04-22 17:00:00	AAPL	Stock	161.5	161.73	161.31	161.32	71181.0
2022-04-22 18:00:00	AAPL	Stock	161.3001	161.39	161.11	161.32	50414.0
2022-04-22 19:00:00	AAPL	Stock	161.3	161.52	161.16	161.5	48052.0
2022-04-22 04:00:00	MSFT	Stock	280.84	281.0	280.05	280.16	3940.0
2022-04-22 05:00:00	MSFT	Stock	280.23	280.67	279.75	279.99	2891.0
2022-04-22 06:00:00	MSFT	Stock	279.95	281.0	279.23	280.23	9931.0
2022-04-22 07:00:00	MSFT	Stock	280.3	281.91	280.2	281.5	14297.0
2022-04-22 08:00:00	MSFT	Stock	281.3	282.38	280.3	281.45	34603.0
2022-04-22 09:00:00	MSFT	Stock	281.2912	283.2	279.72	280.47	2283669.0
2022-04-22 10:00:00	MSFT	Stock	280.55	282.3	278.9667	279.67	2203590.0
2022-04-22 11:00:00	MSFT	Stock	279.65	280.37	276.03	277.28	1795999.0
2022-04-22 12:00:00	MSFT	Stock	277.285	278.365	276.84	277.16	1418646.0
2022-04-22 13:00:00	MSFT	Stock	277.14	277.78	275.84	275.8506	1769398.0
2022-04-22 14:00:00	MSFT	Stock	275.85	277.05	275.01	275.6199	1651987.0
2022-04-22 15:00:00	MSFT	Stock	275.62	277.74	273.38	274.03	4911377.0
2022-04-22 16:00:00	MSFT	Stock	274.03	274.03	272.82	273.0	4868434.0
2022-04-22 17:00:00	MSFT	Stock	273.28	273.5999	273.05	273.05	22442.0
2022-04-22 18:00:00	MSFT	Stock	273.08	273.15	272.85	273.0	19327.0
2022-04-22 19:00:00	MSFT	Stock	273.0	273.28	272.8	272.99	5888.0
2022-04-22 04:00:00	NVDA	Stock	20.3	20.38	20.178	20.265	363620.0
2022-04-22 05:00:00	NVDA	Stock	20.264	20.3	20.099	20.14	94660.0
2022-04-22 06:00:00	NVDA	Stock	20.122	20.17	20.091	20.143	64130.0
2022-04-22 07:00:00	NVDA	Stock	20.152	20.34	20.15	20.3	363950.0
2022-04-22 08:00:00	NVDA	Stock	20.1698	20.349	20.1333	20.221	1433820.0
2022-04-22 09:00:00	NVDA	Stock	20.2	20.486	19.728	20.16	81726440.0
2022-04-22 10:00:00	NVDA	Stock	20.172	20.448	19.865	20.0661	87360230.0
2022-04-22 11:00:00	NVDA	Stock	20.063	20.34	19.866	19.885	57267430.0
2022-04-22 12:00:00	NVDA	Stock	19.8851	19.926	19.7359	19.7635	40095540.0
2022-04-22 13:00:00	NVDA	Stock	19.7595	19.839	19.616	19.6315	38160000.0
2022-04-22 14:00:00	NVDA	Stock	19.63	19.796	19.5145	19.559	40769010.0
2022-04-22 15:00:00	NVDA	Stock	19.563	19.8085	19.5	19.506	75572860.0
2022-04-22 16:00:00	NVDA	Stock	19.515	19.702	19.41	19.455	24255340.0
2022-04-22 17:00:00	NVDA	Stock	19.454	19.468	19.413	19.419	387780.0
2022-04-22 18:00:00	NVDA	Stock	19.424	19.43	19.392	19.392	266710.0
2022-04-22 19:00:00	NVDA	Stock	19.389	19.4	19.297	19.35	486500.0
2022-04-22 05:00:00	AMZN	Stock	148.852	148.852	148.2965	148.2965	4000.0
2022-04-22 06:00:00	AMZN	Stock	148.1525	148.1525	148.1525	148.1525	2820.0

> showing 50 of 62,978 rows — these rows as CSV

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