PREVIEW / stock_1hour / 2023-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-20.parquet
  size:    1.3 MB
  rows:    57,560
  symbols: 1,347

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-20 04:00:00	AAPL	Stock	174.95	175.32	174.56	175.14	9064.0
2023-10-20 05:00:00	AAPL	Stock	175.07	175.16	174.71	174.97	16335.0
2023-10-20 06:00:00	AAPL	Stock	174.93	174.93	174.7	174.72	2998.0
2023-10-20 07:00:00	AAPL	Stock	174.71	175.18	174.7	175.1	17381.0
2023-10-20 08:00:00	AAPL	Stock	174.77	175.2	174.49	174.68	55216.0
2023-10-20 09:00:00	AAPL	Stock	174.77	175.8	174.42	175.1016	8172748.0
2023-10-20 10:00:00	AAPL	Stock	175.105	175.32	173.34	173.365	6983125.0
2023-10-20 11:00:00	AAPL	Stock	173.36	173.68	172.64	173.64	6727383.0
2023-10-20 12:00:00	AAPL	Stock	173.65	174.36	173.4	174.315	4088868.0
2023-10-20 13:00:00	AAPL	Stock	174.32	174.72	173.8877	174.305	4612195.0
2023-10-20 14:00:00	AAPL	Stock	174.3	174.39	173.255	173.51	3783023.0
2023-10-20 15:00:00	AAPL	Stock	173.53	173.755	172.8	172.84	8005015.0
2023-10-20 16:00:00	AAPL	Stock	172.84	173.29	172.84	172.97	8820687.0
2023-10-20 17:00:00	AAPL	Stock	172.9406	172.99	172.86	172.87	51376.0
2023-10-20 18:00:00	AAPL	Stock	172.86	172.88	172.7	172.73	12323.0
2023-10-20 19:00:00	AAPL	Stock	172.76	172.8	172.64	172.78	16077.0
2023-10-20 04:00:00	MSFT	Stock	330.88	332.05	330.8	332.0	2623.0
2023-10-20 05:00:00	MSFT	Stock	332.0	332.0	330.96	330.96	1390.0
2023-10-20 06:00:00	MSFT	Stock	330.87	330.87	330.26	330.26	838.0
2023-10-20 07:00:00	MSFT	Stock	330.65	331.24	330.65	331.19	6784.0
2023-10-20 08:00:00	MSFT	Stock	330.61	331.39	330.15	330.75	36702.0
2023-10-20 09:00:00	MSFT	Stock	330.74	332.88	329.31	329.74	3745611.0
2023-10-20 10:00:00	MSFT	Stock	329.72	330.41	325.523	325.55	2642783.0
2023-10-20 11:00:00	MSFT	Stock	325.54	327.6	325.45	327.36	1755587.0
2023-10-20 12:00:00	MSFT	Stock	327.38	328.27	326.3509	328.25	1127816.0
2023-10-20 13:00:00	MSFT	Stock	328.26	328.76	327.25	328.54	1355413.0
2023-10-20 14:00:00	MSFT	Stock	328.53	328.71	326.76	327.2374	1013042.0
2023-10-20 15:00:00	MSFT	Stock	327.23	327.974	326.374	326.675	3134165.0
2023-10-20 16:00:00	MSFT	Stock	326.685	327.1	326.17	326.91	4300862.0
2023-10-20 17:00:00	MSFT	Stock	326.95	327.25	326.91	327.0986	13550.0
2023-10-20 18:00:00	MSFT	Stock	327.09	327.1	326.9007	327.0	4240.0
2023-10-20 19:00:00	MSFT	Stock	326.97	327.05	326.84	326.84	5091.0
2023-10-20 04:00:00	NVDA	Stock	41.701	42.325	41.701	42.278	209940.0
2023-10-20 05:00:00	NVDA	Stock	42.255	42.255	41.905	42.101	176170.0
2023-10-20 06:00:00	NVDA	Stock	42.087	42.087	41.95	42.049	59670.0
2023-10-20 07:00:00	NVDA	Stock	42.006	42.125	41.914	42.1	391120.0
2023-10-20 08:00:00	NVDA	Stock	42.08	42.128	41.601	41.65	2320890.0
2023-10-20 09:00:00	NVDA	Stock	41.669	42.47	41.666	42.2565	56421640.0
2023-10-20 10:00:00	NVDA	Stock	42.2526	42.41	41.081	41.111	79210690.0
2023-10-20 11:00:00	NVDA	Stock	41.102	41.489	41.078	41.3725	68336030.0
2023-10-20 12:00:00	NVDA	Stock	41.3735	41.639	41.201	41.639	37122810.0
2023-10-20 13:00:00	NVDA	Stock	41.639	41.875	41.47	41.755	41930630.0
2023-10-20 14:00:00	NVDA	Stock	41.75	41.797	41.4106	41.5475	34114430.0
2023-10-20 15:00:00	NVDA	Stock	41.55	41.632	41.356	41.374	39435220.0
2023-10-20 16:00:00	NVDA	Stock	41.377	41.59	41.202	41.25	16162550.0
2023-10-20 17:00:00	NVDA	Stock	41.26	41.267	41.152	41.19	304210.0
2023-10-20 18:00:00	NVDA	Stock	41.188	41.25	41.155	41.25	312470.0
2023-10-20 19:00:00	NVDA	Stock	41.26	41.264	41.18	41.21	309200.0
2023-10-20 04:00:00	AMZN	Stock	128.27	128.4	127.97	128.35	14981.0
2023-10-20 05:00:00	AMZN	Stock	128.33	128.4	128.07	128.26	1707.0

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

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