PREVIEW / stock_1hour / 2022-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-03.parquet
  size:    1.4 MB
  rows:    63,070
  symbols: 2,523

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-03-03 04:00:00	AAPL	Stock	166.35	166.46	165.92	166.41	6953.0
2022-03-03 05:00:00	AAPL	Stock	166.41	166.41	166.02	166.28	4256.0
2022-03-03 06:00:00	AAPL	Stock	166.3	166.79	165.93	166.16	10465.0
2022-03-03 07:00:00	AAPL	Stock	166.23	166.78	166.21	166.53	46905.0
2022-03-03 08:00:00	AAPL	Stock	166.77	167.96	166.144	167.86	548750.0
2022-03-03 09:00:00	AAPL	Stock	167.8599	168.91	167.5199	168.06	9091794.0
2022-03-03 10:00:00	AAPL	Stock	168.065	168.4	166.0101	166.03	9682177.0
2022-03-03 11:00:00	AAPL	Stock	166.02	167.02	165.73	166.83	8100517.0
2022-03-03 12:00:00	AAPL	Stock	166.82	167.9276	166.09	167.11	7852493.0
2022-03-03 13:00:00	AAPL	Stock	167.1	167.8	166.88	167.3693	5498666.0
2022-03-03 14:00:00	AAPL	Stock	167.36	167.91	166.58	166.685	5836427.0
2022-03-03 15:00:00	AAPL	Stock	166.68	166.74	165.55	166.2882	10909199.0
2022-03-03 16:00:00	AAPL	Stock	166.3	166.42	166.01	166.35	6367866.0
2022-03-03 17:00:00	AAPL	Stock	166.34	166.35	165.9	166.08	111536.0
2022-03-03 18:00:00	AAPL	Stock	166.1001	166.39	165.95	166.35	54019.0
2022-03-03 19:00:00	AAPL	Stock	166.39	166.42	162.09	162.95	249336.0
2022-03-03 04:00:00	MSFT	Stock	298.59	299.5	298.59	298.73	2620.0
2022-03-03 05:00:00	MSFT	Stock	299.02	299.13	298.0	298.27	1295.0
2022-03-03 06:00:00	MSFT	Stock	298.62	299.18	298.01	298.01	1611.0
2022-03-03 07:00:00	MSFT	Stock	298.5	299.39	298.5	299.2	8842.0
2022-03-03 08:00:00	MSFT	Stock	299.0501	302.3	298.95	302.17	41493.0
2022-03-03 09:00:00	MSFT	Stock	302.18	303.75	300.5296	300.895	2293277.0
2022-03-03 10:00:00	MSFT	Stock	300.92	301.33	296.42	296.45	2479025.0
2022-03-03 11:00:00	MSFT	Stock	296.42	297.67	296.02	297.25	2108525.0
2022-03-03 12:00:00	MSFT	Stock	297.22	299.37	295.71	297.7758	1940448.0
2022-03-03 13:00:00	MSFT	Stock	297.78	298.53	296.77	297.8501	1703685.0
2022-03-03 14:00:00	MSFT	Stock	297.83	298.36	295.225	295.9	2014847.0
2022-03-03 15:00:00	MSFT	Stock	295.9	296.0	294.05	295.94	3317762.0
2022-03-03 16:00:00	MSFT	Stock	295.94	296.3974	295.83	296.08	3434887.0
2022-03-03 17:00:00	MSFT	Stock	296.5764	296.62	296.1	296.26	3097.0
2022-03-03 18:00:00	MSFT	Stock	296.26	296.97	296.24	296.97	8258.0
2022-03-03 19:00:00	MSFT	Stock	296.93	296.95	291.0	291.8	59870.0
2022-03-03 04:00:00	NVDA	Stock	24.05	24.078	23.962	24.014	46180.0
2022-03-03 05:00:00	NVDA	Stock	24.02	24.038	23.987	24.0	9530.0
2022-03-03 06:00:00	NVDA	Stock	24.023	24.089	23.986	24.0	50490.0
2022-03-03 07:00:00	NVDA	Stock	24.035	24.11	24.0	24.098	166470.0
2022-03-03 08:00:00	NVDA	Stock	24.012	24.316	24.012	24.309	776990.0
2022-03-03 09:00:00	NVDA	Stock	24.3	24.525	23.908	24.077	32272410.0
2022-03-03 10:00:00	NVDA	Stock	24.072	24.316	23.538	23.542	48024650.0
2022-03-03 11:00:00	NVDA	Stock	23.531	24.0	23.469	23.943	39162410.0
2022-03-03 12:00:00	NVDA	Stock	23.947	24.183	23.732	23.9178	36726510.0
2022-03-03 13:00:00	NVDA	Stock	23.9229	24.115	23.7785	23.8115	25732290.0
2022-03-03 14:00:00	NVDA	Stock	23.808	23.93	23.652	23.706	23854120.0
2022-03-03 15:00:00	NVDA	Stock	23.696	23.76	23.514	23.714	44784510.0
2022-03-03 16:00:00	NVDA	Stock	23.714	23.74	23.6134	23.736	18208950.0
2022-03-03 17:00:00	NVDA	Stock	23.725	23.739	23.698	23.739	132890.0
2022-03-03 18:00:00	NVDA	Stock	23.74	23.769	23.703	23.769	94800.0
2022-03-03 19:00:00	NVDA	Stock	23.763	23.789	22.996	22.996	1065750.0
2022-03-03 08:00:00	AMZN	Stock	152.2545	152.55	151.8845	152.55	15180.0
2022-03-03 09:00:00	AMZN	Stock	153.25	153.929	151.55	151.834	3411720.0

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

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