PREVIEW / stock_1hour / 2022-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-18.parquet
  size:    1.4 MB
  rows:    62,390
  symbols: 2,173

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-10-18 04:00:00	AAPL	Stock	144.21	145.25	144.02	144.23	62404.0
2022-10-18 05:00:00	AAPL	Stock	144.21	144.38	143.66	144.38	42432.0
2022-10-18 06:00:00	AAPL	Stock	144.36	144.82	144.18	144.23	37981.0
2022-10-18 07:00:00	AAPL	Stock	144.23	145.01	144.16	144.74	154414.0
2022-10-18 08:00:00	AAPL	Stock	144.35	145.66	142.054	145.4	360038.0
2022-10-18 09:00:00	AAPL	Stock	145.39	146.7	145.01	145.57	11279501.0
2022-10-18 10:00:00	AAPL	Stock	145.56	145.96	144.83	145.085	9221604.0
2022-10-18 11:00:00	AAPL	Stock	145.085	145.18	142.965	144.005	9715143.0
2022-10-18 12:00:00	AAPL	Stock	144.005	145.3	143.6	144.73	7764600.0
2022-10-18 13:00:00	AAPL	Stock	144.73	145.63	144.14	145.33	6893128.0
2022-10-18 14:00:00	AAPL	Stock	145.33	145.41	140.61	142.5	20029050.0
2022-10-18 15:00:00	AAPL	Stock	142.481	143.89	141.54	143.79	16400171.0
2022-10-18 16:00:00	AAPL	Stock	143.79	144.82	143.5	144.3671	6740324.0
2022-10-18 17:00:00	AAPL	Stock	144.33	144.78	144.32	144.6699	101145.0
2022-10-18 18:00:00	AAPL	Stock	144.52	144.64	144.33	144.48	54629.0
2022-10-18 19:00:00	AAPL	Stock	144.48	145.5	144.42	144.88	99951.0
2022-10-18 04:00:00	MSFT	Stock	241.01	242.12	240.35	240.35	11108.0
2022-10-18 05:00:00	MSFT	Stock	240.35	241.7	240.09	241.67	15069.0
2022-10-18 06:00:00	MSFT	Stock	241.67	242.1	241.1	241.3	10363.0
2022-10-18 07:00:00	MSFT	Stock	241.01	242.61	241.01	242.35	34193.0
2022-10-18 08:00:00	MSFT	Stock	241.0344	244.0	236.937	243.8	104014.0
2022-10-18 09:00:00	MSFT	Stock	243.7	244.16	239.729	239.99	3192246.0
2022-10-18 10:00:00	MSFT	Stock	240.0	241.34	238.68	239.6	2842262.0
2022-10-18 11:00:00	MSFT	Stock	239.55	239.56	235.37	237.25	2785342.0
2022-10-18 12:00:00	MSFT	Stock	237.23	239.05	236.92	238.16	2116749.0
2022-10-18 13:00:00	MSFT	Stock	238.16	239.32	236.9	239.07	1762642.0
2022-10-18 14:00:00	MSFT	Stock	239.04	239.19	236.22	237.45	1716820.0
2022-10-18 15:00:00	MSFT	Stock	237.43	239.23	236.6	238.56	2804845.0
2022-10-18 16:00:00	MSFT	Stock	238.55	242.2	238.24	241.6	2770735.0
2022-10-18 17:00:00	MSFT	Stock	241.52	241.93	241.02	241.75	22163.0
2022-10-18 18:00:00	MSFT	Stock	241.51	241.52	240.58	240.8301	7648.0
2022-10-18 19:00:00	MSFT	Stock	241.05	242.59	240.95	241.55	16552.0
2022-10-18 04:00:00	NVDA	Stock	12.153	12.21	12.078	12.078	302330.0
2022-10-18 05:00:00	NVDA	Stock	12.079	12.145	12.065	12.145	57220.0
2022-10-18 06:00:00	NVDA	Stock	12.146	12.195	12.131	12.131	47020.0
2022-10-18 07:00:00	NVDA	Stock	12.147	12.223	12.147	12.19	555340.0
2022-10-18 08:00:00	NVDA	Stock	12.2	12.32	12.146	12.3	3126300.0
2022-10-18 09:00:00	NVDA	Stock	12.301	12.492	12.026	12.0994	77031290.0
2022-10-18 10:00:00	NVDA	Stock	12.103	12.19	11.855	11.878	91627310.0
2022-10-18 11:00:00	NVDA	Stock	11.8765	11.891	11.618	11.802	84003970.0
2022-10-18 12:00:00	NVDA	Stock	11.801	11.9725	11.719	11.8555	71819820.0
2022-10-18 13:00:00	NVDA	Stock	11.858	12.028	11.797	12.014	62257080.0
2022-10-18 14:00:00	NVDA	Stock	12.013	12.067	11.759	11.884	77993940.0
2022-10-18 15:00:00	NVDA	Stock	11.882	12.0155	11.805	11.968	89494160.0
2022-10-18 16:00:00	NVDA	Stock	11.968	12.168	11.922	12.157	18326290.0
2022-10-18 17:00:00	NVDA	Stock	12.151	12.161	12.133	12.136	378170.0
2022-10-18 18:00:00	NVDA	Stock	12.138	12.139	12.1	12.113	457490.0
2022-10-18 19:00:00	NVDA	Stock	12.11	12.155	12.106	12.144	266230.0
2022-10-18 04:00:00	AMZN	Stock	116.11	116.44	115.0	115.82	35310.0
2022-10-18 05:00:00	AMZN	Stock	115.82	116.23	115.3	116.22	44739.0

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

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