PREVIEW / stock_1hour / 2023-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-25.parquet
  size:    1.3 MB
  rows:    58,307
  symbols: 1,403

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-25 04:00:00	AAPL	Stock	175.58	175.58	173.99	174.47	44046.0
2023-09-25 05:00:00	AAPL	Stock	174.52	174.8	174.34	174.76	19524.0
2023-09-25 06:00:00	AAPL	Stock	174.8	174.93	174.66	174.89	24201.0
2023-09-25 07:00:00	AAPL	Stock	174.93	175.17	174.31	174.46	49890.0
2023-09-25 08:00:00	AAPL	Stock	174.5	175.57	174.2	174.67	114643.0
2023-09-25 09:00:00	AAPL	Stock	174.62	175.505	174.07	175.34	5403149.0
2023-09-25 10:00:00	AAPL	Stock	175.35	175.55	174.21	174.88	5539261.0
2023-09-25 11:00:00	AAPL	Stock	174.89	176.54	174.87	176.03	5817992.0
2023-09-25 12:00:00	AAPL	Stock	176.04	176.97	175.88	176.29	4331355.0
2023-09-25 13:00:00	AAPL	Stock	176.28	176.8	175.88	176.26	3526336.0
2023-09-25 14:00:00	AAPL	Stock	176.27	176.3676	175.48	175.55	3477402.0
2023-09-25 15:00:00	AAPL	Stock	175.555	176.15	174.97	176.09	6914568.0
2023-09-25 16:00:00	AAPL	Stock	176.08	176.5	176.08	176.29	4101528.0
2023-09-25 17:00:00	AAPL	Stock	176.32	176.32	176.08	176.16	39296.0
2023-09-25 18:00:00	AAPL	Stock	176.15	176.2	176.11	176.1415	13795.0
2023-09-25 19:00:00	AAPL	Stock	176.14	176.17	175.97	176.13	31832.0
2023-09-25 04:00:00	MSFT	Stock	317.68	317.68	314.71	315.34	4316.0
2023-09-25 05:00:00	MSFT	Stock	315.27	315.4	315.27	315.4	203.0
2023-09-25 06:00:00	MSFT	Stock	315.9	318.27	315.9	317.5	15101.0
2023-09-25 07:00:00	MSFT	Stock	317.47	317.6	316.17	316.25	8754.0
2023-09-25 08:00:00	MSFT	Stock	317.1	318.14	315.9999	316.6	19388.0
2023-09-25 09:00:00	MSFT	Stock	316.55	317.67	315.65	316.39	1968812.0
2023-09-25 10:00:00	MSFT	Stock	316.43	317.62	315.06	315.1	1716027.0
2023-09-25 11:00:00	MSFT	Stock	315.08	317.22	315.08	316.485	1097729.0
2023-09-25 12:00:00	MSFT	Stock	316.51	316.86	315.3313	315.6801	847261.0
2023-09-25 13:00:00	MSFT	Stock	315.68	316.4513	315.27	316.29	894645.0
2023-09-25 14:00:00	MSFT	Stock	316.31	316.46	315.5	315.6	970768.0
2023-09-25 15:00:00	MSFT	Stock	315.61	317.63	315.0	317.6	2255959.0
2023-09-25 16:00:00	MSFT	Stock	317.54	317.85	317.54	317.65	1768552.0
2023-09-25 17:00:00	MSFT	Stock	317.64	317.8	317.63	317.75	2996.0
2023-09-25 18:00:00	MSFT	Stock	317.7	317.75	317.54	317.64	8019.0
2023-09-25 19:00:00	MSFT	Stock	317.56	317.56	317.0	317.4	8448.0
2023-09-25 04:00:00	NVDA	Stock	41.99	41.99	41.457	41.559	159850.0
2023-09-25 05:00:00	NVDA	Stock	41.582	41.68	41.45	41.54	63690.0
2023-09-25 06:00:00	NVDA	Stock	41.536	41.587	41.5	41.53	44960.0
2023-09-25 07:00:00	NVDA	Stock	41.548	41.596	41.235	41.248	522010.0
2023-09-25 08:00:00	NVDA	Stock	41.521	41.943	41.1	41.33	1474710.0
2023-09-25 09:00:00	NVDA	Stock	41.329	42.464	41.177	42.197	63513890.0
2023-09-25 10:00:00	NVDA	Stock	42.187	42.536	41.875	41.892	64777720.0
2023-09-25 11:00:00	NVDA	Stock	41.8875	42.442	41.884	42.216	42111060.0
2023-09-25 12:00:00	NVDA	Stock	42.227	42.462	42.018	42.0744	37537430.0
2023-09-25 13:00:00	NVDA	Stock	42.081	42.311	41.965	42.0895	28710480.0
2023-09-25 14:00:00	NVDA	Stock	42.094	42.236	41.899	41.939	30327210.0
2023-09-25 15:00:00	NVDA	Stock	41.932	42.2537	41.761	42.229	43464440.0
2023-09-25 16:00:00	NVDA	Stock	42.228	42.34	42.171	42.33	11461990.0
2023-09-25 17:00:00	NVDA	Stock	42.332	42.394	42.222	42.356	2009750.0
2023-09-25 18:00:00	NVDA	Stock	42.345	42.369	42.33	42.33	223150.0
2023-09-25 19:00:00	NVDA	Stock	42.325	42.4	42.312	42.4	545320.0
2023-09-25 04:00:00	AMZN	Stock	130.02	130.17	129.01	129.42	25679.0
2023-09-25 05:00:00	AMZN	Stock	129.61	130.0	129.61	129.9	9604.0

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

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