PREVIEW / stock_1hour / 2023-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-02.parquet
  size:    1.3 MB
  rows:    59,339
  symbols: 1,346

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-11-02 04:00:00	AAPL	Stock	174.99	175.23	174.7	175.2	25860.0
2023-11-02 05:00:00	AAPL	Stock	175.21	175.63	175.18	175.6	28674.0
2023-11-02 06:00:00	AAPL	Stock	175.48	175.67	175.33	175.64	17054.0
2023-11-02 07:00:00	AAPL	Stock	175.66	175.93	175.51	175.63	77131.0
2023-11-02 08:00:00	AAPL	Stock	175.6026	176.8	174.755	176.48	289764.0
2023-11-02 09:00:00	AAPL	Stock	176.4	176.79	175.25	176.36	6235607.0
2023-11-02 10:00:00	AAPL	Stock	176.35	177.54	176.11	177.44	7969098.0
2023-11-02 11:00:00	AAPL	Stock	177.44	177.66	176.4388	176.7986	6061551.0
2023-11-02 12:00:00	AAPL	Stock	176.8	177.315	176.41	176.975	5021483.0
2023-11-02 13:00:00	AAPL	Stock	176.97	177.61	176.78	177.31	4186648.0
2023-11-02 14:00:00	AAPL	Stock	177.3	177.5	177.09	177.455	4457300.0
2023-11-02 15:00:00	AAPL	Stock	177.45	177.78	177.17	177.78	11948957.0
2023-11-02 16:00:00	AAPL	Stock	177.57	181.9	173.45	175.9	12190398.0
2023-11-02 17:00:00	AAPL	Stock	175.9	177.57	169.33	171.53	3628568.0
2023-11-02 18:00:00	AAPL	Stock	171.56	173.11	171.11	172.28	832427.0
2023-11-02 19:00:00	AAPL	Stock	172.16	172.38	171.2	171.57	499029.0
2023-11-02 04:00:00	MSFT	Stock	347.1	349.4	346.94	349.4	18434.0
2023-11-02 05:00:00	MSFT	Stock	349.14	349.15	348.52	348.55	4255.0
2023-11-02 06:00:00	MSFT	Stock	348.59	348.76	348.03	348.65	9123.0
2023-11-02 07:00:00	MSFT	Stock	348.62	349.35	348.5	348.65	49101.0
2023-11-02 08:00:00	MSFT	Stock	348.99	349.6	346.08	349.5	97608.0
2023-11-02 09:00:00	MSFT	Stock	349.4	349.57	344.77	346.43	3520902.0
2023-11-02 10:00:00	MSFT	Stock	346.43	348.77	345.3	348.54	2676999.0
2023-11-02 11:00:00	MSFT	Stock	348.55	348.8	346.64	347.32	1718336.0
2023-11-02 12:00:00	MSFT	Stock	347.37	348.28	346.48	347.7399	1106286.0
2023-11-02 13:00:00	MSFT	Stock	347.71	348.5	347.365	347.7	1133584.0
2023-11-02 14:00:00	MSFT	Stock	347.69	348.03	347.3	347.5	1056457.0
2023-11-02 15:00:00	MSFT	Stock	347.47	348.83	346.91	348.4	2797566.0
2023-11-02 16:00:00	MSFT	Stock	348.32	348.96	347.43	348.96	3451301.0
2023-11-02 17:00:00	MSFT	Stock	348.86	349.25	348.35	348.5586	51015.0
2023-11-02 18:00:00	MSFT	Stock	348.54	349.41	348.54	349.2	16596.0
2023-11-02 19:00:00	MSFT	Stock	349.36	349.75	349.06	349.27	24720.0
2023-11-02 04:00:00	NVDA	Stock	42.9	43.3	42.9	43.213	271060.0
2023-11-02 05:00:00	NVDA	Stock	43.222	43.3	43.199	43.202	97140.0
2023-11-02 06:00:00	NVDA	Stock	43.156	43.218	43.09	43.168	108590.0
2023-11-02 07:00:00	NVDA	Stock	43.105	43.245	43.05	43.245	927730.0
2023-11-02 08:00:00	NVDA	Stock	42.96	43.472	42.889	43.442	3966540.0
2023-11-02 09:00:00	NVDA	Stock	43.442	43.59	43.003	43.2185	61569030.0
2023-11-02 10:00:00	NVDA	Stock	43.226	43.445	42.894	43.3205	59966740.0
2023-11-02 11:00:00	NVDA	Stock	43.319	43.41	43.0651	43.141	32284030.0
2023-11-02 12:00:00	NVDA	Stock	43.136	43.327	43.058	43.249	24500920.0
2023-11-02 13:00:00	NVDA	Stock	43.246	43.423	43.203	43.3945	16536380.0
2023-11-02 14:00:00	NVDA	Stock	43.392	43.709	43.226	43.6786	36680650.0
2023-11-02 15:00:00	NVDA	Stock	43.6766	43.884	43.481	43.511	59129790.0
2023-11-02 16:00:00	NVDA	Stock	43.512	43.625	43.38	43.48	17969810.0
2023-11-02 17:00:00	NVDA	Stock	43.47	43.4973	43.133	43.2	745050.0
2023-11-02 18:00:00	NVDA	Stock	43.2	43.32	43.19	43.26	616940.0
2023-11-02 19:00:00	NVDA	Stock	43.27	43.332	43.2	43.26	447670.0
2023-11-02 04:00:00	AMZN	Stock	137.45	137.99	137.21	137.79	52097.0
2023-11-02 05:00:00	AMZN	Stock	137.79	137.94	137.7	137.79	23910.0

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

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