PREVIEW / stock_1hour / 2023-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-20.parquet
  size:    1.4 MB
  rows:    62,455
  symbols: 1,615

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-06-20 04:00:00	AAPL	Stock	184.77	184.77	183.9	184.08	30374.0
2023-06-20 05:00:00	AAPL	Stock	184.15	184.25	184.07	184.21	7627.0
2023-06-20 06:00:00	AAPL	Stock	184.25	184.35	184.17	184.34	5229.0
2023-06-20 07:00:00	AAPL	Stock	184.35	184.4	184.02	184.23	35814.0
2023-06-20 08:00:00	AAPL	Stock	184.39	184.6	183.71	184.6	112673.0
2023-06-20 09:00:00	AAPL	Stock	184.67	186.1	183.9	185.305	6546336.0
2023-06-20 10:00:00	AAPL	Stock	185.305	185.97	184.51	184.84	6032142.0
2023-06-20 11:00:00	AAPL	Stock	184.86	185.36	184.79	184.98	3910017.0
2023-06-20 12:00:00	AAPL	Stock	184.98	186.09	184.9	185.74	4190566.0
2023-06-20 13:00:00	AAPL	Stock	185.745	186.04	185.47	185.55	2928833.0
2023-06-20 14:00:00	AAPL	Stock	185.54	185.845	185.22	185.4769	2883839.0
2023-06-20 15:00:00	AAPL	Stock	185.475	185.53	184.81	185.03	5758855.0
2023-06-20 16:00:00	AAPL	Stock	185.03	185.06	184.77	184.79	7154735.0
2023-06-20 17:00:00	AAPL	Stock	184.79	185.01	184.69	184.82	42759.0
2023-06-20 18:00:00	AAPL	Stock	184.77	184.82	184.64	184.7	15129.0
2023-06-20 19:00:00	AAPL	Stock	184.7	184.86	184.7	184.85	22039.0
2023-06-20 04:00:00	MSFT	Stock	343.1	343.18	339.12	339.3	17238.0
2023-06-20 05:00:00	MSFT	Stock	339.5	339.81	339.5	339.81	5398.0
2023-06-20 06:00:00	MSFT	Stock	339.9	340.71	339.9	340.71	4714.0
2023-06-20 07:00:00	MSFT	Stock	340.88	340.88	340.09	340.3	21723.0
2023-06-20 08:00:00	MSFT	Stock	340.4	341.28	340.1	341.28	35755.0
2023-06-20 09:00:00	MSFT	Stock	341.3	342.08	338.6	339.3	3039563.0
2023-06-20 10:00:00	MSFT	Stock	339.25	340.06	335.86	336.807	3508260.0
2023-06-20 11:00:00	MSFT	Stock	336.8	337.8	336.09	336.105	1895447.0
2023-06-20 12:00:00	MSFT	Stock	336.1	339.385	336.0549	339.04	1659604.0
2023-06-20 13:00:00	MSFT	Stock	339.05	339.6986	338.5	338.66	1123796.0
2023-06-20 14:00:00	MSFT	Stock	338.67	339.23	338.215	338.58	902329.0
2023-06-20 15:00:00	MSFT	Stock	338.58	339.11	337.8	338.05	2603854.0
2023-06-20 16:00:00	MSFT	Stock	338.05	338.39	337.57	337.57	3411481.0
2023-06-20 17:00:00	MSFT	Stock	337.7	338.05	337.59	337.9	21034.0
2023-06-20 18:00:00	MSFT	Stock	337.75	337.95	337.53	337.94	5903.0
2023-06-20 19:00:00	MSFT	Stock	337.74	338.48	337.74	338.48	9735.0
2023-06-20 04:00:00	NVDA	Stock	42.694	42.694	42.155	42.155	237810.0
2023-06-20 05:00:00	NVDA	Stock	42.2	42.392	42.2	42.38	177860.0
2023-06-20 06:00:00	NVDA	Stock	42.392	42.71	42.38	42.67	246790.0
2023-06-20 07:00:00	NVDA	Stock	42.684	42.898	42.65	42.809	913380.0
2023-06-20 08:00:00	NVDA	Stock	42.643	42.94	42.181	42.88	1904450.0
2023-06-20 09:00:00	NVDA	Stock	42.88	43.43	42.823	42.983	55363690.0
2023-06-20 10:00:00	NVDA	Stock	42.976	43.234	42.674	42.707	62515350.0
2023-06-20 11:00:00	NVDA	Stock	42.7083	43.183	42.68	43.0	37656540.0
2023-06-20 12:00:00	NVDA	Stock	43.0	43.443	42.892	43.347	38028740.0
2023-06-20 13:00:00	NVDA	Stock	43.344	43.6	43.3045	43.3867	32894840.0
2023-06-20 14:00:00	NVDA	Stock	43.3825	43.578	43.33	43.569	25316480.0
2023-06-20 15:00:00	NVDA	Stock	43.57	43.99	43.441	43.8068	49445390.0
2023-06-20 16:00:00	NVDA	Stock	43.808	43.868	43.75	43.826	15350500.0
2023-06-20 17:00:00	NVDA	Stock	43.825	43.845	43.815	43.835	261360.0
2023-06-20 18:00:00	NVDA	Stock	43.84	43.84	43.765	43.802	363580.0
2023-06-20 19:00:00	NVDA	Stock	43.805	43.83	43.775	43.78	445000.0
2023-06-20 04:00:00	AMZN	Stock	125.0	125.25	124.2	124.22	15571.0
2023-06-20 05:00:00	AMZN	Stock	124.22	124.63	124.17	124.55	7152.0

> showing 50 of 62,455 rows — these rows as CSV

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