PREVIEW / stock_1hour / 2022-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-13.parquet
  size:    1.4 MB
  rows:    62,111
  symbols: 2,170

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-13 04:00:00	AAPL	Stock	138.8	138.8	138.36	138.68	27509.0
2022-10-13 05:00:00	AAPL	Stock	138.67	139.0	138.61	138.61	32659.0
2022-10-13 06:00:00	AAPL	Stock	138.62	138.98	138.62	138.97	16809.0
2022-10-13 07:00:00	AAPL	Stock	138.82	139.45	138.75	139.27	123723.0
2022-10-13 08:00:00	AAPL	Stock	138.8	140.0	133.2	134.43	1446327.0
2022-10-13 09:00:00	AAPL	Stock	134.45	136.395	133.88	136.26	13207541.0
2022-10-13 10:00:00	AAPL	Stock	136.25	136.89	135.62	136.28	13837574.0
2022-10-13 11:00:00	AAPL	Stock	136.26	142.61	135.98	140.94	20084683.0
2022-10-13 12:00:00	AAPL	Stock	140.94	141.37	140.07	140.565	9462875.0
2022-10-13 13:00:00	AAPL	Stock	140.57	142.37	140.57	141.81	8268868.0
2022-10-13 14:00:00	AAPL	Stock	141.805	142.99	140.9	142.81	8321274.0
2022-10-13 15:00:00	AAPL	Stock	142.8199	143.59	142.071	142.93	17769310.0
2022-10-13 16:00:00	AAPL	Stock	142.92	143.3	142.63	142.69	8501916.0
2022-10-13 17:00:00	AAPL	Stock	142.68	142.7497	142.55	142.6764	57346.0
2022-10-13 18:00:00	AAPL	Stock	142.63	142.81	142.29	142.63	55242.0
2022-10-13 19:00:00	AAPL	Stock	142.65	142.97	142.53	142.83	37853.0
2022-10-13 04:00:00	MSFT	Stock	225.22	225.8	225.22	225.8	1074.0
2022-10-13 05:00:00	MSFT	Stock	226.01	226.01	226.01	226.01	100.0
2022-10-13 06:00:00	MSFT	Stock	225.76	226.25	225.57	226.01	5933.0
2022-10-13 07:00:00	MSFT	Stock	226.02	227.59	226.0	227.48	16895.0
2022-10-13 08:00:00	MSFT	Stock	225.8127	228.99	218.98	219.9	380536.0
2022-10-13 09:00:00	MSFT	Stock	219.57	223.18	219.0	223.05	3464809.0
2022-10-13 10:00:00	MSFT	Stock	223.07	226.56	222.79	225.1187	5178629.0
2022-10-13 11:00:00	MSFT	Stock	225.11	234.52	224.74	232.95	6238237.0
2022-10-13 12:00:00	MSFT	Stock	232.93	234.21	231.52	233.08	3333011.0
2022-10-13 13:00:00	MSFT	Stock	233.08	235.92	232.57	234.88	2983943.0
2022-10-13 14:00:00	MSFT	Stock	234.855	235.98	233.65	235.58	2304467.0
2022-10-13 15:00:00	MSFT	Stock	235.59	236.1	233.88	234.24	5060235.0
2022-10-13 16:00:00	MSFT	Stock	234.21	234.87	233.53	233.7	4867001.0
2022-10-13 17:00:00	MSFT	Stock	233.81	233.98	233.59	233.8291	8335.0
2022-10-13 18:00:00	MSFT	Stock	233.78	234.09	233.52	233.7	11691.0
2022-10-13 19:00:00	MSFT	Stock	233.7	233.89	233.52	233.63	7292.0
2022-10-13 04:00:00	NVDA	Stock	11.469	11.476	11.425	11.474	83460.0
2022-10-13 05:00:00	NVDA	Stock	11.474	11.509	11.468	11.474	25090.0
2022-10-13 06:00:00	NVDA	Stock	11.47	11.498	11.461	11.469	52850.0
2022-10-13 07:00:00	NVDA	Stock	11.47	11.54	11.463	11.5	279370.0
2022-10-13 08:00:00	NVDA	Stock	11.4749	11.655	10.96	11.018	9510120.0
2022-10-13 09:00:00	NVDA	Stock	11.017	11.159	10.813	11.0956	96648680.0
2022-10-13 10:00:00	NVDA	Stock	11.095	11.44	11.047	11.359	123840270.0
2022-10-13 11:00:00	NVDA	Stock	11.3565	12.078	11.3255	11.89	147236220.0
2022-10-13 12:00:00	NVDA	Stock	11.891	11.95	11.692	11.815	76706590.0
2022-10-13 13:00:00	NVDA	Stock	11.817	12.055	11.807	11.9475	71712720.0
2022-10-13 14:00:00	NVDA	Stock	11.946	11.998	11.836	11.9815	68290510.0
2022-10-13 15:00:00	NVDA	Stock	11.98	12.033	11.889	11.958	106451270.0
2022-10-13 16:00:00	NVDA	Stock	11.96	11.9868	11.933	11.945	27891860.0
2022-10-13 17:00:00	NVDA	Stock	11.95	11.97	11.95	11.96	204420.0
2022-10-13 18:00:00	NVDA	Stock	11.962	11.98	11.954	11.971	250500.0
2022-10-13 19:00:00	NVDA	Stock	11.976	11.985	11.965	11.984	336830.0
2022-10-13 04:00:00	AMZN	Stock	112.73	113.38	112.58	113.18	7495.0
2022-10-13 05:00:00	AMZN	Stock	113.37	113.65	113.35	113.35	9794.0

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

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