PREVIEW / stock_1hour / 2022-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-26.parquet
  size:    1.4 MB
  rows:    62,409
  symbols: 2,402

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-05-26 04:00:00	AAPL	Stock	140.53	140.53	138.25	138.28	118115.0
2022-05-26 05:00:00	AAPL	Stock	138.32	138.62	138.03	138.43	78664.0
2022-05-26 06:00:00	AAPL	Stock	138.41	139.09	138.3	138.9	42008.0
2022-05-26 07:00:00	AAPL	Stock	138.89	139.82	138.59	138.92	240730.0
2022-05-26 08:00:00	AAPL	Stock	138.7501	140.94	138.28	138.68	939986.0
2022-05-26 09:00:00	AAPL	Stock	138.65	140.97	137.14	140.615	11496753.0
2022-05-26 10:00:00	AAPL	Stock	140.64	141.97	140.36	141.8701	11523076.0
2022-05-26 11:00:00	AAPL	Stock	141.87	143.11	141.79	142.96	9564836.0
2022-05-26 12:00:00	AAPL	Stock	142.96	144.336	142.82	144.01	9015340.0
2022-05-26 13:00:00	AAPL	Stock	144.0	144.33	143.38	143.78	6439016.0
2022-05-26 14:00:00	AAPL	Stock	143.77	144.06	143.44	143.9001	5984521.0
2022-05-26 15:00:00	AAPL	Stock	143.9099	144.34	143.06	143.75	13679991.0
2022-05-26 16:00:00	AAPL	Stock	143.74	143.82	143.51	143.58	9981872.0
2022-05-26 17:00:00	AAPL	Stock	143.63	143.69	143.55	143.64	27175.0
2022-05-26 18:00:00	AAPL	Stock	143.62	143.97	143.6	143.8	37183.0
2022-05-26 19:00:00	AAPL	Stock	143.83	144.15	143.76	144.14	45647.0
2022-05-26 04:00:00	MSFT	Stock	263.31	263.31	261.38	261.38	4893.0
2022-05-26 05:00:00	MSFT	Stock	261.38	262.99	261.38	262.99	1588.0
2022-05-26 06:00:00	MSFT	Stock	262.75	264.0	262.75	264.0	1964.0
2022-05-26 07:00:00	MSFT	Stock	263.37	264.7	262.91	263.4	18735.0
2022-05-26 08:00:00	MSFT	Stock	263.75	264.9	261.0	263.7	49667.0
2022-05-26 09:00:00	MSFT	Stock	263.7	265.09	261.4294	264.545	2112842.0
2022-05-26 10:00:00	MSFT	Stock	264.5699	266.2	263.89	265.13	2537114.0
2022-05-26 11:00:00	MSFT	Stock	265.15	266.19	264.51	264.97	1710786.0
2022-05-26 12:00:00	MSFT	Stock	264.94	266.21	264.57	266.1	1560709.0
2022-05-26 13:00:00	MSFT	Stock	266.1	266.73	265.92	266.565	1249070.0
2022-05-26 14:00:00	MSFT	Stock	266.585	266.82	265.68	266.12	1505090.0
2022-05-26 15:00:00	MSFT	Stock	266.095	267.11	264.87	265.86	3665483.0
2022-05-26 16:00:00	MSFT	Stock	265.85	266.04	264.0	265.15	4259313.0
2022-05-26 17:00:00	MSFT	Stock	265.3182	265.39	265.2	265.3	3539.0
2022-05-26 18:00:00	MSFT	Stock	265.44	266.08	265.16	265.69	14677.0
2022-05-26 19:00:00	MSFT	Stock	265.58	266.1	265.5	266.0801	9208.0
2022-05-26 04:00:00	NVDA	Stock	15.963	16.125	15.88	15.914	1255350.0
2022-05-26 05:00:00	NVDA	Stock	15.904	16.154	15.9	16.013	386060.0
2022-05-26 06:00:00	NVDA	Stock	16.018	16.19	16.018	16.06	418480.0
2022-05-26 07:00:00	NVDA	Stock	16.062	16.371	15.928	16.35	4589500.0
2022-05-26 08:00:00	NVDA	Stock	16.0315	16.38	15.83	16.35	8321970.0
2022-05-26 09:00:00	NVDA	Stock	16.35	17.187	16.021	17.096	173354620.0
2022-05-26 10:00:00	NVDA	Stock	17.101	17.54	16.885	17.5	151798330.0
2022-05-26 11:00:00	NVDA	Stock	17.4972	17.731	17.48	17.713	104131840.0
2022-05-26 12:00:00	NVDA	Stock	17.716	17.995	17.656	17.941	97991800.0
2022-05-26 13:00:00	NVDA	Stock	17.9408	18.092	17.829	17.9517	77224610.0
2022-05-26 14:00:00	NVDA	Stock	17.9502	18.024	17.901	18.005	55044610.0
2022-05-26 15:00:00	NVDA	Stock	18.004	18.017	17.738	17.844	93448960.0
2022-05-26 16:00:00	NVDA	Stock	17.844	17.851	17.786	17.825	30115520.0
2022-05-26 17:00:00	NVDA	Stock	17.825	17.9	17.821	17.875	468160.0
2022-05-26 18:00:00	NVDA	Stock	17.875	17.928	17.865	17.872	318700.0
2022-05-26 19:00:00	NVDA	Stock	17.872	17.975	17.872	17.96	553450.0
2022-05-26 04:00:00	AMZN	Stock	107.15	107.2225	107.15	107.2225	4000.0
2022-05-26 07:00:00	AMZN	Stock	107.338	108.5	107.338	108.3425	49540.0

> showing 50 of 62,409 rows — these rows as CSV

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