PREVIEW / stock_1hour / 2023-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-10.parquet
  size:    1.3 MB
  rows:    60,112
  symbols: 1,543

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-07-10 04:00:00	AAPL	Stock	189.9	190.07	189.2	189.22	73250.0
2023-07-10 05:00:00	AAPL	Stock	189.44	189.5	188.99	189.19	35576.0
2023-07-10 06:00:00	AAPL	Stock	189.13	189.16	188.8	189.16	74169.0
2023-07-10 07:00:00	AAPL	Stock	189.12	190.38	189.12	190.19	122217.0
2023-07-10 08:00:00	AAPL	Stock	189.27	190.42	189.15	189.44	273787.0
2023-07-10 09:00:00	AAPL	Stock	189.45	190.68	187.15	187.62	9333571.0
2023-07-10 10:00:00	AAPL	Stock	187.62	189.51	187.6	188.15	7899573.0
2023-07-10 11:00:00	AAPL	Stock	188.155	188.4514	187.52	187.53	5608635.0
2023-07-10 12:00:00	AAPL	Stock	187.5208	188.13	187.035	188.03	5165410.0
2023-07-10 13:00:00	AAPL	Stock	188.03	188.35	187.76	188.283	3192227.0
2023-07-10 14:00:00	AAPL	Stock	188.29	188.7	187.9936	188.575	3121938.0
2023-07-10 15:00:00	AAPL	Stock	188.58	188.79	188.1	188.63	6774047.0
2023-07-10 16:00:00	AAPL	Stock	188.64	188.74	188.52	188.57	6707206.0
2023-07-10 17:00:00	AAPL	Stock	188.56	188.56	188.51	188.54	16214.0
2023-07-10 18:00:00	AAPL	Stock	188.53	188.62	188.45	188.62	26108.0
2023-07-10 19:00:00	AAPL	Stock	188.54	188.6	188.45	188.5701	23291.0
2023-07-10 04:00:00	MSFT	Stock	334.66	335.98	333.75	334.0	23559.0
2023-07-10 05:00:00	MSFT	Stock	334.24	334.51	333.78	333.91	12606.0
2023-07-10 06:00:00	MSFT	Stock	334.24	334.5	333.64	334.3	20805.0
2023-07-10 07:00:00	MSFT	Stock	334.6	335.17	333.63	334.9	73739.0
2023-07-10 08:00:00	MSFT	Stock	334.62	336.49	333.7	334.49	90460.0
2023-07-10 09:00:00	MSFT	Stock	334.48	337.22	329.23	329.655	4919844.0
2023-07-10 10:00:00	MSFT	Stock	329.72	332.87	329.635	330.4	3662695.0
2023-07-10 11:00:00	MSFT	Stock	330.39	331.12	328.84	328.92	2607630.0
2023-07-10 12:00:00	MSFT	Stock	328.915	330.37	327.59	330.22	2771841.0
2023-07-10 13:00:00	MSFT	Stock	330.2	331.23	329.59	330.055	1566817.0
2023-07-10 14:00:00	MSFT	Stock	330.06	331.67	329.48	331.27	1665775.0
2023-07-10 15:00:00	MSFT	Stock	331.26	331.89	330.22	331.86	3174704.0
2023-07-10 16:00:00	MSFT	Stock	331.85	332.7	331.61	331.72	2978022.0
2023-07-10 17:00:00	MSFT	Stock	331.83	331.85	331.5	331.6	8941.0
2023-07-10 18:00:00	MSFT	Stock	331.61	331.61	331.1201	331.5	3767.0
2023-07-10 19:00:00	MSFT	Stock	331.5	331.5	331.0201	331.29	8519.0
2023-07-10 04:00:00	NVDA	Stock	42.34	42.388	42.18	42.23	213380.0
2023-07-10 05:00:00	NVDA	Stock	42.21	42.38	42.198	42.301	141840.0
2023-07-10 06:00:00	NVDA	Stock	42.301	42.306	42.2	42.3	234100.0
2023-07-10 07:00:00	NVDA	Stock	42.323	42.872	42.323	42.808	1310560.0
2023-07-10 08:00:00	NVDA	Stock	42.322	42.87	42.109	42.706	2035370.0
2023-07-10 09:00:00	NVDA	Stock	42.701	42.811	41.81	41.996	49328150.0
2023-07-10 10:00:00	NVDA	Stock	41.986	42.491	41.945	42.114	50990440.0
2023-07-10 11:00:00	NVDA	Stock	42.11	42.194	41.788	41.8988	32954800.0
2023-07-10 12:00:00	NVDA	Stock	41.9	42.103	41.649	42.084	30802110.0
2023-07-10 13:00:00	NVDA	Stock	42.088	42.148	41.96	42.016	20276590.0
2023-07-10 14:00:00	NVDA	Stock	42.02	42.222	41.91	42.1819	27514700.0
2023-07-10 15:00:00	NVDA	Stock	42.182	42.188	41.925	42.184	31776000.0
2023-07-10 16:00:00	NVDA	Stock	42.185	42.251	42.074	42.205	16074890.0
2023-07-10 17:00:00	NVDA	Stock	42.195	42.22	42.195	42.22	180880.0
2023-07-10 18:00:00	NVDA	Stock	42.205	42.235	42.19	42.203	164600.0
2023-07-10 19:00:00	NVDA	Stock	42.205	42.263	42.2	42.25	248170.0
2023-07-10 04:00:00	AMZN	Stock	129.39	129.5	128.92	129.35	35600.0
2023-07-10 05:00:00	AMZN	Stock	129.23	129.42	128.94	129.02	24266.0

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

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