PREVIEW / stock_1hour / 2023-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-07.parquet
  size:    1.3 MB
  rows:    60,252
  symbols: 1,509

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-08-07 04:00:00	AAPL	Stock	183.04	183.49	182.54	182.91	72154.0
2023-08-07 05:00:00	AAPL	Stock	182.82	183.2	182.77	182.86	18848.0
2023-08-07 06:00:00	AAPL	Stock	182.82	182.88	182.38	182.66	32577.0
2023-08-07 07:00:00	AAPL	Stock	182.69	182.97	182.26	182.54	86576.0
2023-08-07 08:00:00	AAPL	Stock	182.62	183.88	182.1	182.61	302321.0
2023-08-07 09:00:00	AAPL	Stock	182.63	183.13	178.2101	178.39	17471451.0
2023-08-07 10:00:00	AAPL	Stock	178.395	179.79	178.065	178.11	13551773.0
2023-08-07 11:00:00	AAPL	Stock	178.1	178.785	177.35	178.65	11275337.0
2023-08-07 12:00:00	AAPL	Stock	178.66	178.83	177.74	178.23	6730425.0
2023-08-07 13:00:00	AAPL	Stock	178.235	178.86	177.97	178.8384	5711658.0
2023-08-07 14:00:00	AAPL	Stock	178.84	179.04	178.31	178.475	5062282.0
2023-08-07 15:00:00	AAPL	Stock	178.48	179.22	178.22	178.809	11185032.0
2023-08-07 16:00:00	AAPL	Stock	178.79	179.09	178.69	179.03	6098035.0
2023-08-07 17:00:00	AAPL	Stock	179.04	179.15	179.03	179.11	143550.0
2023-08-07 18:00:00	AAPL	Stock	179.11	179.15	179.0	179.12	37135.0
2023-08-07 19:00:00	AAPL	Stock	179.11	179.16	179.03	179.16	54923.0
2023-08-07 04:00:00	MSFT	Stock	329.9	330.3	329.18	329.22	7066.0
2023-08-07 05:00:00	MSFT	Stock	329.35	329.81	329.22	329.51	2260.0
2023-08-07 06:00:00	MSFT	Stock	329.27	329.27	328.74	329.13	1234.0
2023-08-07 07:00:00	MSFT	Stock	329.31	329.31	328.79	329.16	5722.0
2023-08-07 08:00:00	MSFT	Stock	329.2	330.0	328.5	329.5	31317.0
2023-08-07 09:00:00	MSFT	Stock	329.49	331.11	328.18	329.785	1744716.0
2023-08-07 10:00:00	MSFT	Stock	329.7	330.87	328.81	329.3	1542220.0
2023-08-07 11:00:00	MSFT	Stock	329.21	329.56	327.52	329.28	1789644.0
2023-08-07 12:00:00	MSFT	Stock	329.35	329.81	328.26	329.0023	1163620.0
2023-08-07 13:00:00	MSFT	Stock	328.98	329.5	328.7	329.3431	743153.0
2023-08-07 14:00:00	MSFT	Stock	329.35	330.0	329.295	329.57	820822.0
2023-08-07 15:00:00	MSFT	Stock	329.575	330.26	329.31	330.11	1571110.0
2023-08-07 16:00:00	MSFT	Stock	330.11	330.77	330.11	330.33	1661221.0
2023-08-07 17:00:00	MSFT	Stock	330.46	330.46	330.16	330.24	3869.0
2023-08-07 18:00:00	MSFT	Stock	330.31	330.31	330.11	330.16	2722.0
2023-08-07 19:00:00	MSFT	Stock	330.15	330.63	330.15	330.5	3717.0
2023-08-07 04:00:00	NVDA	Stock	45.08	45.15	44.922	45.01	276770.0
2023-08-07 05:00:00	NVDA	Stock	45.029	45.175	45.01	45.155	38710.0
2023-08-07 06:00:00	NVDA	Stock	45.1	45.127	45.01	45.056	28130.0
2023-08-07 07:00:00	NVDA	Stock	45.056	45.08	44.886	45.028	311600.0
2023-08-07 08:00:00	NVDA	Stock	44.988	45.147	44.5683	45.138	1669910.0
2023-08-07 09:00:00	NVDA	Stock	45.13	45.471	45.005	45.292	40640350.0
2023-08-07 10:00:00	NVDA	Stock	45.278	45.54	45.0351	45.233	44290680.0
2023-08-07 11:00:00	NVDA	Stock	45.2225	45.2959	44.838	45.2234	33716750.0
2023-08-07 12:00:00	NVDA	Stock	45.224	45.29	44.78	44.8935	27820270.0
2023-08-07 13:00:00	NVDA	Stock	44.8935	44.929	44.5635	44.8368	29954550.0
2023-08-07 14:00:00	NVDA	Stock	44.83	44.949	44.7	44.909	18935240.0
2023-08-07 15:00:00	NVDA	Stock	44.911	45.428	44.911	45.412	33053460.0
2023-08-07 16:00:00	NVDA	Stock	45.4165	45.47	45.38	45.448	11411640.0
2023-08-07 17:00:00	NVDA	Stock	45.425	45.45	45.4	45.423	277050.0
2023-08-07 18:00:00	NVDA	Stock	45.42	45.425	45.39	45.406	181000.0
2023-08-07 19:00:00	NVDA	Stock	45.415	45.42	45.322	45.354	383460.0
2023-08-07 04:00:00	AMZN	Stock	140.7	141.0	140.02	140.65	53296.0
2023-08-07 05:00:00	AMZN	Stock	140.6	140.75	140.56	140.7	10373.0

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

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