PREVIEW / stock_1hour / 2023-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-24.parquet
  size:    1.3 MB
  rows:    57,876
  symbols: 1,335

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-24 04:00:00	AAPL	Stock	173.76	173.76	173.07	173.45	11246.0
2023-10-24 05:00:00	AAPL	Stock	173.44	173.96	173.39	173.75	5640.0
2023-10-24 06:00:00	AAPL	Stock	173.78	173.78	173.31	173.42	4321.0
2023-10-24 07:00:00	AAPL	Stock	173.41	173.59	173.22	173.3	41772.0
2023-10-24 08:00:00	AAPL	Stock	173.57	173.74	173.0099	173.3	86576.0
2023-10-24 09:00:00	AAPL	Stock	173.32	173.34	171.96	172.76	5276430.0
2023-10-24 10:00:00	AAPL	Stock	172.755	172.89	171.81	172.53	6280131.0
2023-10-24 11:00:00	AAPL	Stock	172.5302	172.78	172.13	172.7402	3832297.0
2023-10-24 12:00:00	AAPL	Stock	172.76	173.02	171.45	171.76	3812231.0
2023-10-24 13:00:00	AAPL	Stock	171.76	172.365	171.7	172.1	2880088.0
2023-10-24 14:00:00	AAPL	Stock	172.1	173.175	172.06	173.12	3459356.0
2023-10-24 15:00:00	AAPL	Stock	173.12	173.67	173.035	173.39	6507403.0
2023-10-24 16:00:00	AAPL	Stock	173.39	173.93	173.1	173.3	4242294.0
2023-10-24 17:00:00	AAPL	Stock	173.24	173.35	173.01	173.04	54954.0
2023-10-24 18:00:00	AAPL	Stock	173.17	173.38	173.0	173.02	29323.0
2023-10-24 19:00:00	AAPL	Stock	173.02	173.2	172.9	172.9	18690.0
2023-10-24 04:00:00	MSFT	Stock	331.69	332.0	330.45	331.35	6364.0
2023-10-24 05:00:00	MSFT	Stock	331.59	332.91	331.51	332.23	4462.0
2023-10-24 06:00:00	MSFT	Stock	332.15	332.16	331.78	331.93	2348.0
2023-10-24 07:00:00	MSFT	Stock	331.92	332.4	331.88	332.2	23599.0
2023-10-24 08:00:00	MSFT	Stock	332.08	332.7	330.72	331.35	60217.0
2023-10-24 09:00:00	MSFT	Stock	331.339	331.6	328.69	330.5921	2210100.0
2023-10-24 10:00:00	MSFT	Stock	330.59	331.84	329.65	330.775	2055834.0
2023-10-24 11:00:00	MSFT	Stock	330.78	331.34	329.23	330.42	1580848.0
2023-10-24 12:00:00	MSFT	Stock	330.43	330.62	327.9	328.0967	1516784.0
2023-10-24 13:00:00	MSFT	Stock	328.08	329.83	327.6	329.64	1393429.0
2023-10-24 14:00:00	MSFT	Stock	329.63	331.05	329.2912	330.755	1415242.0
2023-10-24 15:00:00	MSFT	Stock	330.77	331.6599	330.2901	330.79	3816017.0
2023-10-24 16:00:00	MSFT	Stock	330.53	349.98	330.5	344.94	5038317.0
2023-10-24 17:00:00	MSFT	Stock	344.78	347.97	341.52	345.0779	777928.0
2023-10-24 18:00:00	MSFT	Stock	346.0	351.95	337.6996	343.3199	1458755.0
2023-10-24 19:00:00	MSFT	Stock	343.32	344.8	343.04	343.6	148741.0
2023-10-24 04:00:00	NVDA	Stock	43.312	43.63	43.312	43.414	340530.0
2023-10-24 05:00:00	NVDA	Stock	43.399	43.6	43.399	43.57	94890.0
2023-10-24 06:00:00	NVDA	Stock	43.579	43.68	43.535	43.6	247210.0
2023-10-24 07:00:00	NVDA	Stock	43.6	43.8	43.58	43.749	963560.0
2023-10-24 08:00:00	NVDA	Stock	43.611	43.8	43.242	43.585	1786830.0
2023-10-24 09:00:00	NVDA	Stock	43.574	43.58	42.691	43.309	59674050.0
2023-10-24 10:00:00	NVDA	Stock	43.294	43.311	42.759	43.035	54619390.0
2023-10-24 11:00:00	NVDA	Stock	43.0369	43.218	42.88	43.21	33588900.0
2023-10-24 12:00:00	NVDA	Stock	43.209	43.229	42.712	42.87	29087610.0
2023-10-24 13:00:00	NVDA	Stock	42.868	43.171	42.842	43.113	24432530.0
2023-10-24 14:00:00	NVDA	Stock	43.1075	43.369	43.05	43.34	28045760.0
2023-10-24 15:00:00	NVDA	Stock	43.343	43.697	43.317	43.663	51874770.0
2023-10-24 16:00:00	NVDA	Stock	43.663	44.0	43.545	43.588	17269310.0
2023-10-24 17:00:00	NVDA	Stock	43.572	43.7	43.525	43.589	788600.0
2023-10-24 18:00:00	NVDA	Stock	43.65	43.7	43.418	43.657	547080.0
2023-10-24 19:00:00	NVDA	Stock	43.625	43.71	43.59	43.663	451070.0
2023-10-24 04:00:00	AMZN	Stock	127.73	127.73	127.0	127.34	19132.0
2023-10-24 05:00:00	AMZN	Stock	127.45	127.88	127.45	127.74	9458.0

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

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