PREVIEW / stock_1hour / 2023-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-18.parquet
  size:    1.3 MB
  rows:    60,163
  symbols: 1,645

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-05-18 04:00:00	AAPL	Stock	172.84	173.0	172.76	172.8	12908.0
2023-05-18 05:00:00	AAPL	Stock	172.76	172.87	172.75	172.83	4826.0
2023-05-18 06:00:00	AAPL	Stock	172.77	172.92	172.77	172.81	9288.0
2023-05-18 07:00:00	AAPL	Stock	172.81	172.92	172.69	172.79	31786.0
2023-05-18 08:00:00	AAPL	Stock	172.89	172.92	172.22	172.389	177765.0
2023-05-18 09:00:00	AAPL	Stock	172.39	173.5	172.38	173.09	5738720.0
2023-05-18 10:00:00	AAPL	Stock	173.09	174.36	172.82	174.295	8136620.0
2023-05-18 11:00:00	AAPL	Stock	174.3	175.01	174.25	174.8057	7248021.0
2023-05-18 12:00:00	AAPL	Stock	174.8	174.875	174.13	174.2797	4785601.0
2023-05-18 13:00:00	AAPL	Stock	174.28	174.85	173.76	173.8201	4375492.0
2023-05-18 14:00:00	AAPL	Stock	173.825	174.69	173.68	174.425	3746502.0
2023-05-18 15:00:00	AAPL	Stock	174.425	175.24	174.22	175.07	10714901.0
2023-05-18 16:00:00	AAPL	Stock	175.07	175.31	175.01	175.26	8737580.0
2023-05-18 17:00:00	AAPL	Stock	175.2618	175.3	175.05	175.26	94952.0
2023-05-18 18:00:00	AAPL	Stock	175.22	176.13	175.22	175.84	131736.0
2023-05-18 19:00:00	AAPL	Stock	175.81	175.9	175.65	175.8999	55635.0
2023-05-18 04:00:00	MSFT	Stock	314.29	314.9	314.29	314.55	1092.0
2023-05-18 05:00:00	MSFT	Stock	314.2	314.63	314.18	314.28	1012.0
2023-05-18 06:00:00	MSFT	Stock	314.21	314.4	314.2	314.4	446.0
2023-05-18 07:00:00	MSFT	Stock	314.42	314.65	314.42	314.62	5175.0
2023-05-18 08:00:00	MSFT	Stock	314.4986	315.2	313.71	314.26	48448.0
2023-05-18 09:00:00	MSFT	Stock	314.26	315.87	313.72	315.34	2236554.0
2023-05-18 10:00:00	MSFT	Stock	315.35	316.77	314.53	315.96	2686173.0
2023-05-18 11:00:00	MSFT	Stock	315.92	318.0	315.865	317.0	2196804.0
2023-05-18 12:00:00	MSFT	Stock	317.01	317.49	315.965	316.23	1881319.0
2023-05-18 13:00:00	MSFT	Stock	316.23	317.51	316.13	316.26	1587787.0
2023-05-18 14:00:00	MSFT	Stock	316.255	317.45	316.09	317.3	1398793.0
2023-05-18 15:00:00	MSFT	Stock	317.3	319.04	317.19	318.56	3336792.0
2023-05-18 16:00:00	MSFT	Stock	318.57	319.0	318.3	319.0	4295013.0
2023-05-18 17:00:00	MSFT	Stock	318.77	318.97	318.46	318.61	24182.0
2023-05-18 18:00:00	MSFT	Stock	318.61	320.0	318.61	319.8	39890.0
2023-05-18 19:00:00	MSFT	Stock	319.9	319.9	319.07	319.3199	15787.0
2023-05-18 04:00:00	NVDA	Stock	30.269	30.459	30.269	30.401	238140.0
2023-05-18 05:00:00	NVDA	Stock	30.401	30.445	30.3	30.408	258250.0
2023-05-18 06:00:00	NVDA	Stock	30.38	30.645	30.38	30.541	293060.0
2023-05-18 07:00:00	NVDA	Stock	30.538	30.626	30.531	30.556	828430.0
2023-05-18 08:00:00	NVDA	Stock	30.54	30.625	30.234	30.439	2514800.0
2023-05-18 09:00:00	NVDA	Stock	30.44	30.832	30.32	30.797	71586090.0
2023-05-18 10:00:00	NVDA	Stock	30.7945	31.1383	30.7569	31.1313	87753770.0
2023-05-18 11:00:00	NVDA	Stock	31.1315	31.824	31.1175	31.63	114784100.0
2023-05-18 12:00:00	NVDA	Stock	31.63	31.66	31.252	31.493	80205460.0
2023-05-18 13:00:00	NVDA	Stock	31.4928	31.692	31.25	31.273	62307640.0
2023-05-18 14:00:00	NVDA	Stock	31.272	31.675	31.2535	31.671	59226580.0
2023-05-18 15:00:00	NVDA	Stock	31.6754	31.828	31.558	31.6789	89413470.0
2023-05-18 16:00:00	NVDA	Stock	31.678	31.699	31.592	31.6841	24424450.0
2023-05-18 17:00:00	NVDA	Stock	31.696	31.795	31.69	31.752	917210.0
2023-05-18 18:00:00	NVDA	Stock	31.759	31.89	31.72	31.8895	963500.0
2023-05-18 19:00:00	NVDA	Stock	31.886	31.908	31.798	31.85	915990.0
2023-05-18 04:00:00	AMZN	Stock	115.48	115.95	115.48	115.9	13385.0
2023-05-18 05:00:00	AMZN	Stock	115.9	115.9	115.78	115.78	10547.0

> showing 50 of 60,163 rows — these rows as CSV

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