PREVIEW / stock_1hour / 2021-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-24.parquet
  size:    1.4 MB
  rows:    65,325
  symbols: 2,799

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
2021-08-24 04:00:00	AAPL	Stock	150.0	150.21	149.96	150.04	37573.0
2021-08-24 05:00:00	AAPL	Stock	150.04	150.12	149.69	149.75	20911.0
2021-08-24 06:00:00	AAPL	Stock	149.77	149.8	149.62	149.7	11635.0
2021-08-24 07:00:00	AAPL	Stock	149.73	149.82	149.41	149.53	112259.0
2021-08-24 08:00:00	AAPL	Stock	149.65	149.78	149.336	149.49	221190.0
2021-08-24 09:00:00	AAPL	Stock	149.47	150.86	149.15	150.58	9675613.0
2021-08-24 10:00:00	AAPL	Stock	150.59	150.73	149.925	149.99	7789452.0
2021-08-24 11:00:00	AAPL	Stock	149.9999	149.9999	149.3051	149.83	6710447.0
2021-08-24 12:00:00	AAPL	Stock	149.83	149.9299	149.52	149.56	3685178.0
2021-08-24 13:00:00	AAPL	Stock	149.5505	149.81	149.48	149.6449	3226216.0
2021-08-24 14:00:00	AAPL	Stock	149.65	149.77	149.5	149.74	2984921.0
2021-08-24 15:00:00	AAPL	Stock	149.75	149.905	149.455	149.63	5364957.0
2021-08-24 16:00:00	AAPL	Stock	149.62	149.67	149.32	149.65	3044792.0
2021-08-24 17:00:00	AAPL	Stock	149.64	149.67	149.61	149.6501	21701.0
2021-08-24 18:00:00	AAPL	Stock	149.64	149.66	149.61	149.61	15700.0
2021-08-24 19:00:00	AAPL	Stock	149.6	149.66	149.53	149.58	33845.0
2021-08-24 04:00:00	MSFT	Stock	305.64	305.95	305.5	305.56	7662.0
2021-08-24 05:00:00	MSFT	Stock	305.8	305.8	305.3	305.3	4611.0
2021-08-24 06:00:00	MSFT	Stock	305.35	305.5	305.23	305.5	2359.0
2021-08-24 07:00:00	MSFT	Stock	305.45	305.49	304.63	304.68	23001.0
2021-08-24 08:00:00	MSFT	Stock	305.25	305.411	303.77	304.4	23610.0
2021-08-24 09:00:00	MSFT	Stock	304.38	305.65	303.26	303.7	2058413.0
2021-08-24 10:00:00	MSFT	Stock	303.72	304.46	302.84	302.99	2009470.0
2021-08-24 11:00:00	MSFT	Stock	302.98	303.25	302.0035	302.61	1902040.0
2021-08-24 12:00:00	MSFT	Stock	302.6	302.759	302.0735	302.39	1027101.0
2021-08-24 13:00:00	MSFT	Stock	302.41	303.06	302.3	302.91	856208.0
2021-08-24 14:00:00	MSFT	Stock	302.915	303.22	302.81	303.2	846374.0
2021-08-24 15:00:00	MSFT	Stock	303.19	303.2659	302.24	302.68	2126464.0
2021-08-24 16:00:00	MSFT	Stock	302.62	303.0	302.56	303.0	2758053.0
2021-08-24 17:00:00	MSFT	Stock	302.9	303.23	302.9	303.15	8709.0
2021-08-24 18:00:00	MSFT	Stock	303.1	303.1	302.66	302.76	6353.0
2021-08-24 19:00:00	MSFT	Stock	302.75	302.8	302.5	302.51	10188.0
2021-08-24 04:00:00	NVDA	Stock	22.19	22.19	22.02	22.112	258540.0
2021-08-24 05:00:00	NVDA	Stock	22.12	22.152	22.0	22.0	164400.0
2021-08-24 06:00:00	NVDA	Stock	22.025	22.036	21.977	22.018	87140.0
2021-08-24 07:00:00	NVDA	Stock	21.983	22.099	21.977	22.02	801910.0
2021-08-24 08:00:00	NVDA	Stock	22.05	22.1	21.76	21.845	2317260.0
2021-08-24 09:00:00	NVDA	Stock	21.849	21.886	21.535	21.571	54481010.0
2021-08-24 10:00:00	NVDA	Stock	21.572	21.959	21.557	21.8314	58643390.0
2021-08-24 11:00:00	NVDA	Stock	21.83	21.917	21.69	21.9095	29922580.0
2021-08-24 12:00:00	NVDA	Stock	21.9087	21.935	21.787	21.8136	18797520.0
2021-08-24 13:00:00	NVDA	Stock	21.815	21.867	21.7569	21.7796	14713830.0
2021-08-24 14:00:00	NVDA	Stock	21.782	21.786	21.703	21.766	14801950.0
2021-08-24 15:00:00	NVDA	Stock	21.762	21.913	21.756	21.791	31696870.0
2021-08-24 16:00:00	NVDA	Stock	21.793	21.799	21.75	21.788	9513880.0
2021-08-24 17:00:00	NVDA	Stock	21.786	21.79	21.775	21.782	106770.0
2021-08-24 18:00:00	NVDA	Stock	21.775	21.775	21.701	21.706	326640.0
2021-08-24 19:00:00	NVDA	Stock	21.705	21.729	21.641	21.651	474890.0
2021-08-24 04:00:00	AMZN	Stock	164.1255	164.224	164.1255	164.224	4920.0
2021-08-24 05:00:00	AMZN	Stock	164.4	164.525	164.224	164.224	9380.0

> showing 50 of 65,325 rows — these rows as CSV

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