PREVIEW / stock_1hour / 2023-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-13.parquet
  size:    1.3 MB
  rows:    58,085
  symbols: 1,430

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-09-13 04:00:00	AAPL	Stock	176.2	177.0	175.81	175.81	98530.0
2023-09-13 05:00:00	AAPL	Stock	175.81	175.89	175.4	175.54	44010.0
2023-09-13 06:00:00	AAPL	Stock	175.43	175.59	175.2	175.5	49605.0
2023-09-13 07:00:00	AAPL	Stock	175.58	176.73	175.21	176.66	177788.0
2023-09-13 08:00:00	AAPL	Stock	175.44	177.4	175.3	177.1	900835.0
2023-09-13 09:00:00	AAPL	Stock	177.1	177.4982	174.59	175.8082	10826706.0
2023-09-13 10:00:00	AAPL	Stock	175.815	175.8999	174.07	174.735	10761155.0
2023-09-13 11:00:00	AAPL	Stock	174.74	175.77	174.67	175.7325	7053653.0
2023-09-13 12:00:00	AAPL	Stock	175.74	176.23	175.26	175.565	5977289.0
2023-09-13 13:00:00	AAPL	Stock	175.565	175.73	175.09	175.1867	4616093.0
2023-09-13 14:00:00	AAPL	Stock	175.175	175.27	174.36	174.7041	6828037.0
2023-09-13 15:00:00	AAPL	Stock	174.71	175.1994	173.98	174.2	12811499.0
2023-09-13 16:00:00	AAPL	Stock	174.2	174.25	173.85	173.96	9301955.0
2023-09-13 17:00:00	AAPL	Stock	173.96	174.14	173.8	174.1	126125.0
2023-09-13 18:00:00	AAPL	Stock	174.12	174.18	174.0	174.02	50718.0
2023-09-13 19:00:00	AAPL	Stock	174.02	174.15	174.0	174.09	43299.0
2023-09-13 04:00:00	MSFT	Stock	332.0	332.17	331.73	331.77	3191.0
2023-09-13 05:00:00	MSFT	Stock	331.79	332.0	331.79	331.89	1046.0
2023-09-13 06:00:00	MSFT	Stock	331.48	331.64	331.1	331.64	1938.0
2023-09-13 07:00:00	MSFT	Stock	331.65	332.73	331.65	332.5	3828.0
2023-09-13 08:00:00	MSFT	Stock	331.65	332.6	329.85	331.63	53382.0
2023-09-13 09:00:00	MSFT	Stock	331.67	335.27	330.85	334.72	1492797.0
2023-09-13 10:00:00	MSFT	Stock	334.69	334.99	331.9165	334.52	1467436.0
2023-09-13 11:00:00	MSFT	Stock	334.53	335.58	333.9282	334.79	968593.0
2023-09-13 12:00:00	MSFT	Stock	334.83	336.1699	334.46	335.685	874865.0
2023-09-13 13:00:00	MSFT	Stock	335.67	336.85	335.58	336.6	752123.0
2023-09-13 14:00:00	MSFT	Stock	336.6	336.85	334.89	335.85	796755.0
2023-09-13 15:00:00	MSFT	Stock	335.85	336.43	334.46	335.92	1743513.0
2023-09-13 16:00:00	MSFT	Stock	336.07	336.39	335.97	336.39	3194339.0
2023-09-13 17:00:00	MSFT	Stock	336.2	336.3999	336.1	336.3743	2393.0
2023-09-13 18:00:00	MSFT	Stock	336.34	336.41	336.1224	336.3499	8010.0
2023-09-13 19:00:00	MSFT	Stock	336.36	336.5	336.16	336.5	4548.0
2023-09-13 04:00:00	NVDA	Stock	44.87	44.964	44.868	44.87	42510.0
2023-09-13 05:00:00	NVDA	Stock	44.865	44.866	44.839	44.85	9210.0
2023-09-13 06:00:00	NVDA	Stock	44.825	44.825	44.75	44.814	17910.0
2023-09-13 07:00:00	NVDA	Stock	44.825	44.865	44.76	44.842	127710.0
2023-09-13 08:00:00	NVDA	Stock	44.82	44.909	44.351	44.686	2645020.0
2023-09-13 09:00:00	NVDA	Stock	44.665	45.556	44.503	45.264	49630580.0
2023-09-13 10:00:00	NVDA	Stock	45.264	45.458	44.826	45.1789	50507020.0
2023-09-13 11:00:00	NVDA	Stock	45.18	45.81	45.169	45.701	53167810.0
2023-09-13 12:00:00	NVDA	Stock	45.7108	45.865	45.46	45.738	31171700.0
2023-09-13 13:00:00	NVDA	Stock	45.7465	45.93	45.657	45.815	26622500.0
2023-09-13 14:00:00	NVDA	Stock	45.82	45.85	45.331	45.44	31400370.0
2023-09-13 15:00:00	NVDA	Stock	45.4355	45.5408	45.189	45.5	42392380.0
2023-09-13 16:00:00	NVDA	Stock	45.498	45.548	45.485	45.515	14105700.0
2023-09-13 17:00:00	NVDA	Stock	45.527	45.537	45.501	45.537	206930.0
2023-09-13 18:00:00	NVDA	Stock	45.533	45.574	45.511	45.572	163680.0
2023-09-13 19:00:00	NVDA	Stock	45.566	45.798	45.561	45.79	545730.0
2023-09-13 04:00:00	AMZN	Stock	141.25	141.25	141.05	141.05	3151.0
2023-09-13 05:00:00	AMZN	Stock	141.02	141.18	141.02	141.18	2478.0

> showing 50 of 58,085 rows — these rows as CSV

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