PREVIEW / stock_1hour / 2023-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-29.parquet
  size:    1.3 MB
  rows:    58,409
  symbols: 1,385

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-09-29 04:00:00	AAPL	Stock	171.28	172.34	171.28	172.0	24679.0
2023-09-29 05:00:00	AAPL	Stock	172.25	172.3	172.01	172.2	3840.0
2023-09-29 06:00:00	AAPL	Stock	172.26	172.26	171.89	171.95	11990.0
2023-09-29 07:00:00	AAPL	Stock	171.87	172.05	171.32	171.75	31255.0
2023-09-29 08:00:00	AAPL	Stock	172.05	172.74	171.2	172.64	243925.0
2023-09-29 09:00:00	AAPL	Stock	172.65	172.8001	170.69	172.6977	5634952.0
2023-09-29 10:00:00	AAPL	Stock	172.7	173.07	172.04	172.435	5805901.0
2023-09-29 11:00:00	AAPL	Stock	172.44	172.76	171.58	171.9301	4200070.0
2023-09-29 12:00:00	AAPL	Stock	171.94	172.09	171.17	171.325	2650877.0
2023-09-29 13:00:00	AAPL	Stock	171.33	171.33	170.62	170.63	3081646.0
2023-09-29 14:00:00	AAPL	Stock	170.62	171.565	170.341	171.5401	4315300.0
2023-09-29 15:00:00	AAPL	Stock	171.55	171.92	170.76	171.22	7676421.0
2023-09-29 16:00:00	AAPL	Stock	171.21	171.73	171.09	171.59	9736673.0
2023-09-29 17:00:00	AAPL	Stock	171.56	171.6	171.21	171.47	61079.0
2023-09-29 18:00:00	AAPL	Stock	171.45	171.55	171.23	171.24	16604.0
2023-09-29 19:00:00	AAPL	Stock	171.3	171.35	171.2	171.23	21310.0
2023-09-29 04:00:00	MSFT	Stock	314.99	316.0	314.99	315.84	2819.0
2023-09-29 05:00:00	MSFT	Stock	316.0	316.16	316.0	316.16	2114.0
2023-09-29 06:00:00	MSFT	Stock	316.26	316.69	316.1	316.1	3012.0
2023-09-29 07:00:00	MSFT	Stock	316.1	316.3	315.55	315.65	10442.0
2023-09-29 08:00:00	MSFT	Stock	316.1025	316.95	314.5	316.8	59069.0
2023-09-29 09:00:00	MSFT	Stock	316.8	319.45	316.42	318.56	2112556.0
2023-09-29 10:00:00	MSFT	Stock	318.58	319.47	317.3401	317.4902	1720729.0
2023-09-29 11:00:00	MSFT	Stock	317.53	318.89	317.085	317.58	1354676.0
2023-09-29 12:00:00	MSFT	Stock	317.535	318.33	316.76	316.99	932674.0
2023-09-29 13:00:00	MSFT	Stock	316.96	316.96	315.22	315.4	1204476.0
2023-09-29 14:00:00	MSFT	Stock	315.4	316.55	314.98	316.52	1075986.0
2023-09-29 15:00:00	MSFT	Stock	316.535	317.88	315.172	315.75	2833227.0
2023-09-29 16:00:00	MSFT	Stock	315.75	317.0	315.75	316.53	5276169.0
2023-09-29 17:00:00	MSFT	Stock	315.75	316.58	315.75	316.01	56780.0
2023-09-29 18:00:00	MSFT	Stock	316.0127	316.2	315.75	315.75	1719.0
2023-09-29 19:00:00	MSFT	Stock	315.97	316.12	315.88	315.88	600.0
2023-09-29 04:00:00	NVDA	Stock	43.412	43.654	43.412	43.526	236660.0
2023-09-29 05:00:00	NVDA	Stock	43.538	43.605	43.515	43.59	85950.0
2023-09-29 06:00:00	NVDA	Stock	43.593	43.605	43.525	43.6	116720.0
2023-09-29 07:00:00	NVDA	Stock	43.6	43.655	43.491	43.575	678160.0
2023-09-29 08:00:00	NVDA	Stock	43.595	43.818	43.3	43.799	3013810.0
2023-09-29 09:00:00	NVDA	Stock	43.8	44.144	43.648	43.9681	57187660.0
2023-09-29 10:00:00	NVDA	Stock	43.976	44.119	43.71	43.89	56937720.0
2023-09-29 11:00:00	NVDA	Stock	43.886	44.004	43.6266	43.735	39979680.0
2023-09-29 12:00:00	NVDA	Stock	43.732	43.809	43.544	43.577	25584250.0
2023-09-29 13:00:00	NVDA	Stock	43.57	43.603	43.312	43.32	33262950.0
2023-09-29 14:00:00	NVDA	Stock	43.3175	43.652	43.3069	43.65	32392940.0
2023-09-29 15:00:00	NVDA	Stock	43.6476	43.7225	43.45	43.497	49752460.0
2023-09-29 16:00:00	NVDA	Stock	43.496	43.534	43.485	43.501	22502010.0
2023-09-29 17:00:00	NVDA	Stock	43.499	43.509	43.49	43.5	240650.0
2023-09-29 18:00:00	NVDA	Stock	43.5	43.51	43.48	43.5	100880.0
2023-09-29 19:00:00	NVDA	Stock	43.473	43.527	43.423	43.527	359260.0
2023-09-29 04:00:00	AMZN	Stock	126.86	127.34	126.85	127.01	10927.0
2023-09-29 05:00:00	AMZN	Stock	127.1	127.3	127.01	127.3	10450.0

> showing 50 of 58,409 rows — these rows as CSV

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