PREVIEW / stock_1hour / 2023-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-01.parquet
  size:    1.3 MB
  rows:    57,789
  symbols: 1,334

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-11-01 04:00:00	AAPL	Stock	170.6	170.6	170.1	170.17	13073.0
2023-11-01 05:00:00	AAPL	Stock	170.14	170.15	169.94	170.0	6304.0
2023-11-01 06:00:00	AAPL	Stock	170.1	170.1	169.85	170.03	3218.0
2023-11-01 07:00:00	AAPL	Stock	170.01	170.1	169.5	169.5	18510.0
2023-11-01 08:00:00	AAPL	Stock	170.1	170.8082	169.4504	170.6	141077.0
2023-11-01 09:00:00	AAPL	Stock	170.5	171.54	170.12	171.08	4619189.0
2023-11-01 10:00:00	AAPL	Stock	171.11	172.08	170.78	171.4579	6739042.0
2023-11-01 11:00:00	AAPL	Stock	171.46	172.0	171.0	171.95	3702138.0
2023-11-01 12:00:00	AAPL	Stock	171.945	172.18	171.61	172.035	2828316.0
2023-11-01 13:00:00	AAPL	Stock	172.035	172.38	171.77	172.19	3056888.0
2023-11-01 14:00:00	AAPL	Stock	172.2	173.27	171.91	173.2	7264848.0
2023-11-01 15:00:00	AAPL	Stock	173.19	174.23	173.18	173.91	10137522.0
2023-11-01 16:00:00	AAPL	Stock	173.92	175.01	173.78	174.29	8778989.0
2023-11-01 17:00:00	AAPL	Stock	174.27	174.7	173.97	174.45	54239.0
2023-11-01 18:00:00	AAPL	Stock	174.4	174.75	174.36	174.71	34097.0
2023-11-01 19:00:00	AAPL	Stock	174.7	175.05	174.7	174.75	42320.0
2023-11-01 04:00:00	MSFT	Stock	338.0	338.0	337.5	337.5	557.0
2023-11-01 05:00:00	MSFT	Stock	336.99	336.99	336.69	336.69	723.0
2023-11-01 06:00:00	MSFT	Stock	336.59	336.75	336.5	336.72	1165.0
2023-11-01 07:00:00	MSFT	Stock	337.25	337.25	336.45	336.45	5500.0
2023-11-01 08:00:00	MSFT	Stock	336.8	339.95	336.5	339.58	62157.0
2023-11-01 09:00:00	MSFT	Stock	339.31	344.08	338.64	343.3905	2725948.0
2023-11-01 10:00:00	MSFT	Stock	343.4	346.51	342.68	345.72	3532875.0
2023-11-01 11:00:00	MSFT	Stock	345.71	346.22	344.34	345.1	1625457.0
2023-11-01 12:00:00	MSFT	Stock	345.1	345.15	343.29	343.71	1093485.0
2023-11-01 13:00:00	MSFT	Stock	343.71	344.43	343.44	344.04	994416.0
2023-11-01 14:00:00	MSFT	Stock	344.045	345.85	343.04	345.19	2225475.0
2023-11-01 15:00:00	MSFT	Stock	345.195	347.42	345.15	346.07	4093019.0
2023-11-01 16:00:00	MSFT	Stock	346.11	346.4889	345.5	346.29	4567818.0
2023-11-01 17:00:00	MSFT	Stock	346.17	346.57	346.15	346.5	7083.0
2023-11-01 18:00:00	MSFT	Stock	346.41	346.95	346.41	346.9499	21613.0
2023-11-01 19:00:00	MSFT	Stock	346.9482	347.42	346.63	346.87	14520.0
2023-11-01 04:00:00	NVDA	Stock	40.72	40.72	40.45	40.462	46570.0
2023-11-01 05:00:00	NVDA	Stock	40.499	40.5	40.411	40.456	16890.0
2023-11-01 06:00:00	NVDA	Stock	40.45	40.561	40.448	40.56	21790.0
2023-11-01 07:00:00	NVDA	Stock	40.519	40.541	40.425	40.48	106390.0
2023-11-01 08:00:00	NVDA	Stock	40.523	40.89	40.421	40.714	1423050.0
2023-11-01 09:00:00	NVDA	Stock	40.7	41.579	40.6	41.228	44039150.0
2023-11-01 10:00:00	NVDA	Stock	41.25	41.95	41.074	41.9459	61007540.0
2023-11-01 11:00:00	NVDA	Stock	41.936	42.038	41.713	41.886	43533810.0
2023-11-01 12:00:00	NVDA	Stock	41.8882	41.93	41.564	41.6695	27841620.0
2023-11-01 13:00:00	NVDA	Stock	41.665	41.773	41.576	41.736	20624990.0
2023-11-01 14:00:00	NVDA	Stock	41.737	41.98	41.401	41.8184	52361950.0
2023-11-01 15:00:00	NVDA	Stock	41.824	42.381	41.808	42.31	68387620.0
2023-11-01 16:00:00	NVDA	Stock	42.325	42.98	42.265	42.661	23028130.0
2023-11-01 17:00:00	NVDA	Stock	42.66	42.772	42.642	42.7	812090.0
2023-11-01 18:00:00	NVDA	Stock	42.708	42.745	42.695	42.731	393960.0
2023-11-01 19:00:00	NVDA	Stock	42.733	42.973	42.725	42.9	671870.0
2023-11-01 04:00:00	AMZN	Stock	132.75	132.99	132.75	132.86	3247.0
2023-11-01 05:00:00	AMZN	Stock	132.86	132.86	132.66	132.66	4544.0

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

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