PREVIEW / stock_1hour / 2023-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-19.parquet
  size:    1.3 MB
  rows:    57,717
  symbols: 1,340

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-19 04:00:00	AAPL	Stock	175.24	175.39	174.91	174.96	23219.0
2023-10-19 05:00:00	AAPL	Stock	174.91	175.55	174.91	175.55	10044.0
2023-10-19 06:00:00	AAPL	Stock	175.55	175.79	175.43	175.73	8792.0
2023-10-19 07:00:00	AAPL	Stock	175.71	175.75	175.19	175.3	36144.0
2023-10-19 08:00:00	AAPL	Stock	175.64	176.4	174.78	176.21	144012.0
2023-10-19 09:00:00	AAPL	Stock	176.17	176.855	175.77	176.8401	4700736.0
2023-10-19 10:00:00	AAPL	Stock	176.85	177.33	176.16	176.465	5621783.0
2023-10-19 11:00:00	AAPL	Stock	176.46	176.72	175.635	176.48	4460154.0
2023-10-19 12:00:00	AAPL	Stock	176.4724	177.762	175.46	177.0561	8069004.0
2023-10-19 13:00:00	AAPL	Stock	177.06	177.84	176.56	176.78	4821621.0
2023-10-19 14:00:00	AAPL	Stock	176.76	177.02	175.52	175.62	4187365.0
2023-10-19 15:00:00	AAPL	Stock	175.6251	176.06	175.19	175.45	7251443.0
2023-10-19 16:00:00	AAPL	Stock	175.45	175.46	174.91	175.26	7794888.0
2023-10-19 17:00:00	AAPL	Stock	175.24	175.46	175.01	175.04	52567.0
2023-10-19 18:00:00	AAPL	Stock	175.03	175.16	174.97	174.97	19705.0
2023-10-19 19:00:00	AAPL	Stock	174.9	175.0	174.75	174.85	27798.0
2023-10-19 04:00:00	MSFT	Stock	329.9	331.24	329.59	331.2	10904.0
2023-10-19 05:00:00	MSFT	Stock	331.75	332.54	331.75	332.54	1563.0
2023-10-19 06:00:00	MSFT	Stock	332.33	333.25	332.33	332.79	16404.0
2023-10-19 07:00:00	MSFT	Stock	332.88	332.88	331.7	331.95	17918.0
2023-10-19 08:00:00	MSFT	Stock	332.45	333.9	330.0	333.5	67585.0
2023-10-19 09:00:00	MSFT	Stock	333.68	334.8	332.03	334.005	2480275.0
2023-10-19 10:00:00	MSFT	Stock	334.05	334.77	332.19	333.375	2295184.0
2023-10-19 11:00:00	MSFT	Stock	333.4355	334.735	332.09	334.3355	1502203.0
2023-10-19 12:00:00	MSFT	Stock	334.36	336.88	332.24	334.9	2883275.0
2023-10-19 13:00:00	MSFT	Stock	335.04	336.63	333.01	333.93	2072089.0
2023-10-19 14:00:00	MSFT	Stock	333.93	334.6399	331.85	332.05	1562184.0
2023-10-19 15:00:00	MSFT	Stock	332.07	332.77	330.91	331.31	3069198.0
2023-10-19 16:00:00	MSFT	Stock	331.32	331.75	330.06	330.8121	3061218.0
2023-10-19 17:00:00	MSFT	Stock	330.8522	330.98	330.25	330.75	9728.0
2023-10-19 18:00:00	MSFT	Stock	330.87	330.96	330.24	330.24	5220.0
2023-10-19 19:00:00	MSFT	Stock	330.25	330.4	330.05	330.21	12274.0
2023-10-19 04:00:00	NVDA	Stock	42.0	42.151	41.9	42.053	206840.0
2023-10-19 05:00:00	NVDA	Stock	42.011	42.212	42.01	42.212	50050.0
2023-10-19 06:00:00	NVDA	Stock	42.249	42.693	42.247	42.592	376010.0
2023-10-19 07:00:00	NVDA	Stock	42.578	42.588	42.35	42.573	874810.0
2023-10-19 08:00:00	NVDA	Stock	42.5	42.817	41.839	42.76	3148390.0
2023-10-19 09:00:00	NVDA	Stock	42.75	43.027	42.242	42.7435	67282930.0
2023-10-19 10:00:00	NVDA	Stock	42.738	43.297	42.561	42.8395	65559420.0
2023-10-19 11:00:00	NVDA	Stock	42.8484	43.04	42.541	42.838	37326980.0
2023-10-19 12:00:00	NVDA	Stock	42.847	43.154	42.409	42.645	61866760.0
2023-10-19 13:00:00	NVDA	Stock	42.645	42.869	42.348	42.485	34637150.0
2023-10-19 14:00:00	NVDA	Stock	42.461	42.548	41.882	42.03	45236960.0
2023-10-19 15:00:00	NVDA	Stock	42.026	42.3	41.985	42.086	48475260.0
2023-10-19 16:00:00	NVDA	Stock	42.084	42.118	41.85	41.851	16549680.0
2023-10-19 17:00:00	NVDA	Stock	41.8502	41.8776	41.703	41.733	536530.0
2023-10-19 18:00:00	NVDA	Stock	41.74	41.78	41.605	41.67	865770.0
2023-10-19 19:00:00	NVDA	Stock	41.683	41.755	41.65	41.71	606950.0
2023-10-19 04:00:00	AMZN	Stock	128.0	128.3	127.88	128.3	10374.0
2023-10-19 05:00:00	AMZN	Stock	128.13	128.93	128.13	128.89	12933.0

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

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