PREVIEW / stock_1hour / 2022-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-04.parquet
  size:    1.4 MB
  rows:    63,609
  symbols: 2,515

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-03-04 04:00:00	AAPL	Stock	163.72	165.24	163.72	164.4	32362.0
2022-03-04 05:00:00	AAPL	Stock	164.3	165.0	164.3	164.71	10651.0
2022-03-04 06:00:00	AAPL	Stock	164.56	164.94	164.31	164.8	16254.0
2022-03-04 07:00:00	AAPL	Stock	164.61	164.88	164.08	164.72	123014.0
2022-03-04 08:00:00	AAPL	Stock	164.5001	165.9	164.12	164.89	799787.0
2022-03-04 09:00:00	AAPL	Stock	164.9	165.55	163.88	165.0399	8280737.0
2022-03-04 10:00:00	AAPL	Stock	165.04	165.3101	162.22	162.5801	12087674.0
2022-03-04 11:00:00	AAPL	Stock	162.59	163.16	162.1	162.76	8429424.0
2022-03-04 12:00:00	AAPL	Stock	162.76	163.95	162.49	163.6948	8593952.0
2022-03-04 13:00:00	AAPL	Stock	163.7	164.465	163.032	163.12	6817314.0
2022-03-04 14:00:00	AAPL	Stock	163.12	163.73	162.52	162.62	6851374.0
2022-03-04 15:00:00	AAPL	Stock	162.611	163.53	162.13	163.22	12691315.0
2022-03-04 16:00:00	AAPL	Stock	163.22	164.07	162.87	163.0622	8096867.0
2022-03-04 17:00:00	AAPL	Stock	162.99	163.2399	162.92	163.05	34598.0
2022-03-04 18:00:00	AAPL	Stock	163.05	163.16	163.0	163.05	26870.0
2022-03-04 19:00:00	AAPL	Stock	163.05	163.05	162.91	162.97	43601.0
2022-03-04 04:00:00	MSFT	Stock	293.23	294.39	293.07	293.71	7378.0
2022-03-04 05:00:00	MSFT	Stock	294.2	294.58	293.45	293.52	4696.0
2022-03-04 06:00:00	MSFT	Stock	293.91	293.91	293.2	293.81	2357.0
2022-03-04 07:00:00	MSFT	Stock	293.13	294.0	292.78	293.74	13250.0
2022-03-04 08:00:00	MSFT	Stock	293.99	294.71	292.6412	293.01	45947.0
2022-03-04 09:00:00	MSFT	Stock	293.38	295.66	289.6401	292.18	2829043.0
2022-03-04 10:00:00	MSFT	Stock	292.15	292.8155	289.21	289.54	2871960.0
2022-03-04 11:00:00	MSFT	Stock	289.55	289.74	287.165	288.9	2608521.0
2022-03-04 12:00:00	MSFT	Stock	288.91	291.93	288.63	290.8001	2460950.0
2022-03-04 13:00:00	MSFT	Stock	290.83	292.535	289.04	289.16	1904410.0
2022-03-04 14:00:00	MSFT	Stock	289.18	290.51	287.75	287.915	1835863.0
2022-03-04 15:00:00	MSFT	Stock	287.91	290.56	287.7	289.68	4036814.0
2022-03-04 16:00:00	MSFT	Stock	289.86	290.24	289.2	289.5	4065398.0
2022-03-04 17:00:00	MSFT	Stock	289.25	290.08	289.25	289.71	13641.0
2022-03-04 18:00:00	MSFT	Stock	289.73	289.8	289.41	289.41	4856.0
2022-03-04 19:00:00	MSFT	Stock	289.56	289.61	289.2	289.48	2513.0
2022-03-04 04:00:00	NVDA	Stock	23.305	23.4	23.251	23.27	192780.0
2022-03-04 05:00:00	NVDA	Stock	23.28	23.469	23.28	23.33	26040.0
2022-03-04 06:00:00	NVDA	Stock	23.35	23.4	23.235	23.323	99220.0
2022-03-04 07:00:00	NVDA	Stock	23.31	23.399	23.049	23.24	637530.0
2022-03-04 08:00:00	NVDA	Stock	23.31	23.6	23.0533	23.225	1452130.0
2022-03-04 09:00:00	NVDA	Stock	23.25	23.68	23.125	23.507	38100180.0
2022-03-04 10:00:00	NVDA	Stock	23.4925	23.566	22.847	22.863	53493740.0
2022-03-04 11:00:00	NVDA	Stock	22.865	23.045	22.6	22.895	56399300.0
2022-03-04 12:00:00	NVDA	Stock	22.892	23.06	22.686	22.945	44724730.0
2022-03-04 13:00:00	NVDA	Stock	22.9455	23.108	22.684	22.7107	28910420.0
2022-03-04 14:00:00	NVDA	Stock	22.715	22.734	22.485	22.4949	35344180.0
2022-03-04 15:00:00	NVDA	Stock	22.497	22.979	22.482	22.936	49156710.0
2022-03-04 16:00:00	NVDA	Stock	22.932	23.04	22.8	22.8395	17010910.0
2022-03-04 17:00:00	NVDA	Stock	22.821	22.86	22.818	22.82	227220.0
2022-03-04 18:00:00	NVDA	Stock	22.83	22.83	22.665	22.707	236010.0
2022-03-04 19:00:00	NVDA	Stock	22.71	22.83	22.71	22.83	223220.0
2022-03-04 04:00:00	AMZN	Stock	146.5	146.5	146.25	146.25	11160.0
2022-03-04 05:00:00	AMZN	Stock	146.3	146.3	146.3	146.3	4000.0

> showing 50 of 63,609 rows — these rows as CSV

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