PREVIEW / stock_1hour / 2023-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-31.parquet
  size:    1.4 MB
  rows:    62,319
  symbols: 1,567

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
2023-07-31 04:00:00	AAPL	Stock	195.89	195.9	195.39	195.81	11628.0
2023-07-31 05:00:00	AAPL	Stock	195.78	195.95	195.57	195.7	7672.0
2023-07-31 06:00:00	AAPL	Stock	195.7	195.89	195.7	195.8	6033.0
2023-07-31 07:00:00	AAPL	Stock	195.83	196.25	195.78	196.25	65211.0
2023-07-31 08:00:00	AAPL	Stock	196.0	196.71	195.51	196.59	192278.0
2023-07-31 09:00:00	AAPL	Stock	196.6	196.64	195.39	195.6	4582907.0
2023-07-31 10:00:00	AAPL	Stock	195.595	196.435	195.26	196.26	4463475.0
2023-07-31 11:00:00	AAPL	Stock	196.27	196.49	195.95	196.1398	2914719.0
2023-07-31 12:00:00	AAPL	Stock	196.14	196.2833	195.77	195.91	2254096.0
2023-07-31 13:00:00	AAPL	Stock	195.901	196.39	195.78	196.2399	2300653.0
2023-07-31 14:00:00	AAPL	Stock	196.235	196.37	195.935	196.2974	2367922.0
2023-07-31 15:00:00	AAPL	Stock	196.3	196.49	195.79	196.48	5643892.0
2023-07-31 16:00:00	AAPL	Stock	196.48	196.5	196.34	196.4	6663877.0
2023-07-31 17:00:00	AAPL	Stock	196.38	196.45	196.34	196.394	26885.0
2023-07-31 18:00:00	AAPL	Stock	196.39	196.41	196.26	196.3	19901.0
2023-07-31 19:00:00	AAPL	Stock	196.32	196.36	196.11	196.32	20039.0
2023-07-31 04:00:00	MSFT	Stock	338.0	338.0	337.2	337.55	4773.0
2023-07-31 05:00:00	MSFT	Stock	337.45	337.9	337.24	337.37	7196.0
2023-07-31 06:00:00	MSFT	Stock	337.3	337.36	336.82	337.17	3237.0
2023-07-31 07:00:00	MSFT	Stock	337.37	338.05	336.91	338.05	23998.0
2023-07-31 08:00:00	MSFT	Stock	337.2	338.3	337.03	337.9494	43494.0
2023-07-31 09:00:00	MSFT	Stock	337.75	337.8	333.78	334.375	2603360.0
2023-07-31 10:00:00	MSFT	Stock	334.385	335.79	333.36	335.45	2805770.0
2023-07-31 11:00:00	MSFT	Stock	335.44	336.3436	333.64	334.3384	2103005.0
2023-07-31 12:00:00	MSFT	Stock	334.34	334.835	334.1	334.52	1140463.0
2023-07-31 13:00:00	MSFT	Stock	334.52	334.7	333.86	334.3352	1408257.0
2023-07-31 14:00:00	MSFT	Stock	334.3481	335.8	333.95	335.54	1449841.0
2023-07-31 15:00:00	MSFT	Stock	335.55	336.0	334.14	336.0	2938326.0
2023-07-31 16:00:00	MSFT	Stock	335.99	336.2	335.74	335.96	3894707.0
2023-07-31 17:00:00	MSFT	Stock	335.96	336.09	335.8	336.05	14720.0
2023-07-31 18:00:00	MSFT	Stock	336.01	336.09	335.92	335.99	5325.0
2023-07-31 19:00:00	MSFT	Stock	335.9001	336.12	335.6	336.1	11819.0
2023-07-31 04:00:00	NVDA	Stock	46.799	46.799	46.63	46.63	128930.0
2023-07-31 05:00:00	NVDA	Stock	46.637	46.64	46.6	46.61	90150.0
2023-07-31 06:00:00	NVDA	Stock	46.582	46.591	46.52	46.57	63650.0
2023-07-31 07:00:00	NVDA	Stock	46.629	46.85	46.57	46.842	407410.0
2023-07-31 08:00:00	NVDA	Stock	46.66	46.945	46.58	46.9	1404320.0
2023-07-31 09:00:00	NVDA	Stock	46.91	47.13	46.538	46.688	36489950.0
2023-07-31 10:00:00	NVDA	Stock	46.688	46.967	46.6	46.7985	35559160.0
2023-07-31 11:00:00	NVDA	Stock	46.7995	46.925	46.592	46.686	24218640.0
2023-07-31 12:00:00	NVDA	Stock	46.69	46.804	46.533	46.587	17982790.0
2023-07-31 13:00:00	NVDA	Stock	46.581	46.861	46.506	46.7775	19110720.0
2023-07-31 14:00:00	NVDA	Stock	46.785	46.867	46.629	46.808	14078110.0
2023-07-31 15:00:00	NVDA	Stock	46.812	46.8172	46.55	46.736	27128210.0
2023-07-31 16:00:00	NVDA	Stock	46.742	46.777	46.7	46.729	17154410.0
2023-07-31 17:00:00	NVDA	Stock	46.743	46.773	46.735	46.745	104910.0
2023-07-31 18:00:00	NVDA	Stock	46.755	46.76	46.702	46.702	200240.0
2023-07-31 19:00:00	NVDA	Stock	46.71	46.763	46.706	46.751	215540.0
2023-07-31 04:00:00	AMZN	Stock	132.68	133.19	132.34	133.19	22423.0
2023-07-31 05:00:00	AMZN	Stock	133.12	133.38	133.0	133.04	22219.0

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

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