PREVIEW / stock_1hour / 2022-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-17.parquet
  size:    1.4 MB
  rows:    61,280
  symbols: 2,167

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-17 04:00:00	AAPL	Stock	142.99	142.99	139.58	139.9	38070.0
2022-10-17 05:00:00	AAPL	Stock	139.81	140.1	139.76	139.94	20511.0
2022-10-17 06:00:00	AAPL	Stock	139.98	140.44	139.85	140.33	56605.0
2022-10-17 07:00:00	AAPL	Stock	140.31	140.44	139.89	140.37	95841.0
2022-10-17 08:00:00	AAPL	Stock	140.2	141.2	139.07	141.0497	438932.0
2022-10-17 09:00:00	AAPL	Stock	141.05	142.69	140.49	142.0	13436217.0
2022-10-17 10:00:00	AAPL	Stock	142.005	142.22	140.71	140.9772	11934123.0
2022-10-17 11:00:00	AAPL	Stock	140.975	141.89	140.27	141.68	9620183.0
2022-10-17 12:00:00	AAPL	Stock	141.68	141.93	141.19	141.8293	5779547.0
2022-10-17 13:00:00	AAPL	Stock	141.83	142.59	141.67	142.3578	6873562.0
2022-10-17 14:00:00	AAPL	Stock	142.37	142.83	142.1659	142.68	6304497.0
2022-10-17 15:00:00	AAPL	Stock	142.67	142.9	142.11	142.4	10371673.0
2022-10-17 16:00:00	AAPL	Stock	142.4	142.62	142.1	142.5	11120602.0
2022-10-17 17:00:00	AAPL	Stock	142.46	142.72	142.43	142.68	53691.0
2022-10-17 18:00:00	AAPL	Stock	142.67	143.1	142.66	143.07	95095.0
2022-10-17 19:00:00	AAPL	Stock	143.08	143.5	143.02	143.45	69897.0
2022-10-17 04:00:00	MSFT	Stock	232.0	232.05	231.08	231.45	16053.0
2022-10-17 05:00:00	MSFT	Stock	231.5	231.68	231.5	231.55	2537.0
2022-10-17 06:00:00	MSFT	Stock	231.45	232.93	231.4	231.82	7572.0
2022-10-17 07:00:00	MSFT	Stock	232.0	232.3	231.34	232.3	14559.0
2022-10-17 08:00:00	MSFT	Stock	231.7215	233.49	227.989	233.33	70694.0
2022-10-17 09:00:00	MSFT	Stock	233.48	238.96	233.36	237.181	3464218.0
2022-10-17 10:00:00	MSFT	Stock	237.18	238.06	235.4211	235.879	2348149.0
2022-10-17 11:00:00	MSFT	Stock	235.87	237.49	235.135	237.11	2104654.0
2022-10-17 12:00:00	MSFT	Stock	237.09	237.24	235.78	236.06	1394449.0
2022-10-17 13:00:00	MSFT	Stock	236.04	237.56	235.61	237.47	1274453.0
2022-10-17 14:00:00	MSFT	Stock	237.48	238.03	237.06	237.43	1460826.0
2022-10-17 15:00:00	MSFT	Stock	237.41	237.95	236.73	237.53	3870857.0
2022-10-17 16:00:00	MSFT	Stock	237.53	238.1	237.3	237.78	6142158.0
2022-10-17 17:00:00	MSFT	Stock	237.9977	238.2022	237.76	238.2022	8207.0
2022-10-17 18:00:00	MSFT	Stock	238.39	239.3	238.39	239.3	16999.0
2022-10-17 19:00:00	MSFT	Stock	239.2	239.92	239.2	239.92	12935.0
2022-10-17 04:00:00	NVDA	Stock	11.227	11.47	11.227	11.344	179150.0
2022-10-17 05:00:00	NVDA	Stock	11.351	11.38	11.332	11.37	56370.0
2022-10-17 06:00:00	NVDA	Stock	11.379	11.413	11.359	11.404	126870.0
2022-10-17 07:00:00	NVDA	Stock	11.402	11.402	11.356	11.379	466300.0
2022-10-17 08:00:00	NVDA	Stock	11.4001	11.448	11.199	11.424	2200460.0
2022-10-17 09:00:00	NVDA	Stock	11.444	11.88	11.421	11.744	82197520.0
2022-10-17 10:00:00	NVDA	Stock	11.746	11.8678	11.607	11.615	88791630.0
2022-10-17 11:00:00	NVDA	Stock	11.615	11.932	11.607	11.8689	82497450.0
2022-10-17 12:00:00	NVDA	Stock	11.868	11.886	11.792	11.854	52228260.0
2022-10-17 13:00:00	NVDA	Stock	11.855	11.941	11.824	11.898	42092580.0
2022-10-17 14:00:00	NVDA	Stock	11.8952	11.9335	11.8509	11.893	45260160.0
2022-10-17 15:00:00	NVDA	Stock	11.8934	11.948	11.825	11.887	75877270.0
2022-10-17 16:00:00	NVDA	Stock	11.8895	11.932	11.869	11.911	32160920.0
2022-10-17 17:00:00	NVDA	Stock	11.91	11.938	11.9	11.9305	260120.0
2022-10-17 18:00:00	NVDA	Stock	11.937	12.0	11.937	11.99	463730.0
2022-10-17 19:00:00	NVDA	Stock	11.98	12.08	11.98	12.06	717650.0
2022-10-17 04:00:00	AMZN	Stock	108.11	108.63	108.08	108.48	54972.0
2022-10-17 05:00:00	AMZN	Stock	108.5	108.77	108.42	108.61	8016.0

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

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