PREVIEW / stock_1hour / 2022-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-05.parquet
  size:    1.4 MB
  rows:    63,192
  symbols: 2,415

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
2022-05-05 04:00:00	AAPL	Stock	164.39	165.06	164.08	164.48	16843.0
2022-05-05 05:00:00	AAPL	Stock	164.6	164.8	164.5	164.65	7731.0
2022-05-05 06:00:00	AAPL	Stock	164.65	165.0	164.65	164.7	28618.0
2022-05-05 07:00:00	AAPL	Stock	164.87	165.33	164.65	164.84	78832.0
2022-05-05 08:00:00	AAPL	Stock	164.8	165.79	164.3756	164.5512	458659.0
2022-05-05 09:00:00	AAPL	Stock	164.55	164.55	161.24	161.64	10950232.0
2022-05-05 10:00:00	AAPL	Stock	161.64	161.78	159.2	160.19	14989135.0
2022-05-05 11:00:00	AAPL	Stock	160.19	160.35	157.71	157.73	14361241.0
2022-05-05 12:00:00	AAPL	Stock	157.73	158.52	156.57	157.53	14249030.0
2022-05-05 13:00:00	AAPL	Stock	157.54	158.32	156.47	156.79	10065864.0
2022-05-05 14:00:00	AAPL	Stock	156.79	157.56	156.25	156.385	9817342.0
2022-05-05 15:00:00	AAPL	Stock	156.39	157.58	154.95	156.81	26507255.0
2022-05-05 16:00:00	AAPL	Stock	156.81	157.87	156.77	157.84	13769452.0
2022-05-05 17:00:00	AAPL	Stock	157.84	157.9	157.4	157.51	108873.0
2022-05-05 18:00:00	AAPL	Stock	157.55	157.56	157.03	157.33	76757.0
2022-05-05 19:00:00	AAPL	Stock	157.22	157.96	157.2	157.96	109075.0
2022-05-05 04:00:00	MSFT	Stock	288.98	289.22	286.91	287.6	7073.0
2022-05-05 05:00:00	MSFT	Stock	287.43	287.43	287.43	287.43	117.0
2022-05-05 06:00:00	MSFT	Stock	287.95	288.39	287.91	287.91	1233.0
2022-05-05 07:00:00	MSFT	Stock	287.89	288.45	287.08	287.75	12432.0
2022-05-05 08:00:00	MSFT	Stock	287.5011	288.35	287.0	287.2494	23328.0
2022-05-05 09:00:00	MSFT	Stock	287.15	287.15	282.16	282.42	2553747.0
2022-05-05 10:00:00	MSFT	Stock	282.42	282.5	275.8601	277.62	4989915.0
2022-05-05 11:00:00	MSFT	Stock	277.6	278.72	275.53	276.2	2977463.0
2022-05-05 12:00:00	MSFT	Stock	276.22	278.3515	275.27	276.92	2861744.0
2022-05-05 13:00:00	MSFT	Stock	276.92	278.23	275.7	276.095	2606471.0
2022-05-05 14:00:00	MSFT	Stock	276.08	277.29	275.3	276.4336	2006989.0
2022-05-05 15:00:00	MSFT	Stock	276.43	278.07	274.34	277.52	7225667.0
2022-05-05 16:00:00	MSFT	Stock	277.56	279.44	277.35	278.01	6765512.0
2022-05-05 17:00:00	MSFT	Stock	277.35	278.2	277.35	278.0	21919.0
2022-05-05 18:00:00	MSFT	Stock	278.0	278.0	277.1	277.1	10754.0
2022-05-05 19:00:00	MSFT	Stock	277.2501	278.2	277.2501	278.2	11591.0
2022-05-05 04:00:00	NVDA	Stock	20.11	20.128	19.862	19.965	195260.0
2022-05-05 05:00:00	NVDA	Stock	19.961	20.048	19.95	20.03	111180.0
2022-05-05 06:00:00	NVDA	Stock	20.02	20.107	20.006	20.05	49240.0
2022-05-05 07:00:00	NVDA	Stock	20.075	20.15	20.04	20.085	240620.0
2022-05-05 08:00:00	NVDA	Stock	20.093	20.442	19.965	19.99	992830.0
2022-05-05 09:00:00	NVDA	Stock	19.98	19.9876	19.357	19.3785	50677670.0
2022-05-05 10:00:00	NVDA	Stock	19.386	19.3927	18.847	19.0167	82272620.0
2022-05-05 11:00:00	NVDA	Stock	19.0145	19.0225	18.65	18.691	64642680.0
2022-05-05 12:00:00	NVDA	Stock	18.688	19.085	18.606	18.9805	64340500.0
2022-05-05 13:00:00	NVDA	Stock	18.9823	19.219	18.671	18.6775	52397180.0
2022-05-05 14:00:00	NVDA	Stock	18.678	18.875	18.606	18.81	54537750.0
2022-05-05 15:00:00	NVDA	Stock	18.806	18.905	18.5	18.848	84772200.0
2022-05-05 16:00:00	NVDA	Stock	18.849	19.021	18.844	18.9123	35688660.0
2022-05-05 17:00:00	NVDA	Stock	18.915	18.9378	18.906	18.916	134400.0
2022-05-05 18:00:00	NVDA	Stock	18.916	18.92	18.865	18.894	331280.0
2022-05-05 19:00:00	NVDA	Stock	18.9	18.938	18.88	18.901	286900.0
2022-05-05 07:00:00	AMZN	Stock	124.8895	124.8895	124.0	124.3	30200.0
2022-05-05 08:00:00	AMZN	Stock	124.75	124.75	124.0255	124.1195	57040.0

> showing 50 of 63,192 rows — these rows as CSV

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