PREVIEW / stock_1hour / 2023-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-05.parquet
  size:    1.4 MB
  rows:    60,509
  symbols: 1,655

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-05 04:00:00	AAPL	Stock	170.0	170.0	169.28	169.51	65870.0
2023-05-05 05:00:00	AAPL	Stock	169.49	169.68	169.35	169.6	33792.0
2023-05-05 06:00:00	AAPL	Stock	169.63	169.84	169.46	169.49	49279.0
2023-05-05 07:00:00	AAPL	Stock	169.49	170.42	169.44	170.09	231109.0
2023-05-05 08:00:00	AAPL	Stock	169.4999	170.71	169.0	170.01	1315491.0
2023-05-05 09:00:00	AAPL	Stock	170.01	173.75	169.83	173.12	22610927.0
2023-05-05 10:00:00	AAPL	Stock	173.14	174.2	172.72	173.56	16475654.0
2023-05-05 11:00:00	AAPL	Stock	173.5648	174.05	173.33	173.7937	9011866.0
2023-05-05 12:00:00	AAPL	Stock	173.795	174.05	173.21	173.465	6967703.0
2023-05-05 13:00:00	AAPL	Stock	173.47	174.09	173.24	173.8819	6443575.0
2023-05-05 14:00:00	AAPL	Stock	173.8858	174.18	173.69	174.145	6345076.0
2023-05-05 15:00:00	AAPL	Stock	174.15	174.3	173.3	173.62	13412083.0
2023-05-05 16:00:00	AAPL	Stock	173.63	173.69	173.0	173.49	9557737.0
2023-05-05 17:00:00	AAPL	Stock	173.5	173.55	173.03	173.05	158890.0
2023-05-05 18:00:00	AAPL	Stock	173.06	173.27	173.05	173.27	68858.0
2023-05-05 19:00:00	AAPL	Stock	173.27	173.27	173.08	173.08	54578.0
2023-05-05 04:00:00	MSFT	Stock	305.86	306.7	305.86	306.2	3586.0
2023-05-05 05:00:00	MSFT	Stock	306.07	306.9	306.0	306.9	4569.0
2023-05-05 06:00:00	MSFT	Stock	306.9	307.1	306.8	307.1	2859.0
2023-05-05 07:00:00	MSFT	Stock	307.0	307.28	306.8	307.15	17908.0
2023-05-05 08:00:00	MSFT	Stock	306.9478	307.2899	305.5749	305.7	69248.0
2023-05-05 09:00:00	MSFT	Stock	305.8	307.15	304.27	307.0499	2341199.0
2023-05-05 10:00:00	MSFT	Stock	307.05	309.42	306.8818	308.84	3186224.0
2023-05-05 11:00:00	MSFT	Stock	308.86	309.5873	308.24	309.015	2030779.0
2023-05-05 12:00:00	MSFT	Stock	309.03	309.55	308.5	309.4668	1281474.0
2023-05-05 13:00:00	MSFT	Stock	309.47	310.35	309.423	309.91	2023012.0
2023-05-05 14:00:00	MSFT	Stock	309.93	311.97	309.69	311.57	2204135.0
2023-05-05 15:00:00	MSFT	Stock	311.575	311.87	310.09	310.62	3586542.0
2023-05-05 16:00:00	MSFT	Stock	310.63	310.93	310.51	310.73	3515160.0
2023-05-05 17:00:00	MSFT	Stock	310.79	310.79	310.55	310.69	9506.0
2023-05-05 18:00:00	MSFT	Stock	310.6223	310.64	310.52	310.52	6735.0
2023-05-05 19:00:00	MSFT	Stock	310.52	310.65	310.51	310.65	4798.0
2023-05-05 04:00:00	NVDA	Stock	27.65	27.669	27.586	27.663	32810.0
2023-05-05 05:00:00	NVDA	Stock	27.674	27.679	27.641	27.67	13410.0
2023-05-05 06:00:00	NVDA	Stock	27.639	27.7	27.639	27.7	18000.0
2023-05-05 07:00:00	NVDA	Stock	27.7	27.762	27.695	27.7	164080.0
2023-05-05 08:00:00	NVDA	Stock	27.69	27.8398	27.6409	27.785	1465740.0
2023-05-05 09:00:00	NVDA	Stock	27.788	28.124	27.731	28.0874	38939160.0
2023-05-05 10:00:00	NVDA	Stock	28.096	28.499	28.046	28.393	58885420.0
2023-05-05 11:00:00	NVDA	Stock	28.393	28.453	28.326	28.373	32508050.0
2023-05-05 12:00:00	NVDA	Stock	28.38	28.427	28.3031	28.414	18513460.0
2023-05-05 13:00:00	NVDA	Stock	28.416	28.611	28.399	28.606	27378990.0
2023-05-05 14:00:00	NVDA	Stock	28.608	28.75	28.565	28.722	30524360.0
2023-05-05 15:00:00	NVDA	Stock	28.72	28.755	28.623	28.678	41482400.0
2023-05-05 16:00:00	NVDA	Stock	28.678	28.697	28.607	28.66	19612040.0
2023-05-05 17:00:00	NVDA	Stock	28.66	28.67	28.653	28.6554	178940.0
2023-05-05 18:00:00	NVDA	Stock	28.655	28.66	28.631	28.657	159710.0
2023-05-05 19:00:00	NVDA	Stock	28.652	28.665	28.636	28.652	213810.0
2023-05-05 04:00:00	AMZN	Stock	104.5	104.5	104.2	104.37	6716.0
2023-05-05 05:00:00	AMZN	Stock	104.35	104.56	104.35	104.45	5408.0

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

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