PREVIEW / stock_1hour / 2023-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-03.parquet
  size:    1.4 MB
  rows:    61,724
  symbols: 1,635

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-03 04:00:00	AAPL	Stock	168.75	168.93	168.6	168.87	16212.0
2023-05-03 05:00:00	AAPL	Stock	168.87	168.96	168.84	168.95	5630.0
2023-05-03 06:00:00	AAPL	Stock	168.94	169.3	168.94	169.03	23944.0
2023-05-03 07:00:00	AAPL	Stock	169.05	169.37	169.05	169.1	39062.0
2023-05-03 08:00:00	AAPL	Stock	169.0563	169.3502	167.04	169.0001	142348.0
2023-05-03 09:00:00	AAPL	Stock	169.0	170.89	168.99	170.7519	6851826.0
2023-05-03 10:00:00	AAPL	Stock	170.75	170.92	169.57	169.625	6615023.0
2023-05-03 11:00:00	AAPL	Stock	169.62	169.9299	169.18	169.9214	3739164.0
2023-05-03 12:00:00	AAPL	Stock	169.9287	170.17	169.52	169.995	3095243.0
2023-05-03 13:00:00	AAPL	Stock	169.995	170.29	169.7804	169.89	3093863.0
2023-05-03 14:00:00	AAPL	Stock	169.88	170.76	169.05	170.05	8686994.0
2023-05-03 15:00:00	AAPL	Stock	170.0401	170.47	167.16	167.465	10188680.0
2023-05-03 16:00:00	AAPL	Stock	167.48	167.6	165.32	165.66	6143857.0
2023-05-03 17:00:00	AAPL	Stock	165.66	167.45	162.75	164.25	1100649.0
2023-05-03 18:00:00	AAPL	Stock	164.24	165.3893	163.52	165.2	466723.0
2023-05-03 19:00:00	AAPL	Stock	165.16	165.72	165.0	165.6	178127.0
2023-05-03 04:00:00	MSFT	Stock	305.99	306.58	304.0	306.4	10095.0
2023-05-03 05:00:00	MSFT	Stock	306.53	306.7	306.4	306.7	1559.0
2023-05-03 06:00:00	MSFT	Stock	307.0	307.4	306.84	307.15	13104.0
2023-05-03 07:00:00	MSFT	Stock	307.01	307.55	307.01	307.4	10252.0
2023-05-03 08:00:00	MSFT	Stock	307.16	307.52	304.87	306.802	50386.0
2023-05-03 09:00:00	MSFT	Stock	306.89	307.2	304.61	305.65	1909895.0
2023-05-03 10:00:00	MSFT	Stock	305.45	306.37	304.26	305.69	2069207.0
2023-05-03 11:00:00	MSFT	Stock	305.645	306.9734	304.94	306.87	1465899.0
2023-05-03 12:00:00	MSFT	Stock	306.9	306.92	305.33	306.91	1095255.0
2023-05-03 13:00:00	MSFT	Stock	306.91	307.5399	306.43	306.95	1357993.0
2023-05-03 14:00:00	MSFT	Stock	306.9165	308.61	305.12	307.16	2774881.0
2023-05-03 15:00:00	MSFT	Stock	307.14	307.97	304.09	304.42	3238681.0
2023-05-03 16:00:00	MSFT	Stock	304.4	305.2	304.23	304.34	2768417.0
2023-05-03 17:00:00	MSFT	Stock	304.6314	304.68	303.85	304.4	41466.0
2023-05-03 18:00:00	MSFT	Stock	304.4	305.02	304.1501	305.0	41637.0
2023-05-03 19:00:00	MSFT	Stock	304.83	305.15	304.76	304.76	21835.0
2023-05-03 04:00:00	NVDA	Stock	27.91	27.987	27.847	27.927	76410.0
2023-05-03 05:00:00	NVDA	Stock	27.968	27.97	27.9	27.901	26660.0
2023-05-03 06:00:00	NVDA	Stock	27.907	27.907	27.847	27.87	85020.0
2023-05-03 07:00:00	NVDA	Stock	27.88	28.075	27.86	28.06	586740.0
2023-05-03 08:00:00	NVDA	Stock	27.89	28.089	27.733	27.976	957120.0
2023-05-03 09:00:00	NVDA	Stock	27.98	28.069	27.472	27.677	52503260.0
2023-05-03 10:00:00	NVDA	Stock	27.682	28.034	27.666	27.9034	56872570.0
2023-05-03 11:00:00	NVDA	Stock	27.904	27.918	27.706	27.885	28287140.0
2023-05-03 12:00:00	NVDA	Stock	27.886	27.9338	27.837	27.929	18420720.0
2023-05-03 13:00:00	NVDA	Stock	27.93	28.044	27.826	28.024	18080530.0
2023-05-03 14:00:00	NVDA	Stock	28.015	28.367	27.89	28.1785	57714420.0
2023-05-03 15:00:00	NVDA	Stock	28.187	28.292	27.782	27.801	55500960.0
2023-05-03 16:00:00	NVDA	Stock	27.802	27.87	27.75	27.778	11449060.0
2023-05-03 17:00:00	NVDA	Stock	27.774	27.8	27.58	27.625	703220.0
2023-05-03 18:00:00	NVDA	Stock	27.647	27.665	27.527	27.642	458320.0
2023-05-03 19:00:00	NVDA	Stock	27.645	27.68	27.625	27.675	222610.0
2023-05-03 04:00:00	AMZN	Stock	103.61	103.82	103.25	103.8	7426.0
2023-05-03 05:00:00	AMZN	Stock	103.78	103.87	103.65	103.78	7047.0

> showing 50 of 61,724 rows — these rows as CSV

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