PREVIEW / stock_1hour / 2022-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-19.parquet
  size:    1.3 MB
  rows:    61,212
  symbols: 2,152

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-19 04:00:00	AAPL	Stock	144.06	144.15	142.4	143.02	57662.0
2022-10-19 05:00:00	AAPL	Stock	143.0	144.5	143.0	144.41	76912.0
2022-10-19 06:00:00	AAPL	Stock	144.29	144.38	143.21	143.22	54533.0
2022-10-19 07:00:00	AAPL	Stock	143.46	143.59	141.95	142.52	170233.0
2022-10-19 08:00:00	AAPL	Stock	143.5275	143.63	141.5	141.82	325874.0
2022-10-19 09:00:00	AAPL	Stock	141.82	144.13	141.38	143.44	8610478.0
2022-10-19 10:00:00	AAPL	Stock	143.43	144.9492	143.17	143.6	8788673.0
2022-10-19 11:00:00	AAPL	Stock	143.59	144.34	143.23	143.94	6461470.0
2022-10-19 12:00:00	AAPL	Stock	143.94	143.99	142.85	143.06	5295473.0
2022-10-19 13:00:00	AAPL	Stock	143.06	143.155	142.17	142.805	5782271.0
2022-10-19 14:00:00	AAPL	Stock	142.8	143.59	142.62	142.95	5378040.0
2022-10-19 15:00:00	AAPL	Stock	142.96	143.96	142.83	143.9	9024906.0
2022-10-19 16:00:00	AAPL	Stock	143.9	144.59	143.4	143.93	5066138.0
2022-10-19 17:00:00	AAPL	Stock	143.8912	143.99	143.75	143.76	51949.0
2022-10-19 18:00:00	AAPL	Stock	143.78	143.9	143.3	143.3	37369.0
2022-10-19 19:00:00	AAPL	Stock	143.25	143.3	142.81	143.0	54998.0
2022-10-19 04:00:00	MSFT	Stock	239.17	239.17	237.6	238.7	28017.0
2022-10-19 05:00:00	MSFT	Stock	239.3	240.2	239.04	240.15	1546.0
2022-10-19 06:00:00	MSFT	Stock	240.35	240.35	237.33	238.53	7620.0
2022-10-19 07:00:00	MSFT	Stock	238.58	238.58	236.33	237.45	18085.0
2022-10-19 08:00:00	MSFT	Stock	238.6812	242.0	236.28	236.91	45344.0
2022-10-19 09:00:00	MSFT	Stock	236.75	238.57	236.2	237.18	1938415.0
2022-10-19 10:00:00	MSFT	Stock	237.14	239.61	236.76	237.7801	2365851.0
2022-10-19 11:00:00	MSFT	Stock	237.785	238.34	236.52	237.36	1707816.0
2022-10-19 12:00:00	MSFT	Stock	237.31	237.4	235.37	235.715	1521752.0
2022-10-19 13:00:00	MSFT	Stock	235.69	235.85	234.29	235.165	1465443.0
2022-10-19 14:00:00	MSFT	Stock	235.13	236.24	234.8	234.82	1271222.0
2022-10-19 15:00:00	MSFT	Stock	234.83	236.64	234.65	236.53	2196066.0
2022-10-19 16:00:00	MSFT	Stock	236.51	237.49	236.0	236.45	2625809.0
2022-10-19 17:00:00	MSFT	Stock	236.45	236.8	236.0	236.01	11724.0
2022-10-19 18:00:00	MSFT	Stock	235.83	236.4099	235.4	235.55	5505.0
2022-10-19 19:00:00	MSFT	Stock	235.54	235.54	234.3	234.3	12747.0
2022-10-19 04:00:00	NVDA	Stock	11.987	11.995	11.84	11.927	723270.0
2022-10-19 05:00:00	NVDA	Stock	11.925	12.018	11.919	12.018	94780.0
2022-10-19 06:00:00	NVDA	Stock	12.009	12.009	11.881	11.91	132640.0
2022-10-19 07:00:00	NVDA	Stock	11.925	11.965	11.8	11.88	531730.0
2022-10-19 08:00:00	NVDA	Stock	11.9689	12.043	11.77	11.804	2821760.0
2022-10-19 09:00:00	NVDA	Stock	11.804	12.061	11.772	11.8858	55747660.0
2022-10-19 10:00:00	NVDA	Stock	11.881	12.35	11.834	12.105	102449680.0
2022-10-19 11:00:00	NVDA	Stock	12.103	12.212	12.046	12.1655	64801780.0
2022-10-19 12:00:00	NVDA	Stock	12.163	12.174	11.9625	12.009	45066470.0
2022-10-19 13:00:00	NVDA	Stock	12.007	12.014	11.881	11.995	43467930.0
2022-10-19 14:00:00	NVDA	Stock	11.995	12.12	11.971	11.994	53877500.0
2022-10-19 15:00:00	NVDA	Stock	11.995	12.061	11.935	12.057	61224180.0
2022-10-19 16:00:00	NVDA	Stock	12.051	12.104	11.951	12.005	21164160.0
2022-10-19 17:00:00	NVDA	Stock	12.011	12.029	12.0	12.01	170950.0
2022-10-19 18:00:00	NVDA	Stock	12.012	12.012	11.96	11.96	229160.0
2022-10-19 19:00:00	NVDA	Stock	11.962	11.969	11.87	11.905	276940.0
2022-10-19 04:00:00	AMZN	Stock	118.0	118.0	116.0	117.0	78922.0
2022-10-19 05:00:00	AMZN	Stock	117.0	117.59	117.0	117.59	14905.0

> showing 50 of 61,212 rows — these rows as CSV

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