PREVIEW / stock_1hour / 2023-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-26.parquet
  size:    1.3 MB
  rows:    57,804
  symbols: 1,400

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-09-26 04:00:00	AAPL	Stock	175.19	175.34	174.98	174.98	17977.0
2023-09-26 05:00:00	AAPL	Stock	175.01	175.14	174.93	174.95	6229.0
2023-09-26 06:00:00	AAPL	Stock	175.1	175.29	175.0	175.29	4507.0
2023-09-26 07:00:00	AAPL	Stock	175.32	175.51	175.04	175.42	19323.0
2023-09-26 08:00:00	AAPL	Stock	175.2	175.5927	174.85	175.15	110062.0
2023-09-26 09:00:00	AAPL	Stock	175.0322	175.2	172.93	173.04	7657083.0
2023-09-26 10:00:00	AAPL	Stock	173.04	173.65	172.48	172.77	9552573.0
2023-09-26 11:00:00	AAPL	Stock	172.77	173.19	172.415	172.86	5338024.0
2023-09-26 12:00:00	AAPL	Stock	172.8599	173.36	172.52	173.21	3474406.0
2023-09-26 13:00:00	AAPL	Stock	173.21	173.53	172.56	172.8	4217490.0
2023-09-26 14:00:00	AAPL	Stock	172.795	172.87	172.03	172.26	5296634.0
2023-09-26 15:00:00	AAPL	Stock	172.2579	172.35	171.66	171.9	11205692.0
2023-09-26 16:00:00	AAPL	Stock	171.89	172.3	171.89	172.2	7743027.0
2023-09-26 17:00:00	AAPL	Stock	172.1999	172.23	171.99	172.11	64267.0
2023-09-26 18:00:00	AAPL	Stock	172.11	172.19	172.0	172.02	30336.0
2023-09-26 19:00:00	AAPL	Stock	172.06	172.4	172.04	172.36	28354.0
2023-09-26 04:00:00	MSFT	Stock	316.48	316.48	315.45	315.45	5621.0
2023-09-26 05:00:00	MSFT	Stock	315.4	315.9	315.21	315.55	1650.0
2023-09-26 06:00:00	MSFT	Stock	315.5	316.3	315.5	316.3	1115.0
2023-09-26 07:00:00	MSFT	Stock	316.25	316.45	315.75	316.37	2297.0
2023-09-26 08:00:00	MSFT	Stock	315.7625	316.8995	315.34	315.7	23607.0
2023-09-26 09:00:00	MSFT	Stock	315.67	315.92	313.185	313.27	2225140.0
2023-09-26 10:00:00	MSFT	Stock	313.24	313.7199	311.56	312.89	3028023.0
2023-09-26 11:00:00	MSFT	Stock	312.89	313.14	310.83	311.455	1800123.0
2023-09-26 12:00:00	MSFT	Stock	311.46	312.81	311.25	312.3328	1313899.0
2023-09-26 13:00:00	MSFT	Stock	312.34	312.92	310.66	311.62	1421734.0
2023-09-26 14:00:00	MSFT	Stock	311.58	311.78	310.37	310.93	1369204.0
2023-09-26 15:00:00	MSFT	Stock	310.9167	312.43	310.02	312.14	3933953.0
2023-09-26 16:00:00	MSFT	Stock	312.13	312.6893	311.63	312.14	3625046.0
2023-09-26 17:00:00	MSFT	Stock	312.14	312.14	311.98	312.07	6164.0
2023-09-26 18:00:00	MSFT	Stock	312.16	312.3	312.16	312.27	2448.0
2023-09-26 19:00:00	MSFT	Stock	312.26	312.85	312.24	312.85	9627.0
2023-09-26 04:00:00	NVDA	Stock	41.867	42.051	41.801	41.956	93880.0
2023-09-26 05:00:00	NVDA	Stock	41.97	42.001	41.904	41.912	41360.0
2023-09-26 06:00:00	NVDA	Stock	41.939	42.04	41.939	42.038	54800.0
2023-09-26 07:00:00	NVDA	Stock	42.1	42.245	41.975	42.22	394520.0
2023-09-26 08:00:00	NVDA	Stock	42.062	42.45	41.809	42.12	2069880.0
2023-09-26 09:00:00	NVDA	Stock	42.1472	42.188	41.655	41.84	42783620.0
2023-09-26 10:00:00	NVDA	Stock	41.833	42.82	41.804	42.466	79432030.0
2023-09-26 11:00:00	NVDA	Stock	42.478	42.588	42.031	42.0814	48104680.0
2023-09-26 12:00:00	NVDA	Stock	42.086	42.38	42.018	42.255	27392250.0
2023-09-26 13:00:00	NVDA	Stock	42.2575	42.359	41.985	42.226	26554820.0
2023-09-26 14:00:00	NVDA	Stock	42.2215	42.378	42.016	42.1062	28675380.0
2023-09-26 15:00:00	NVDA	Stock	42.114	42.114	41.76	41.912	41459190.0
2023-09-26 16:00:00	NVDA	Stock	41.922	41.947	41.87	41.915	18018180.0
2023-09-26 17:00:00	NVDA	Stock	41.908	41.945	41.871	41.88	183590.0
2023-09-26 18:00:00	NVDA	Stock	41.88	41.924	41.88	41.88	286920.0
2023-09-26 19:00:00	NVDA	Stock	41.877	41.919	41.877	41.9	270110.0
2023-09-26 04:00:00	AMZN	Stock	130.44	131.08	130.44	130.71	23596.0
2023-09-26 05:00:00	AMZN	Stock	130.71	130.71	130.62	130.65	1962.0

> showing 50 of 57,804 rows — these rows as CSV

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