PREVIEW / stock_1hour / 2022-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-29.parquet
  size:    1.4 MB
  rows:    62,745
  symbols: 2,230

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-08-29 04:00:00	AAPL	Stock	161.98	162.04	160.3	161.24	62943.0
2022-08-29 05:00:00	AAPL	Stock	161.26	161.48	161.07	161.41	27388.0
2022-08-29 06:00:00	AAPL	Stock	161.41	161.8	161.39	161.57	26090.0
2022-08-29 07:00:00	AAPL	Stock	161.66	161.66	161.19	161.38	97379.0
2022-08-29 08:00:00	AAPL	Stock	161.5818	163.62	160.07	161.27	453442.0
2022-08-29 09:00:00	AAPL	Stock	161.3069	162.75	160.6	161.825	10561003.0
2022-08-29 10:00:00	AAPL	Stock	161.82	162.9	160.07	160.191	10274799.0
2022-08-29 11:00:00	AAPL	Stock	160.2	161.3	159.82	161.22	9410803.0
2022-08-29 12:00:00	AAPL	Stock	161.22	162.19	160.935	161.9399	6328765.0
2022-08-29 13:00:00	AAPL	Stock	161.94	162.61	161.57	162.085	5039276.0
2022-08-29 14:00:00	AAPL	Stock	162.09	162.27	161.56	161.975	4925702.0
2022-08-29 15:00:00	AAPL	Stock	161.98	162.54	161.12	161.37	8694008.0
2022-08-29 16:00:00	AAPL	Stock	161.38	161.45	161.06	161.45	5688423.0
2022-08-29 17:00:00	AAPL	Stock	161.46	161.49	161.13	161.35	35590.0
2022-08-29 18:00:00	AAPL	Stock	161.35	161.47	161.24	161.38	35152.0
2022-08-29 19:00:00	AAPL	Stock	161.37	161.8	161.32	161.79	36795.0
2022-08-29 04:00:00	MSFT	Stock	266.49	266.52	260.05	265.02	30480.0
2022-08-29 05:00:00	MSFT	Stock	265.02	265.53	264.78	265.0	2434.0
2022-08-29 06:00:00	MSFT	Stock	265.41	265.58	265.4	265.57	1369.0
2022-08-29 07:00:00	MSFT	Stock	265.26	265.43	265.0	265.2	13179.0
2022-08-29 08:00:00	MSFT	Stock	265.2507	267.42	265.0	265.72	44668.0
2022-08-29 09:00:00	MSFT	Stock	265.52	267.4	265.01	265.1888	1612113.0
2022-08-29 10:00:00	MSFT	Stock	265.17	266.59	264.23	264.3	1829755.0
2022-08-29 11:00:00	MSFT	Stock	264.29	265.34	263.85	265.12	1399684.0
2022-08-29 12:00:00	MSFT	Stock	265.16	266.605	264.72	266.03	889208.0
2022-08-29 13:00:00	MSFT	Stock	266.045	266.79	265.5	265.795	680196.0
2022-08-29 14:00:00	MSFT	Stock	265.79	265.9	264.71	265.4394	907496.0
2022-08-29 15:00:00	MSFT	Stock	265.42	266.5	264.86	265.26	3047078.0
2022-08-29 16:00:00	MSFT	Stock	265.23	265.5	265.0	265.32	2605247.0
2022-08-29 17:00:00	MSFT	Stock	265.35	265.44	265.21	265.32	4986.0
2022-08-29 18:00:00	MSFT	Stock	265.5	265.6	265.29	265.35	987.0
2022-08-29 19:00:00	MSFT	Stock	265.33	266.0	265.33	266.0	8500.0
2022-08-29 04:00:00	NVDA	Stock	16.19	16.22	15.981	16.001	423470.0
2022-08-29 05:00:00	NVDA	Stock	15.991	16.065	15.991	16.06	298530.0
2022-08-29 06:00:00	NVDA	Stock	16.058	16.069	16.01	16.012	89100.0
2022-08-29 07:00:00	NVDA	Stock	16.035	16.05	15.916	15.956	628550.0
2022-08-29 08:00:00	NVDA	Stock	16.02	16.26	15.915	15.97	1969690.0
2022-08-29 09:00:00	NVDA	Stock	15.97	16.338	15.955	16.133	71104590.0
2022-08-29 10:00:00	NVDA	Stock	16.132	16.173	15.843	15.855	79951800.0
2022-08-29 11:00:00	NVDA	Stock	15.851	15.9559	15.767	15.843	56383410.0
2022-08-29 12:00:00	NVDA	Stock	15.842	15.946	15.77	15.889	40359010.0
2022-08-29 13:00:00	NVDA	Stock	15.889	16.0439	15.862	15.998	37119030.0
2022-08-29 14:00:00	NVDA	Stock	15.9975	16.019	15.843	15.9004	32721600.0
2022-08-29 15:00:00	NVDA	Stock	15.9	15.989	15.772	15.797	59171940.0
2022-08-29 16:00:00	NVDA	Stock	15.796	15.803	15.749	15.794	16452750.0
2022-08-29 17:00:00	NVDA	Stock	15.7924	15.801	15.77	15.7862	304220.0
2022-08-29 18:00:00	NVDA	Stock	15.789	15.801	15.766	15.781	278060.0
2022-08-29 19:00:00	NVDA	Stock	15.78	15.884	15.771	15.803	406950.0
2022-08-29 04:00:00	AMZN	Stock	129.54	130.29	126.83	128.77	37198.0
2022-08-29 05:00:00	AMZN	Stock	128.56	129.11	128.51	129.04	16135.0

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

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