PREVIEW / stock_1hour / 2022-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-05.parquet
  size:    1.4 MB
  rows:    62,251
  symbols: 2,056

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-12-05 04:00:00	AAPL	Stock	148.0	148.0	147.37	147.61	44123.0
2022-12-05 05:00:00	AAPL	Stock	147.61	147.9	147.59	147.85	14882.0
2022-12-05 06:00:00	AAPL	Stock	147.85	148.42	147.85	148.29	23846.0
2022-12-05 07:00:00	AAPL	Stock	148.15	148.28	147.54	147.78	70946.0
2022-12-05 08:00:00	AAPL	Stock	148.07	148.21	147.3043	147.4	244273.0
2022-12-05 09:00:00	AAPL	Stock	147.4	150.9199	147.32	149.96	11976368.0
2022-12-05 10:00:00	AAPL	Stock	149.96	150.01	147.62	147.89	11481621.0
2022-12-05 11:00:00	AAPL	Stock	147.9	148.2	146.37	146.468	7183290.0
2022-12-05 12:00:00	AAPL	Stock	146.451	147.28	146.42	146.66	4656347.0
2022-12-05 13:00:00	AAPL	Stock	146.66	146.9	146.12	146.1602	4226226.0
2022-12-05 14:00:00	AAPL	Stock	146.16	146.43	145.77	146.0353	4696792.0
2022-12-05 15:00:00	AAPL	Stock	146.03	146.8	145.8	146.61	8510858.0
2022-12-05 16:00:00	AAPL	Stock	146.62	146.98	146.6	146.88	7595683.0
2022-12-05 17:00:00	AAPL	Stock	146.87	146.88	146.63	146.7982	29358.0
2022-12-05 18:00:00	AAPL	Stock	146.78	146.99	146.76	146.85	37356.0
2022-12-05 19:00:00	AAPL	Stock	146.9	147.04	146.86	146.96	41155.0
2022-12-05 04:00:00	MSFT	Stock	253.92	253.92	253.03	253.4	3184.0
2022-12-05 05:00:00	MSFT	Stock	253.67	253.77	253.5	253.69	3551.0
2022-12-05 06:00:00	MSFT	Stock	253.9	254.15	253.85	254.13	876.0
2022-12-05 07:00:00	MSFT	Stock	254.03	254.39	253.65	253.83	7528.0
2022-12-05 08:00:00	MSFT	Stock	254.0047	254.51	253.15	253.15	35754.0
2022-12-05 09:00:00	MSFT	Stock	253.25	253.819	251.61	252.63	2039491.0
2022-12-05 10:00:00	MSFT	Stock	252.63	252.86	251.07	252.76	1738397.0
2022-12-05 11:00:00	MSFT	Stock	252.77	253.38	250.47	250.8935	1951619.0
2022-12-05 12:00:00	MSFT	Stock	250.88	250.99	249.15	249.2	1893218.0
2022-12-05 13:00:00	MSFT	Stock	249.17	249.93	248.73	248.75	1339644.0
2022-12-05 14:00:00	MSFT	Stock	248.67	249.16	248.06	248.76	1463651.0
2022-12-05 15:00:00	MSFT	Stock	248.76	250.5	248.48	250.21	3094664.0
2022-12-05 16:00:00	MSFT	Stock	250.2	250.46	250.0	250.2	4621973.0
2022-12-05 17:00:00	MSFT	Stock	250.32	250.32	250.2	250.2	2400.0
2022-12-05 18:00:00	MSFT	Stock	250.35	250.69	250.2	250.4	4180.0
2022-12-05 19:00:00	MSFT	Stock	250.4	250.81	250.4	250.75	3910.0
2022-12-05 04:00:00	NVDA	Stock	16.881	16.881	16.719	16.755	77700.0
2022-12-05 05:00:00	NVDA	Stock	16.765	16.79	16.746	16.772	47020.0
2022-12-05 06:00:00	NVDA	Stock	16.78	16.83	16.78	16.83	13210.0
2022-12-05 07:00:00	NVDA	Stock	16.837	16.86	16.76	16.779	162800.0
2022-12-05 08:00:00	NVDA	Stock	16.8496	16.86	16.71	16.725	444430.0
2022-12-05 09:00:00	NVDA	Stock	16.72	16.845	16.639	16.814	35480530.0
2022-12-05 10:00:00	NVDA	Stock	16.81	16.874	16.665	16.8638	47818400.0
2022-12-05 11:00:00	NVDA	Stock	16.863	16.995	16.7542	16.7879	39679700.0
2022-12-05 12:00:00	NVDA	Stock	16.787	16.838	16.664	16.683	25257320.0
2022-12-05 13:00:00	NVDA	Stock	16.683	16.8125	16.612	16.6185	29740400.0
2022-12-05 14:00:00	NVDA	Stock	16.617	16.673	16.472	16.576	29713550.0
2022-12-05 15:00:00	NVDA	Stock	16.575	16.636	16.512	16.608	40068440.0
2022-12-05 16:00:00	NVDA	Stock	16.61	16.62	16.55	16.617	25964070.0
2022-12-05 17:00:00	NVDA	Stock	16.615	16.643	16.61	16.61	161950.0
2022-12-05 18:00:00	NVDA	Stock	16.626	16.646	16.625	16.637	46080.0
2022-12-05 19:00:00	NVDA	Stock	16.638	16.648	16.631	16.648	132030.0
2022-12-05 04:00:00	AMZN	Stock	94.86	94.86	94.02	94.36	24110.0
2022-12-05 05:00:00	AMZN	Stock	94.43	94.59	94.3	94.4	10709.0

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

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