PREVIEW / stock_1hour / 2023-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-04.parquet
  size:    1.3 MB
  rows:    58,062
  symbols: 1,385

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-10-04 04:00:00	AAPL	Stock	170.48	170.48	169.26	170.35	83065.0
2023-10-04 05:00:00	AAPL	Stock	170.23	170.69	170.0	170.57	26923.0
2023-10-04 06:00:00	AAPL	Stock	170.6	170.9	170.35	170.72	19138.0
2023-10-04 07:00:00	AAPL	Stock	170.71	171.25	170.66	170.9	104017.0
2023-10-04 08:00:00	AAPL	Stock	170.72	171.78	169.57	171.6	326813.0
2023-10-04 09:00:00	AAPL	Stock	171.61	172.69	170.86	172.49	6036389.0
2023-10-04 10:00:00	AAPL	Stock	172.48	173.49	171.87	172.45	8810895.0
2023-10-04 11:00:00	AAPL	Stock	172.44	173.15	172.13	173.14	5027213.0
2023-10-04 12:00:00	AAPL	Stock	173.14	173.29	172.81	173.11	3173152.0
2023-10-04 13:00:00	AAPL	Stock	173.1	173.13	172.46	172.52	3042186.0
2023-10-04 14:00:00	AAPL	Stock	172.515	173.1399	172.35	173.0792	3089189.0
2023-10-04 15:00:00	AAPL	Stock	173.09	174.21	173.03	173.66	8628685.0
2023-10-04 16:00:00	AAPL	Stock	173.66	173.66	173.11	173.5001	5873651.0
2023-10-04 17:00:00	AAPL	Stock	173.52	173.66	173.22	173.31	43956.0
2023-10-04 18:00:00	AAPL	Stock	173.3	173.45	173.25	173.33	30956.0
2023-10-04 19:00:00	AAPL	Stock	173.31	173.43	173.26	173.27	19497.0
2023-10-04 04:00:00	MSFT	Stock	311.68	312.17	310.99	312.1	38709.0
2023-10-04 05:00:00	MSFT	Stock	311.95	312.8	311.95	312.79	3158.0
2023-10-04 06:00:00	MSFT	Stock	312.77	312.8	312.0	312.49	2083.0
2023-10-04 07:00:00	MSFT	Stock	312.61	314.7	312.61	314.3	9912.0
2023-10-04 08:00:00	MSFT	Stock	312.79	315.79	311.0	315.0907	55167.0
2023-10-04 09:00:00	MSFT	Stock	315.0	317.88	314.0	316.755	1833762.0
2023-10-04 10:00:00	MSFT	Stock	316.765	318.32	315.12	316.89	2095690.0
2023-10-04 11:00:00	MSFT	Stock	316.88	319.25	316.66	319.07	1453567.0
2023-10-04 12:00:00	MSFT	Stock	319.04	319.175	317.79	318.15	1050229.0
2023-10-04 13:00:00	MSFT	Stock	318.17	318.23	316.31	316.47	1072061.0
2023-10-04 14:00:00	MSFT	Stock	316.44	318.0	316.16	317.86	951391.0
2023-10-04 15:00:00	MSFT	Stock	317.86	320.04	317.745	318.95	2699924.0
2023-10-04 16:00:00	MSFT	Stock	318.955	319.15	318.3279	318.8	3488830.0
2023-10-04 17:00:00	MSFT	Stock	318.8	318.955	318.3315	318.4	9107.0
2023-10-04 18:00:00	MSFT	Stock	318.4	318.89	318.05	318.89	11057.0
2023-10-04 19:00:00	MSFT	Stock	318.88	320.1	318.88	319.75	22275.0
2023-10-04 04:00:00	NVDA	Stock	43.1	43.3	42.954	43.3	201860.0
2023-10-04 05:00:00	NVDA	Stock	43.271	43.452	43.245	43.434	40180.0
2023-10-04 06:00:00	NVDA	Stock	43.44	43.5	43.302	43.337	75750.0
2023-10-04 07:00:00	NVDA	Stock	43.35	43.69	43.35	43.625	452670.0
2023-10-04 08:00:00	NVDA	Stock	43.625	43.929	42.727	43.7	3463970.0
2023-10-04 09:00:00	NVDA	Stock	43.706	44.044	43.556	43.8506	43586710.0
2023-10-04 10:00:00	NVDA	Stock	43.85	43.896	43.292	43.6049	60776510.0
2023-10-04 11:00:00	NVDA	Stock	43.612	44.143	43.537	44.0772	43719050.0
2023-10-04 12:00:00	NVDA	Stock	44.076	44.091	43.69	43.936	29691050.0
2023-10-04 13:00:00	NVDA	Stock	43.935	43.971	43.518	43.536	22558900.0
2023-10-04 14:00:00	NVDA	Stock	43.531	43.795	43.45	43.737	25817210.0
2023-10-04 15:00:00	NVDA	Stock	43.7372	44.099	43.67	44.007	39870300.0
2023-10-04 16:00:00	NVDA	Stock	44.007	44.041	43.975	43.989	18934520.0
2023-10-04 17:00:00	NVDA	Stock	43.984	44.041	43.962	43.97	151150.0
2023-10-04 18:00:00	NVDA	Stock	43.97	43.97	43.9	43.9	303860.0
2023-10-04 19:00:00	NVDA	Stock	43.9	43.978	43.9	43.96	295140.0
2023-10-04 04:00:00	AMZN	Stock	123.71	124.69	123.71	124.69	14726.0
2023-10-04 05:00:00	AMZN	Stock	124.65	124.9	124.52	124.89	5229.0

> showing 50 of 58,062 rows — these rows as CSV

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