PREVIEW / stock_1hour / 2022-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-20.parquet
  size:    1.5 MB
  rows:    66,063
  symbols: 2,621

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-01-20 04:00:00	AAPL	Stock	166.53	167.15	166.2	167.05	38664.0
2022-01-20 05:00:00	AAPL	Stock	167.01	167.12	166.8	166.88	14297.0
2022-01-20 06:00:00	AAPL	Stock	167.1	167.47	167.1	167.22	17753.0
2022-01-20 07:00:00	AAPL	Stock	167.16	167.3	166.41	166.88	135073.0
2022-01-20 08:00:00	AAPL	Stock	167.2501	167.35	165.815	167.14	693792.0
2022-01-20 09:00:00	AAPL	Stock	167.14	168.92	166.76	168.88	9668460.0
2022-01-20 10:00:00	AAPL	Stock	168.87	169.68	168.47	169.229	10089978.0
2022-01-20 11:00:00	AAPL	Stock	169.23	169.5498	168.78	169.11	6890155.0
2022-01-20 12:00:00	AAPL	Stock	169.11	169.25	168.495	168.645	4838356.0
2022-01-20 13:00:00	AAPL	Stock	168.64	168.64	167.15	167.4167	7127560.0
2022-01-20 14:00:00	AAPL	Stock	167.4388	167.91	166.32	166.66	8646037.0
2022-01-20 15:00:00	AAPL	Stock	166.66	166.97	164.18	164.52	17741086.0
2022-01-20 16:00:00	AAPL	Stock	164.53	167.4329	162.25	163.4	8494060.0
2022-01-20 17:00:00	AAPL	Stock	163.38	164.51	162.69	162.8	801136.0
2022-01-20 18:00:00	AAPL	Stock	162.79	163.83	162.65	163.49	193928.0
2022-01-20 19:00:00	AAPL	Stock	163.49	163.83	162.95	163.05	89279.0
2022-01-20 04:00:00	MSFT	Stock	305.93	306.5	305.29	306.36	8727.0
2022-01-20 05:00:00	MSFT	Stock	306.55	307.0	305.99	307.0	14625.0
2022-01-20 06:00:00	MSFT	Stock	307.22	307.82	307.08	307.5	9461.0
2022-01-20 07:00:00	MSFT	Stock	307.69	307.9	306.79	307.9	43292.0
2022-01-20 08:00:00	MSFT	Stock	306.93	309.89	304.088	309.28	136223.0
2022-01-20 09:00:00	MSFT	Stock	309.2	311.48	307.45	311.03	4101597.0
2022-01-20 10:00:00	MSFT	Stock	311.08	311.6494	309.08	309.96	3722423.0
2022-01-20 11:00:00	MSFT	Stock	309.95	311.34	309.85	310.68	2293178.0
2022-01-20 12:00:00	MSFT	Stock	310.71	311.16	309.35	309.635	1747126.0
2022-01-20 13:00:00	MSFT	Stock	309.6397	309.6626	307.67	307.71	1940461.0
2022-01-20 14:00:00	MSFT	Stock	307.75	309.02	305.85	306.03	2095216.0
2022-01-20 15:00:00	MSFT	Stock	306.03	306.7172	301.14	301.64	5351582.0
2022-01-20 16:00:00	MSFT	Stock	301.54	301.66	299.01	301.3	3924137.0
2022-01-20 17:00:00	MSFT	Stock	301.3	302.78	300.0	301.95	126211.0
2022-01-20 18:00:00	MSFT	Stock	301.93	302.85	301.0	302.5	65716.0
2022-01-20 19:00:00	MSFT	Stock	302.5	302.9	301.65	302.0	46742.0
2022-01-20 04:00:00	NVDA	Stock	25.2	25.328	25.177	25.31	266550.0
2022-01-20 05:00:00	NVDA	Stock	25.265	25.33	25.25	25.296	51000.0
2022-01-20 06:00:00	NVDA	Stock	25.311	25.398	25.311	25.319	52710.0
2022-01-20 07:00:00	NVDA	Stock	25.344	25.378	25.2	25.285	534510.0
2022-01-20 08:00:00	NVDA	Stock	25.3602	25.42	25.2	25.35	1176900.0
2022-01-20 09:00:00	NVDA	Stock	25.35	25.48	25.06	25.315	44253180.0
2022-01-20 10:00:00	NVDA	Stock	25.314	25.537	25.0361	25.421	53470280.0
2022-01-20 11:00:00	NVDA	Stock	25.415	25.579	25.21	25.311	33296740.0
2022-01-20 12:00:00	NVDA	Stock	25.314	25.442	25.243	25.318	20658740.0
2022-01-20 13:00:00	NVDA	Stock	25.3138	25.349	25.169	25.1888	18933860.0
2022-01-20 14:00:00	NVDA	Stock	25.1932	25.369	24.887	24.931	31789900.0
2022-01-20 15:00:00	NVDA	Stock	24.937	25.023	24.078	24.152	85928450.0
2022-01-20 16:00:00	NVDA	Stock	24.15	25.1095	23.5	23.79	16760370.0
2022-01-20 17:00:00	NVDA	Stock	23.785	23.83	23.562	23.633	1201810.0
2022-01-20 18:00:00	NVDA	Stock	23.625	23.711	23.55	23.678	1586020.0
2022-01-20 19:00:00	NVDA	Stock	23.655	23.7	23.56	23.6	674110.0
2022-01-20 06:00:00	AMZN	Stock	157.2	157.4775	157.2	157.4485	16400.0
2022-01-20 07:00:00	AMZN	Stock	157.105	157.125	156.945	156.945	10000.0

> showing 50 of 66,063 rows — these rows as CSV

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