PREVIEW / stock_1hour / 2023-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-13.parquet
  size:    1.4 MB
  rows:    60,789
  symbols: 1,864

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
2023-02-13 04:00:00	AAPL	Stock	150.78	151.03	150.43	150.62	19191.0
2023-02-13 05:00:00	AAPL	Stock	150.59	150.89	150.57	150.82	17113.0
2023-02-13 06:00:00	AAPL	Stock	150.88	150.96	150.74	150.92	11879.0
2023-02-13 07:00:00	AAPL	Stock	150.98	151.7	150.98	151.38	57190.0
2023-02-13 08:00:00	AAPL	Stock	151.07	151.69	149.98	151.05	207882.0
2023-02-13 09:00:00	AAPL	Stock	151.05	152.19	150.7506	152.1807	5301096.0
2023-02-13 10:00:00	AAPL	Stock	152.19	152.785	151.8675	152.62	6583393.0
2023-02-13 11:00:00	AAPL	Stock	152.64	153.69	152.64	153.42	6975681.0
2023-02-13 12:00:00	AAPL	Stock	153.44	154.26	153.41	153.805	6009852.0
2023-02-13 13:00:00	AAPL	Stock	153.805	154.17	153.47	153.98	4554262.0
2023-02-13 14:00:00	AAPL	Stock	153.98	154.02	152.76	153.07	4410433.0
2023-02-13 15:00:00	AAPL	Stock	153.07	153.98	152.76	153.84	9338853.0
2023-02-13 16:00:00	AAPL	Stock	153.84	153.85	153.66	153.71	9963936.0
2023-02-13 17:00:00	AAPL	Stock	153.74	153.89	153.71	153.8	198112.0
2023-02-13 18:00:00	AAPL	Stock	153.83	153.84	153.63	153.71	19666.0
2023-02-13 19:00:00	AAPL	Stock	153.7	153.7	153.6	153.7	46776.0
2023-02-13 04:00:00	MSFT	Stock	264.63	265.78	264.63	265.39	28375.0
2023-02-13 05:00:00	MSFT	Stock	265.35	266.38	265.04	266.38	12186.0
2023-02-13 06:00:00	MSFT	Stock	266.34	266.68	265.96	266.3	12729.0
2023-02-13 07:00:00	MSFT	Stock	266.4	267.35	266.1	266.42	47609.0
2023-02-13 08:00:00	MSFT	Stock	266.6	267.45	262.443	266.105	123268.0
2023-02-13 09:00:00	MSFT	Stock	266.06	272.61	266.0	272.49	6401497.0
2023-02-13 10:00:00	MSFT	Stock	272.49	273.0	270.89	271.67	6048759.0
2023-02-13 11:00:00	MSFT	Stock	271.68	274.6	271.68	273.655	5052640.0
2023-02-13 12:00:00	MSFT	Stock	273.65	273.84	271.79	272.33	3333152.0
2023-02-13 13:00:00	MSFT	Stock	272.31	272.52	271.16	272.22	2739969.0
2023-02-13 14:00:00	MSFT	Stock	272.194	272.25	270.22	271.204	2948740.0
2023-02-13 15:00:00	MSFT	Stock	271.2	271.57	270.43	271.31	4693973.0
2023-02-13 16:00:00	MSFT	Stock	271.31	271.74	271.0	271.56	4392532.0
2023-02-13 17:00:00	MSFT	Stock	271.5	271.6	271.35	271.35	32542.0
2023-02-13 18:00:00	MSFT	Stock	271.35	271.44	271.25	271.38	19386.0
2023-02-13 19:00:00	MSFT	Stock	271.36	272.24	271.17	272.24	52243.0
2023-02-13 04:00:00	NVDA	Stock	21.374	21.5	21.36	21.419	428660.0
2023-02-13 05:00:00	NVDA	Stock	21.43	21.542	21.43	21.54	138340.0
2023-02-13 06:00:00	NVDA	Stock	21.537	21.572	21.47	21.502	149320.0
2023-02-13 07:00:00	NVDA	Stock	21.485	21.595	21.485	21.55	597280.0
2023-02-13 08:00:00	NVDA	Stock	21.512	21.59	21.06	21.362	1577740.0
2023-02-13 09:00:00	NVDA	Stock	21.368	21.625	20.962	21.613	63383430.0
2023-02-13 10:00:00	NVDA	Stock	21.612	21.74	21.289	21.638	69085380.0
2023-02-13 11:00:00	NVDA	Stock	21.639	21.9799	21.6309	21.906	61923940.0
2023-02-13 12:00:00	NVDA	Stock	21.903	21.97	21.827	21.8855	38381490.0
2023-02-13 13:00:00	NVDA	Stock	21.8844	22.048	21.834	21.8971	39652910.0
2023-02-13 14:00:00	NVDA	Stock	21.897	21.926	21.664	21.8116	42640970.0
2023-02-13 15:00:00	NVDA	Stock	21.8108	21.875	21.636	21.791	51691360.0
2023-02-13 16:00:00	NVDA	Stock	21.788	21.821	21.771	21.816	28772620.0
2023-02-13 17:00:00	NVDA	Stock	21.816	21.8361	21.788	21.815	357240.0
2023-02-13 18:00:00	NVDA	Stock	21.811	21.837	21.79	21.82	262670.0
2023-02-13 19:00:00	NVDA	Stock	21.82	21.838	21.815	21.82	366020.0
2023-02-13 04:00:00	AMZN	Stock	97.61	97.73	97.5	97.58	14170.0
2023-02-13 05:00:00	AMZN	Stock	97.66	97.85	97.6	97.82	3017.0

> showing 50 of 60,789 rows — these rows as CSV

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