PREVIEW / stock_1hour / 2022-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-05.parquet
  size:    1.4 MB
  rows:    63,991
  symbols: 2,489

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-04-05 04:00:00	AAPL	Stock	178.66	178.66	178.24	178.25	23686.0
2022-04-05 05:00:00	AAPL	Stock	178.13	178.13	177.71	177.75	20949.0
2022-04-05 06:00:00	AAPL	Stock	177.7	178.1	177.7	178.05	22185.0
2022-04-05 07:00:00	AAPL	Stock	178.05	178.42	177.84	178.36	71042.0
2022-04-05 08:00:00	AAPL	Stock	177.9534	178.5	177.36	177.96	417774.0
2022-04-05 09:00:00	AAPL	Stock	177.96	178.3	177.05	177.63	9201916.0
2022-04-05 10:00:00	AAPL	Stock	177.63	178.13	176.21	176.89	11207408.0
2022-04-05 11:00:00	AAPL	Stock	176.89	177.11	175.68	175.69	6960608.0
2022-04-05 12:00:00	AAPL	Stock	175.69	175.965	175.0	175.555	6521797.0
2022-04-05 13:00:00	AAPL	Stock	175.56	176.12	174.93	175.245	5725675.0
2022-04-05 14:00:00	AAPL	Stock	175.24	175.75	174.99	175.055	4841420.0
2022-04-05 15:00:00	AAPL	Stock	175.06	175.22	174.415	175.04	10989062.0
2022-04-05 16:00:00	AAPL	Stock	175.09	175.5	174.94	175.33	6782188.0
2022-04-05 17:00:00	AAPL	Stock	175.29	175.34	175.15	175.17	27271.0
2022-04-05 18:00:00	AAPL	Stock	175.22	175.22	174.91	175.11	59609.0
2022-04-05 19:00:00	AAPL	Stock	175.11	175.15	174.88	175.0	28522.0
2022-04-05 04:00:00	MSFT	Stock	316.19	316.19	315.04	315.04	3740.0
2022-04-05 05:00:00	MSFT	Stock	315.13	315.13	314.27	314.37	2884.0
2022-04-05 06:00:00	MSFT	Stock	314.87	315.08	314.03	314.25	3417.0
2022-04-05 07:00:00	MSFT	Stock	314.76	315.01	314.52	314.69	6729.0
2022-04-05 08:00:00	MSFT	Stock	314.5001	315.5	313.8	313.98	25440.0
2022-04-05 09:00:00	MSFT	Stock	313.94	314.865	312.09	313.08	2169105.0
2022-04-05 10:00:00	MSFT	Stock	313.06	314.17	311.7	313.0	2307069.0
2022-04-05 11:00:00	MSFT	Stock	312.992	313.19	311.55	311.87	1637975.0
2022-04-05 12:00:00	MSFT	Stock	311.89	312.1723	310.56	311.78	1509749.0
2022-04-05 13:00:00	MSFT	Stock	311.79	312.74	311.06	311.55	1265438.0
2022-04-05 14:00:00	MSFT	Stock	311.545	312.55	311.31	311.905	1283446.0
2022-04-05 15:00:00	MSFT	Stock	311.91	312.17	309.87	311.01	4014621.0
2022-04-05 16:00:00	MSFT	Stock	311.01	311.47	310.85	311.4	3600456.0
2022-04-05 17:00:00	MSFT	Stock	311.4	311.4	311.01	311.16	5569.0
2022-04-05 18:00:00	MSFT	Stock	311.35	311.4	310.73	311.01	18591.0
2022-04-05 19:00:00	MSFT	Stock	311.05	311.33	310.75	311.0	5380.0
2022-04-05 04:00:00	NVDA	Stock	27.46	27.542	27.42	27.45	69450.0
2022-04-05 05:00:00	NVDA	Stock	27.445	27.445	27.361	27.381	45660.0
2022-04-05 06:00:00	NVDA	Stock	27.336	27.336	27.24	27.328	39100.0
2022-04-05 07:00:00	NVDA	Stock	27.3	27.33	27.25	27.29	119160.0
2022-04-05 08:00:00	NVDA	Stock	27.2605	27.447	27.2	27.24	776370.0
2022-04-05 09:00:00	NVDA	Stock	27.223	27.3337	26.771	26.816	34405640.0
2022-04-05 10:00:00	NVDA	Stock	26.804	26.846	26.275	26.349	61397630.0
2022-04-05 11:00:00	NVDA	Stock	26.346	26.473	26.206	26.264	35087290.0
2022-04-05 12:00:00	NVDA	Stock	26.262	26.4	26.051	26.225	33367150.0
2022-04-05 13:00:00	NVDA	Stock	26.225	26.365	25.893	26.064	35346900.0
2022-04-05 14:00:00	NVDA	Stock	26.063	26.273	25.978	26.108	37209780.0
2022-04-05 15:00:00	NVDA	Stock	26.104	26.13	25.82	25.932	55888460.0
2022-04-05 16:00:00	NVDA	Stock	25.932	25.968	25.903	25.965	20311500.0
2022-04-05 17:00:00	NVDA	Stock	25.959	25.9629	25.933	25.936	254150.0
2022-04-05 18:00:00	NVDA	Stock	25.948	25.948	25.864	25.88	183040.0
2022-04-05 19:00:00	NVDA	Stock	25.875	25.888	25.821	25.85	318320.0
2022-04-05 04:00:00	AMZN	Stock	168.65	168.65	168.65	168.65	2020.0
2022-04-05 06:00:00	AMZN	Stock	167.8	167.8	167.8	167.8	2000.0

> showing 50 of 63,991 rows — these rows as CSV

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