PREVIEW / stock_1hour / 2023-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-02.parquet
  size:    1.4 MB
  rows:    60,967
  symbols: 1,664

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-02 04:00:00	AAPL	Stock	169.9	169.9	169.43	169.54	12627.0
2023-05-02 05:00:00	AAPL	Stock	169.57	169.78	169.54	169.67	5839.0
2023-05-02 06:00:00	AAPL	Stock	169.62	169.88	169.59	169.88	9719.0
2023-05-02 07:00:00	AAPL	Stock	169.72	169.87	169.6	169.8	29069.0
2023-05-02 08:00:00	AAPL	Stock	169.7805	170.03	169.14	169.7789	138980.0
2023-05-02 09:00:00	AAPL	Stock	169.7757	170.35	169.4107	169.77	5057262.0
2023-05-02 10:00:00	AAPL	Stock	169.8	169.9338	168.02	168.27	7271206.0
2023-05-02 11:00:00	AAPL	Stock	168.26	168.3768	167.54	167.63	6046117.0
2023-05-02 12:00:00	AAPL	Stock	167.62	168.52	167.55	168.39	3462597.0
2023-05-02 13:00:00	AAPL	Stock	168.38	168.95	168.33	168.6758	3566472.0
2023-05-02 14:00:00	AAPL	Stock	168.68	169.05	168.345	169.03	2911551.0
2023-05-02 15:00:00	AAPL	Stock	169.03	169.28	168.39	168.55	5977386.0
2023-05-02 16:00:00	AAPL	Stock	168.54	168.63	168.3	168.41	6432357.0
2023-05-02 17:00:00	AAPL	Stock	168.4201	168.49	168.32	168.37	21956.0
2023-05-02 18:00:00	AAPL	Stock	168.38	168.5	168.3	168.35	37525.0
2023-05-02 19:00:00	AAPL	Stock	168.28	168.6	168.26	168.6	40448.0
2023-05-02 04:00:00	MSFT	Stock	305.9	306.9	305.74	306.23	5176.0
2023-05-02 05:00:00	MSFT	Stock	306.3	306.66	306.3	306.66	808.0
2023-05-02 06:00:00	MSFT	Stock	306.43	306.55	306.38	306.46	613.0
2023-05-02 07:00:00	MSFT	Stock	306.41	306.74	306.2	306.4	6003.0
2023-05-02 08:00:00	MSFT	Stock	306.3	306.75	304.65	306.4	28478.0
2023-05-02 09:00:00	MSFT	Stock	306.4	308.89	306.25	308.08	3414637.0
2023-05-02 10:00:00	MSFT	Stock	308.11	309.18	305.04	305.25	3755966.0
2023-05-02 11:00:00	MSFT	Stock	305.22	305.46	303.91	304.185	2318773.0
2023-05-02 12:00:00	MSFT	Stock	304.14	305.49	303.99	305.1	1320467.0
2023-05-02 13:00:00	MSFT	Stock	305.0881	306.65	304.98	306.18	1596331.0
2023-05-02 14:00:00	MSFT	Stock	306.2	306.658	305.205	305.81	1369219.0
2023-05-02 15:00:00	MSFT	Stock	305.81	306.22	305.18	305.41	2299773.0
2023-05-02 16:00:00	MSFT	Stock	305.41	305.57	305.15	305.29	3512954.0
2023-05-02 17:00:00	MSFT	Stock	305.18	305.39	305.1242	305.1242	10062.0
2023-05-02 18:00:00	MSFT	Stock	305.28	305.55	305.12	305.21	13753.0
2023-05-02 19:00:00	MSFT	Stock	305.36	306.26	305.35	306.05	15159.0
2023-05-02 04:00:00	NVDA	Stock	28.9	28.9	28.76	28.772	84460.0
2023-05-02 05:00:00	NVDA	Stock	28.761	28.802	28.76	28.79	60320.0
2023-05-02 06:00:00	NVDA	Stock	28.777	28.8	28.767	28.795	27750.0
2023-05-02 07:00:00	NVDA	Stock	28.8	28.8	28.71	28.749	366250.0
2023-05-02 08:00:00	NVDA	Stock	28.735	28.901	28.635	28.65	1646640.0
2023-05-02 09:00:00	NVDA	Stock	28.658	28.836	28.44	28.512	56023690.0
2023-05-02 10:00:00	NVDA	Stock	28.517	28.611	28.173	28.1958	68881830.0
2023-05-02 11:00:00	NVDA	Stock	28.195	28.342	28.175	28.241	46157740.0
2023-05-02 12:00:00	NVDA	Stock	28.237	28.31	28.083	28.265	32718960.0
2023-05-02 13:00:00	NVDA	Stock	28.268	28.439	28.217	28.395	26448610.0
2023-05-02 14:00:00	NVDA	Stock	28.395	28.412	28.2215	28.357	24966860.0
2023-05-02 15:00:00	NVDA	Stock	28.352	28.385	28.102	28.21	40122520.0
2023-05-02 16:00:00	NVDA	Stock	28.208	28.391	27.825	27.926	16859390.0
2023-05-02 17:00:00	NVDA	Stock	27.938	27.975	27.735	27.845	1438470.0
2023-05-02 18:00:00	NVDA	Stock	27.844	27.86	27.769	27.81	649750.0
2023-05-02 19:00:00	NVDA	Stock	27.81	27.898	27.791	27.853	361380.0
2023-05-02 04:00:00	AMZN	Stock	101.51	101.8	101.1	101.52	34477.0
2023-05-02 05:00:00	AMZN	Stock	101.54	101.89	101.52	101.76	19090.0

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

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