PREVIEW / stock_1hour / 2023-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-02.parquet
  size:    1.4 MB
  rows:    64,423
  symbols: 1,912

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-02-02 04:00:00	AAPL	Stock	147.14	147.49	146.56	146.98	96285.0
2023-02-02 05:00:00	AAPL	Stock	146.98	147.15	146.83	146.96	44094.0
2023-02-02 06:00:00	AAPL	Stock	147.0	147.09	146.7	146.94	32706.0
2023-02-02 07:00:00	AAPL	Stock	146.95	147.7	146.7	147.69	171937.0
2023-02-02 08:00:00	AAPL	Stock	147.66	148.38	146.0	148.33	832061.0
2023-02-02 09:00:00	AAPL	Stock	148.33	149.51	148.06	148.59	10817080.0
2023-02-02 10:00:00	AAPL	Stock	148.5888	150.5	148.17	150.1508	12557828.0
2023-02-02 11:00:00	AAPL	Stock	150.16	150.44	149.57	149.76	8336851.0
2023-02-02 12:00:00	AAPL	Stock	149.77	150.28	149.43	149.92	6981882.0
2023-02-02 13:00:00	AAPL	Stock	149.93	150.99	149.9	150.955	7688371.0
2023-02-02 14:00:00	AAPL	Stock	150.955	151.18	148.95	149.045	9441027.0
2023-02-02 15:00:00	AAPL	Stock	149.05	150.92	148.72	150.92	15345696.0
2023-02-02 16:00:00	AAPL	Stock	150.93	152.0795	142.3	145.0	17460993.0
2023-02-02 17:00:00	AAPL	Stock	144.9	151.51	143.95	149.8799	4577210.0
2023-02-02 18:00:00	AAPL	Stock	149.77	149.89	145.75	145.9	1275270.0
2023-02-02 19:00:00	AAPL	Stock	145.8501	146.22	145.17	145.99	485877.0
2023-02-02 04:00:00	MSFT	Stock	254.03	254.82	253.15	254.3	31884.0
2023-02-02 05:00:00	MSFT	Stock	254.3	254.61	253.99	254.2	15244.0
2023-02-02 06:00:00	MSFT	Stock	254.2	254.49	253.73	253.9	18462.0
2023-02-02 07:00:00	MSFT	Stock	253.8	254.9	253.47	254.9	47441.0
2023-02-02 08:00:00	MSFT	Stock	253.9	256.5	252.119	255.9	97804.0
2023-02-02 09:00:00	MSFT	Stock	255.8	260.66	255.559	258.12	4483988.0
2023-02-02 10:00:00	MSFT	Stock	258.15	260.79	257.25	260.16	3782072.0
2023-02-02 11:00:00	MSFT	Stock	260.17	263.1399	259.85	261.4	3445159.0
2023-02-02 12:00:00	MSFT	Stock	261.41	261.88	260.6402	261.59	2071885.0
2023-02-02 13:00:00	MSFT	Stock	261.61	264.55	261.32	264.3317	2355005.0
2023-02-02 14:00:00	MSFT	Stock	264.35	264.69	260.93	261.48	3032761.0
2023-02-02 15:00:00	MSFT	Stock	261.52	264.64	260.87	264.61	5089862.0
2023-02-02 16:00:00	MSFT	Stock	264.61	265.15	260.65	262.29	5457254.0
2023-02-02 17:00:00	MSFT	Stock	262.21	264.6	261.7	263.0	74561.0
2023-02-02 18:00:00	MSFT	Stock	262.87	263.28	261.0	261.62	32722.0
2023-02-02 19:00:00	MSFT	Stock	261.5	263.0	261.5	262.83	28489.0
2023-02-02 04:00:00	NVDA	Stock	20.95	21.1	20.914	20.939	239020.0
2023-02-02 05:00:00	NVDA	Stock	20.94	20.95	20.665	20.754	369520.0
2023-02-02 06:00:00	NVDA	Stock	20.75	20.817	20.68	20.73	176320.0
2023-02-02 07:00:00	NVDA	Stock	20.748	20.879	20.66	20.855	487580.0
2023-02-02 08:00:00	NVDA	Stock	20.745	21.061	20.6799	20.974	2482320.0
2023-02-02 09:00:00	NVDA	Stock	20.98	21.53	20.92	21.253	84106760.0
2023-02-02 10:00:00	NVDA	Stock	21.261	21.524	21.117	21.351	73222660.0
2023-02-02 11:00:00	NVDA	Stock	21.354	21.449	21.203	21.247	41417520.0
2023-02-02 12:00:00	NVDA	Stock	21.254	21.745	21.1965	21.684	67239380.0
2023-02-02 13:00:00	NVDA	Stock	21.685	21.94	21.622	21.9393	42974370.0
2023-02-02 14:00:00	NVDA	Stock	21.94	21.949	21.308	21.322	54189160.0
2023-02-02 15:00:00	NVDA	Stock	21.323	21.746	21.235	21.724	60005530.0
2023-02-02 16:00:00	NVDA	Stock	21.735	21.76	21.113	21.235	26401790.0
2023-02-02 17:00:00	NVDA	Stock	21.248	21.48	21.226	21.425	958800.0
2023-02-02 18:00:00	NVDA	Stock	21.402	21.5	21.142	21.142	788770.0
2023-02-02 19:00:00	NVDA	Stock	21.14	21.283	21.128	21.201	402750.0
2023-02-02 04:00:00	AMZN	Stock	109.01	109.88	109.01	109.85	176103.0
2023-02-02 05:00:00	AMZN	Stock	109.84	109.85	109.17	109.33	40420.0

> showing 50 of 64,423 rows — these rows as CSV

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