PREVIEW / stock_1hour / 2022-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-10.parquet
  size:    1.4 MB
  rows:    64,809
  symbols: 2,555

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
2022-02-10 04:00:00	AAPL	Stock	175.75	175.75	175.39	175.68	10955.0
2022-02-10 05:00:00	AAPL	Stock	175.65	175.68	175.55	175.55	1974.0
2022-02-10 06:00:00	AAPL	Stock	175.52	175.6	175.5	175.51	7193.0
2022-02-10 07:00:00	AAPL	Stock	175.6	175.99	175.6	175.94	46290.0
2022-02-10 08:00:00	AAPL	Stock	175.97	176.27	174.0	174.25	706200.0
2022-02-10 09:00:00	AAPL	Stock	174.25	175.3899	173.75	175.08	10061365.0
2022-02-10 10:00:00	AAPL	Stock	175.09	175.48	174.28	174.405	9802998.0
2022-02-10 11:00:00	AAPL	Stock	174.415	175.01	173.79	174.8475	8622090.0
2022-02-10 12:00:00	AAPL	Stock	174.8501	175.06	173.32	174.1	7599492.0
2022-02-10 13:00:00	AAPL	Stock	174.09	174.52	172.37	173.44	7999172.0
2022-02-10 14:00:00	AAPL	Stock	173.43	173.58	172.52	172.83	7263268.0
2022-02-10 15:00:00	AAPL	Stock	172.83	173.14	171.55	172.295	12972872.0
2022-02-10 16:00:00	AAPL	Stock	172.12	172.43	171.81	172.22	11749814.0
2022-02-10 17:00:00	AAPL	Stock	172.22	172.26	172.02	172.19	38328.0
2022-02-10 18:00:00	AAPL	Stock	172.19	172.37	171.82	171.82	159993.0
2022-02-10 19:00:00	AAPL	Stock	171.83	171.98	171.5	171.79	89705.0
2022-02-10 04:00:00	MSFT	Stock	309.2	309.9	309.16	309.5	2734.0
2022-02-10 05:00:00	MSFT	Stock	309.88	310.21	309.8	310.2	1095.0
2022-02-10 06:00:00	MSFT	Stock	310.01	310.01	309.29	309.3	1450.0
2022-02-10 07:00:00	MSFT	Stock	309.77	310.56	309.61	310.49	10624.0
2022-02-10 08:00:00	MSFT	Stock	310.2577	311.81	306.67	306.71	128437.0
2022-02-10 09:00:00	MSFT	Stock	306.7	307.75	303.33	307.35	3928673.0
2022-02-10 10:00:00	MSFT	Stock	307.45	309.12	305.83	306.21	5079703.0
2022-02-10 11:00:00	MSFT	Stock	306.22	306.65	304.0536	305.845	3766940.0
2022-02-10 12:00:00	MSFT	Stock	305.861	307.05	303.03	304.31	2795701.0
2022-02-10 13:00:00	MSFT	Stock	304.29	304.8	301.5	303.15	3246204.0
2022-02-10 14:00:00	MSFT	Stock	303.13	303.54	301.57	302.24	2542739.0
2022-02-10 15:00:00	MSFT	Stock	302.24	303.29	300.7	302.39	4956740.0
2022-02-10 16:00:00	MSFT	Stock	302.39	303.2	301.5	302.25	5976137.0
2022-02-10 17:00:00	MSFT	Stock	302.27	302.4	301.99	301.99	16051.0
2022-02-10 18:00:00	MSFT	Stock	302.15	302.38	301.39	301.39	68647.0
2022-02-10 19:00:00	MSFT	Stock	301.39	301.79	300.81	301.0	39447.0
2022-02-10 04:00:00	NVDA	Stock	26.573	26.573	26.351	26.5	96940.0
2022-02-10 05:00:00	NVDA	Stock	26.5	26.64	26.48	26.6	147150.0
2022-02-10 06:00:00	NVDA	Stock	26.615	26.615	26.503	26.55	31300.0
2022-02-10 07:00:00	NVDA	Stock	26.535	26.687	26.527	26.61	339590.0
2022-02-10 08:00:00	NVDA	Stock	26.64	26.88	25.904	26.001	5221060.0
2022-02-10 09:00:00	NVDA	Stock	26.001	26.518	25.85	26.3978	56182860.0
2022-02-10 10:00:00	NVDA	Stock	26.3979	26.925	26.3461	26.5222	69736660.0
2022-02-10 11:00:00	NVDA	Stock	26.513	26.762	26.3045	26.752	53486950.0
2022-02-10 12:00:00	NVDA	Stock	26.76	26.837	26.307	26.552	37089460.0
2022-02-10 13:00:00	NVDA	Stock	26.548	26.674	25.962	26.3485	45685670.0
2022-02-10 14:00:00	NVDA	Stock	26.346	26.355	25.996	26.032	31588620.0
2022-02-10 15:00:00	NVDA	Stock	26.027	26.11	25.6	25.835	52487630.0
2022-02-10 16:00:00	NVDA	Stock	25.8265	25.864	25.71	25.785	21486710.0
2022-02-10 17:00:00	NVDA	Stock	25.767	25.815	25.7	25.815	227700.0
2022-02-10 18:00:00	NVDA	Stock	25.815	25.824	25.67	25.7	521120.0
2022-02-10 19:00:00	NVDA	Stock	25.675	25.7	25.53	25.58	573700.0
2022-02-10 06:00:00	AMZN	Stock	160.9	160.9	160.9	160.9	2000.0
2022-02-10 08:00:00	AMZN	Stock	161.15	161.1875	159.0	159.35	128360.0

> showing 50 of 64,809 rows — these rows as CSV

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