PREVIEW / stock_1hour / 2022-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-03.parquet
  size:    1.4 MB
  rows:    64,206
  symbols: 2,335

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-08-03 04:00:00	AAPL	Stock	160.28	160.43	159.84	160.32	25840.0
2022-08-03 05:00:00	AAPL	Stock	160.28	161.14	160.24	160.93	25046.0
2022-08-03 06:00:00	AAPL	Stock	160.99	161.0	160.73	160.8	8389.0
2022-08-03 07:00:00	AAPL	Stock	160.84	161.31	160.84	161.21	54576.0
2022-08-03 08:00:00	AAPL	Stock	160.9443	161.66	159.61	161.5	407767.0
2022-08-03 09:00:00	AAPL	Stock	161.5	163.32	160.01	163.24	8470816.0
2022-08-03 10:00:00	AAPL	Stock	163.24	164.43	162.83	164.03	9919485.0
2022-08-03 11:00:00	AAPL	Stock	164.03	165.185	164.005	165.0758	8880106.0
2022-08-03 12:00:00	AAPL	Stock	165.08	166.04	164.455	165.87	7536638.0
2022-08-03 13:00:00	AAPL	Stock	165.86	166.44	165.62	166.08	7482953.0
2022-08-03 14:00:00	AAPL	Stock	166.075	166.56	166.01	166.13	5762516.0
2022-08-03 15:00:00	AAPL	Stock	166.13	166.59	165.81	166.1299	11353051.0
2022-08-03 16:00:00	AAPL	Stock	166.13	166.15	165.63	166.13	9077712.0
2022-08-03 17:00:00	AAPL	Stock	165.9002	165.93	165.8	165.83	26975.0
2022-08-03 18:00:00	AAPL	Stock	165.82	165.87	165.64	165.77	19918.0
2022-08-03 19:00:00	AAPL	Stock	165.75	165.84	165.73	165.84	35309.0
2022-08-03 04:00:00	MSFT	Stock	274.75	275.0	274.75	275.0	580.0
2022-08-03 05:00:00	MSFT	Stock	275.19	276.3	275.19	276.18	1706.0
2022-08-03 06:00:00	MSFT	Stock	276.17	276.17	276.07	276.07	1077.0
2022-08-03 07:00:00	MSFT	Stock	275.9	276.5	275.62	275.9	5678.0
2022-08-03 08:00:00	MSFT	Stock	276.0	277.48	275.5	277.12	45403.0
2022-08-03 09:00:00	MSFT	Stock	277.2	279.3	276.61	278.87	1535134.0
2022-08-03 10:00:00	MSFT	Stock	278.8	280.28	278.05	278.83	1895433.0
2022-08-03 11:00:00	MSFT	Stock	278.825	281.42	278.55	281.28	1987766.0
2022-08-03 12:00:00	MSFT	Stock	281.28	282.85	280.615	282.344	1678598.0
2022-08-03 13:00:00	MSFT	Stock	282.35	283.5	282.33	283.11	1864359.0
2022-08-03 14:00:00	MSFT	Stock	283.07	283.07	282.31	282.67	992053.0
2022-08-03 15:00:00	MSFT	Stock	282.64	283.23	282.3	282.47	2884892.0
2022-08-03 16:00:00	MSFT	Stock	282.46	282.53	281.6	281.81	4226200.0
2022-08-03 17:00:00	MSFT	Stock	281.65	282.0	281.55	281.91	7355.0
2022-08-03 18:00:00	MSFT	Stock	281.82	281.82	281.52	281.54	5154.0
2022-08-03 19:00:00	MSFT	Stock	281.65	281.7	281.35	281.7	10172.0
2022-08-03 04:00:00	NVDA	Stock	18.117	18.263	18.117	18.261	190700.0
2022-08-03 05:00:00	NVDA	Stock	18.242	18.299	18.232	18.26	108240.0
2022-08-03 06:00:00	NVDA	Stock	18.272	18.272	18.232	18.27	52270.0
2022-08-03 07:00:00	NVDA	Stock	18.269	18.315	18.232	18.27	194470.0
2022-08-03 08:00:00	NVDA	Stock	18.3	18.37	18.185	18.312	1027380.0
2022-08-03 09:00:00	NVDA	Stock	18.32	18.535	18.137	18.494	59140270.0
2022-08-03 10:00:00	NVDA	Stock	18.488	18.691	18.339	18.491	64661680.0
2022-08-03 11:00:00	NVDA	Stock	18.492	18.618	18.411	18.582	39766620.0
2022-08-03 12:00:00	NVDA	Stock	18.5847	18.737	18.5025	18.704	33849370.0
2022-08-03 13:00:00	NVDA	Stock	18.706	18.804	18.686	18.7542	28694810.0
2022-08-03 14:00:00	NVDA	Stock	18.755	18.868	18.721	18.816	28281620.0
2022-08-03 15:00:00	NVDA	Stock	18.816	18.968	18.771	18.892	50959420.0
2022-08-03 16:00:00	NVDA	Stock	18.893	18.904	18.6227	18.815	25026830.0
2022-08-03 17:00:00	NVDA	Stock	18.811	18.848	18.81	18.824	182460.0
2022-08-03 18:00:00	NVDA	Stock	18.82	18.825	18.79	18.8	224380.0
2022-08-03 19:00:00	NVDA	Stock	18.814	18.814	18.788	18.804	158800.0
2022-08-03 04:00:00	AMZN	Stock	134.7	134.7	134.11	134.59	8326.0
2022-08-03 05:00:00	AMZN	Stock	134.58	135.24	134.58	135.04	21861.0

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

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