PREVIEW / stock_1hour / 2023-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-23.parquet
  size:    1.3 MB
  rows:    59,062
  symbols: 1,470

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-08-23 04:00:00	AAPL	Stock	178.0	178.33	177.95	178.32	14642.0
2023-08-23 05:00:00	AAPL	Stock	178.29	178.43	178.01	178.23	10159.0
2023-08-23 06:00:00	AAPL	Stock	178.27	178.37	177.82	177.93	17349.0
2023-08-23 07:00:00	AAPL	Stock	177.85	177.85	177.31	177.75	40595.0
2023-08-23 08:00:00	AAPL	Stock	177.92	178.42	177.3101	177.56	179355.0
2023-08-23 09:00:00	AAPL	Stock	177.55	180.17	177.55	179.8201	7146024.0
2023-08-23 10:00:00	AAPL	Stock	179.84	181.27	179.465	181.2101	7822584.0
2023-08-23 11:00:00	AAPL	Stock	181.2115	181.3311	180.79	181.13	5182249.0
2023-08-23 12:00:00	AAPL	Stock	181.13	181.18	180.63	180.68	2992816.0
2023-08-23 13:00:00	AAPL	Stock	180.68	181.55	180.63	181.399	3823756.0
2023-08-23 14:00:00	AAPL	Stock	181.399	181.4	180.8	180.945	3142412.0
2023-08-23 15:00:00	AAPL	Stock	180.95	181.54	180.81	181.14	6289250.0
2023-08-23 16:00:00	AAPL	Stock	181.16	181.33	180.52	180.9	7282387.0
2023-08-23 17:00:00	AAPL	Stock	180.92	181.27	180.69	180.83	297942.0
2023-08-23 18:00:00	AAPL	Stock	180.85	181.0	180.7	180.89	45747.0
2023-08-23 19:00:00	AAPL	Stock	180.89	181.9	180.8889	181.32	129803.0
2023-08-23 04:00:00	MSFT	Stock	323.32	325.6	323.32	325.0	7145.0
2023-08-23 05:00:00	MSFT	Stock	324.84	325.17	324.84	324.9	614.0
2023-08-23 06:00:00	MSFT	Stock	324.8	324.8	324.21	324.4	1848.0
2023-08-23 07:00:00	MSFT	Stock	324.4	324.42	323.0	324.0	17248.0
2023-08-23 08:00:00	MSFT	Stock	323.0	324.4	322.7807	323.6024	25281.0
2023-08-23 09:00:00	MSFT	Stock	323.89	326.45	323.33	326.27	1775604.0
2023-08-23 10:00:00	MSFT	Stock	326.27	328.45	325.8	328.17	1845035.0
2023-08-23 11:00:00	MSFT	Stock	328.17	328.82	327.05	328.03	1279030.0
2023-08-23 12:00:00	MSFT	Stock	328.0	328.49	327.5501	328.04	794273.0
2023-08-23 13:00:00	MSFT	Stock	328.05	329.2	327.935	328.9094	891483.0
2023-08-23 14:00:00	MSFT	Stock	328.91	328.91	327.24	327.365	1135761.0
2023-08-23 15:00:00	MSFT	Stock	327.365	328.11	326.66	327.01	2067572.0
2023-08-23 16:00:00	MSFT	Stock	326.99	335.1	326.6	334.01	3587108.0
2023-08-23 17:00:00	MSFT	Stock	333.96	334.5	332.12	332.45	100601.0
2023-08-23 18:00:00	MSFT	Stock	332.45	332.9	331.15	331.836	30282.0
2023-08-23 19:00:00	MSFT	Stock	331.91	333.19	331.91	332.49	35102.0
2023-08-23 04:00:00	NVDA	Stock	46.35	46.503	46.276	46.346	278050.0
2023-08-23 05:00:00	NVDA	Stock	46.342	46.495	46.326	46.419	144940.0
2023-08-23 06:00:00	NVDA	Stock	46.43	46.439	46.03	46.125	303210.0
2023-08-23 07:00:00	NVDA	Stock	46.138	46.14	45.66	45.97	1356330.0
2023-08-23 08:00:00	NVDA	Stock	46.12	46.43	45.665	45.9082	3548180.0
2023-08-23 09:00:00	NVDA	Stock	45.91	46.312	45.208	45.9786	72811730.0
2023-08-23 10:00:00	NVDA	Stock	45.971	46.754	45.784	46.695	92179350.0
2023-08-23 11:00:00	NVDA	Stock	46.6885	46.9	46.43	46.86	53412730.0
2023-08-23 12:00:00	NVDA	Stock	46.872	46.908	46.536	46.565	39652670.0
2023-08-23 13:00:00	NVDA	Stock	46.5697	47.057	46.47	46.9825	48617400.0
2023-08-23 14:00:00	NVDA	Stock	46.987	47.037	46.623	46.8639	46101880.0
2023-08-23 15:00:00	NVDA	Stock	46.8725	47.2	46.7313	47.122	81384540.0
2023-08-23 16:00:00	NVDA	Stock	47.116	51.5	46.999	51.1522	82153080.0
2023-08-23 17:00:00	NVDA	Stock	51.196	52.0	50.2	50.361	37600080.0
2023-08-23 18:00:00	NVDA	Stock	50.365	50.5	49.6	49.975	16988020.0
2023-08-23 19:00:00	NVDA	Stock	49.973	50.42	49.852	50.21	7318600.0
2023-08-23 04:00:00	AMZN	Stock	134.62	135.41	134.6	135.18	16644.0
2023-08-23 05:00:00	AMZN	Stock	135.28	135.31	135.08	135.27	4847.0

> showing 50 of 59,062 rows — these rows as CSV

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