PREVIEW / stock_1hour / 2023-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-10.parquet
  size:    1.3 MB
  rows:    60,428
  symbols: 1,658

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-10 04:00:00	AAPL	Stock	171.63	171.63	170.85	171.25	17982.0
2023-05-10 05:00:00	AAPL	Stock	171.21	171.37	171.18	171.23	2959.0
2023-05-10 06:00:00	AAPL	Stock	171.26	171.41	171.26	171.41	1096.0
2023-05-10 07:00:00	AAPL	Stock	171.41	171.8	171.41	171.7	31149.0
2023-05-10 08:00:00	AAPL	Stock	171.5987	173.23	171.19	173.11	572111.0
2023-05-10 09:00:00	AAPL	Stock	173.12	174.03	172.55	172.986	6657021.0
2023-05-10 10:00:00	AAPL	Stock	172.985	173.71	172.29	172.555	7243921.0
2023-05-10 11:00:00	AAPL	Stock	172.56	173.83	172.55	173.49	4725619.0
2023-05-10 12:00:00	AAPL	Stock	173.4866	173.4866	172.73	172.81	3947331.0
2023-05-10 13:00:00	AAPL	Stock	172.8	172.9499	171.9	172.28	4028607.0
2023-05-10 14:00:00	AAPL	Stock	172.275	173.16	172.26	173.065	3456266.0
2023-05-10 15:00:00	AAPL	Stock	173.07	173.91	172.945	173.5504	7554660.0
2023-05-10 16:00:00	AAPL	Stock	173.55	173.63	173.31	173.38	7262237.0
2023-05-10 17:00:00	AAPL	Stock	173.39	173.44	173.38	173.42	11053.0
2023-05-10 18:00:00	AAPL	Stock	173.42	173.55	173.32	173.46	23604.0
2023-05-10 19:00:00	AAPL	Stock	173.46	173.65	173.4	173.65	20859.0
2023-05-10 04:00:00	MSFT	Stock	306.48	306.48	305.45	305.5	5896.0
2023-05-10 05:00:00	MSFT	Stock	305.72	305.79	305.3	305.55	1530.0
2023-05-10 06:00:00	MSFT	Stock	305.4	305.99	305.4	305.99	424.0
2023-05-10 07:00:00	MSFT	Stock	306.14	307.2	306.0	307.06	10787.0
2023-05-10 08:00:00	MSFT	Stock	306.0	309.24	305.2315	308.88	152059.0
2023-05-10 09:00:00	MSFT	Stock	308.81	310.34	307.67	309.94	3056224.0
2023-05-10 10:00:00	MSFT	Stock	310.0	311.58	308.62	309.84	3386627.0
2023-05-10 11:00:00	MSFT	Stock	309.87	311.339	309.49	311.1	1647349.0
2023-05-10 12:00:00	MSFT	Stock	311.11	311.2	310.03	310.61	1726844.0
2023-05-10 13:00:00	MSFT	Stock	310.6	311.0	309.19	310.68	2021822.0
2023-05-10 14:00:00	MSFT	Stock	310.67	312.06	310.51	311.805	2205591.0
2023-05-10 15:00:00	MSFT	Stock	311.81	313.0	311.61	312.33	3767392.0
2023-05-10 16:00:00	MSFT	Stock	312.31	312.3983	312.01	312.13	3253796.0
2023-05-10 17:00:00	MSFT	Stock	312.13	312.1377	312.05	312.08	10437.0
2023-05-10 18:00:00	MSFT	Stock	312.08	312.22	312.05	312.11	6055.0
2023-05-10 19:00:00	MSFT	Stock	312.28	312.37	312.16	312.3	4511.0
2023-05-10 04:00:00	NVDA	Stock	28.45	28.493	28.442	28.493	35380.0
2023-05-10 05:00:00	NVDA	Stock	28.474	28.511	28.474	28.511	8310.0
2023-05-10 06:00:00	NVDA	Stock	28.51	28.523	28.499	28.5	17270.0
2023-05-10 07:00:00	NVDA	Stock	28.529	28.623	28.502	28.571	262300.0
2023-05-10 08:00:00	NVDA	Stock	28.613	28.998	28.518	28.989	3694230.0
2023-05-10 09:00:00	NVDA	Stock	28.9877	29.113	28.6887	28.885	44802740.0
2023-05-10 10:00:00	NVDA	Stock	28.89	29.096	28.681	28.784	55106880.0
2023-05-10 11:00:00	NVDA	Stock	28.783	29.0127	28.758	28.924	31965800.0
2023-05-10 12:00:00	NVDA	Stock	28.92	28.953	28.7686	28.809	23435780.0
2023-05-10 13:00:00	NVDA	Stock	28.808	28.819	28.4613	28.607	32017640.0
2023-05-10 14:00:00	NVDA	Stock	28.603	28.899	28.58	28.8395	37766990.0
2023-05-10 15:00:00	NVDA	Stock	28.8416	29.032	28.792	28.886	40823520.0
2023-05-10 16:00:00	NVDA	Stock	28.885	28.9	28.882	28.89	16032780.0
2023-05-10 17:00:00	NVDA	Stock	28.885	28.935	28.885	28.93	203660.0
2023-05-10 18:00:00	NVDA	Stock	28.922	28.945	28.91	28.927	89400.0
2023-05-10 19:00:00	NVDA	Stock	28.927	28.93	28.91	28.915	163960.0
2023-05-10 04:00:00	AMZN	Stock	106.0	106.49	105.75	106.07	17023.0
2023-05-10 05:00:00	AMZN	Stock	106.16	106.29	106.1	106.29	3285.0

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

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