PREVIEW / stock_1hour / 2022-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-01.parquet
  size:    1.4 MB
  rows:    64,817
  symbols: 2,634

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-01 04:00:00	AAPL	Stock	174.5	175.38	174.02	174.5	36242.0
2022-02-01 05:00:00	AAPL	Stock	174.17	174.69	174.1	174.25	19880.0
2022-02-01 06:00:00	AAPL	Stock	174.37	174.48	174.02	174.26	21797.0
2022-02-01 07:00:00	AAPL	Stock	174.22	175.23	174.2	175.05	177302.0
2022-02-01 08:00:00	AAPL	Stock	174.4999	175.31	174.34	174.94	508804.0
2022-02-01 09:00:00	AAPL	Stock	174.94	174.97	172.31	173.3088	11816758.0
2022-02-01 10:00:00	AAPL	Stock	173.28	173.75	172.35	173.74	10469362.0
2022-02-01 11:00:00	AAPL	Stock	173.73	174.435	173.5	174.21	8250936.0
2022-02-01 12:00:00	AAPL	Stock	174.205	174.2599	172.98	173.39	6055239.0
2022-02-01 13:00:00	AAPL	Stock	173.38	173.38	172.58	173.073	4759063.0
2022-02-01 14:00:00	AAPL	Stock	173.08	173.33	172.51	173.17	5246887.0
2022-02-01 15:00:00	AAPL	Stock	173.1712	174.84	173.1099	174.61	12152898.0
2022-02-01 16:00:00	AAPL	Stock	174.58	174.98	173.97	174.5901	7654472.0
2022-02-01 17:00:00	AAPL	Stock	174.59	174.61	174.25	174.31	122301.0
2022-02-01 18:00:00	AAPL	Stock	174.32	174.32	173.95	174.3	67742.0
2022-02-01 19:00:00	AAPL	Stock	174.28	174.59	174.12	174.45	71508.0
2022-02-01 04:00:00	MSFT	Stock	311.79	311.92	310.0	310.49	6404.0
2022-02-01 05:00:00	MSFT	Stock	310.64	311.09	309.91	310.3	2591.0
2022-02-01 06:00:00	MSFT	Stock	310.48	310.76	309.7	309.95	5130.0
2022-02-01 07:00:00	MSFT	Stock	309.99	311.0	309.25	310.8	29595.0
2022-02-01 08:00:00	MSFT	Stock	310.6158	311.757	309.74	310.75	47159.0
2022-02-01 09:00:00	MSFT	Stock	310.75	311.2	306.0301	307.06	3864665.0
2022-02-01 10:00:00	MSFT	Stock	307.15	307.82	305.31	307.0739	4955140.0
2022-02-01 11:00:00	MSFT	Stock	307.05	308.7048	306.61	308.355	3954483.0
2022-02-01 12:00:00	MSFT	Stock	308.37	308.54	305.88	306.7	2384571.0
2022-02-01 13:00:00	MSFT	Stock	306.7	306.81	305.7	306.14	1867706.0
2022-02-01 14:00:00	MSFT	Stock	306.16	306.49	305.1293	306.095	2314663.0
2022-02-01 15:00:00	MSFT	Stock	306.06	309.24	305.89	308.55	5142123.0
2022-02-01 16:00:00	MSFT	Stock	308.76	310.5	306.72	308.95	4300295.0
2022-02-01 17:00:00	MSFT	Stock	308.95	308.95	308.2	308.33	41968.0
2022-02-01 18:00:00	MSFT	Stock	308.46	308.5	307.65	308.4	29764.0
2022-02-01 19:00:00	MSFT	Stock	308.35	308.79	308.25	308.55	23544.0
2022-02-01 04:00:00	NVDA	Stock	25.1	25.1	24.67	24.8	361870.0
2022-02-01 05:00:00	NVDA	Stock	24.8	24.959	24.8	24.826	140040.0
2022-02-01 06:00:00	NVDA	Stock	24.869	24.91	24.747	24.8	79570.0
2022-02-01 07:00:00	NVDA	Stock	24.788	25.184	24.773	25.112	910250.0
2022-02-01 08:00:00	NVDA	Stock	24.9	25.324	24.774	25.278	2405800.0
2022-02-01 09:00:00	NVDA	Stock	25.3	25.345	24.132	24.411	81058130.0
2022-02-01 10:00:00	NVDA	Stock	24.411	24.43	23.89	24.282	89426380.0
2022-02-01 11:00:00	NVDA	Stock	24.271	24.598	24.238	24.532	53985880.0
2022-02-01 12:00:00	NVDA	Stock	24.532	24.546	24.18	24.4	32830020.0
2022-02-01 13:00:00	NVDA	Stock	24.397	24.429	24.134	24.2084	21128220.0
2022-02-01 14:00:00	NVDA	Stock	24.21	24.281	23.985	24.2242	27054370.0
2022-02-01 15:00:00	NVDA	Stock	24.222	24.69	24.19	24.639	54711820.0
2022-02-01 16:00:00	NVDA	Stock	24.638	25.866	24.5	25.775	24802860.0
2022-02-01 17:00:00	NVDA	Stock	25.78	26.094	24.638	25.879	2232650.0
2022-02-01 18:00:00	NVDA	Stock	25.86	25.896	25.6	25.745	1071530.0
2022-02-01 19:00:00	NVDA	Stock	25.749	25.82	25.685	25.81	670090.0
2022-02-01 04:00:00	AMZN	Stock	149.85	150.155	149.75	149.75	15160.0
2022-02-01 05:00:00	AMZN	Stock	149.9065	149.9065	149.9065	149.9065	2000.0

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

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