PREVIEW / stock_1hour / 2022-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-18.parquet
  size:    1.4 MB
  rows:    63,929
  symbols: 2,305

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-07-18 04:00:00	AAPL	Stock	150.61	151.9	150.61	151.7	42842.0
2022-07-18 05:00:00	AAPL	Stock	151.69	151.75	151.4	151.5	18726.0
2022-07-18 06:00:00	AAPL	Stock	151.45	151.57	151.4	151.51	11176.0
2022-07-18 07:00:00	AAPL	Stock	151.5	151.7	151.31	151.45	111781.0
2022-07-18 08:00:00	AAPL	Stock	151.5499	151.7	150.87	151.19	305905.0
2022-07-18 09:00:00	AAPL	Stock	151.19	151.38	150.27	151.1024	8892709.0
2022-07-18 10:00:00	AAPL	Stock	151.12	151.57	150.5812	151.195	7557906.0
2022-07-18 11:00:00	AAPL	Stock	151.21	151.43	150.82	151.405	5125775.0
2022-07-18 12:00:00	AAPL	Stock	151.41	151.41	150.71	150.75	3138864.0
2022-07-18 13:00:00	AAPL	Stock	150.7499	150.7937	147.2	147.795	14095126.0
2022-07-18 14:00:00	AAPL	Stock	147.79	148.24	147.21	147.3	10235208.0
2022-07-18 15:00:00	AAPL	Stock	147.29	147.84	146.7	147.13	11891356.0
2022-07-18 16:00:00	AAPL	Stock	147.13	147.18	146.82	146.89	6098172.0
2022-07-18 17:00:00	AAPL	Stock	146.9	147.07	146.44	146.5	144002.0
2022-07-18 18:00:00	AAPL	Stock	146.54	146.75	146.3	146.73	73524.0
2022-07-18 19:00:00	AAPL	Stock	146.73	147.0	146.3	146.9	80651.0
2022-07-18 04:00:00	MSFT	Stock	258.63	260.68	258.63	260.14	19714.0
2022-07-18 05:00:00	MSFT	Stock	259.96	260.0	259.7	259.7	2747.0
2022-07-18 06:00:00	MSFT	Stock	259.6	260.1	259.6	260.0	9382.0
2022-07-18 07:00:00	MSFT	Stock	260.0	260.08	259.7	259.9	18620.0
2022-07-18 08:00:00	MSFT	Stock	260.095	260.15	258.08	259.37	41393.0
2022-07-18 09:00:00	MSFT	Stock	259.11	260.57	258.55	259.91	2075245.0
2022-07-18 10:00:00	MSFT	Stock	259.91	260.84	257.7	258.3701	2134972.0
2022-07-18 11:00:00	MSFT	Stock	258.4	258.92	256.91	258.82	2132242.0
2022-07-18 12:00:00	MSFT	Stock	258.81	259.3	258.33	258.67	995141.0
2022-07-18 13:00:00	MSFT	Stock	258.6665	258.86	255.67	255.87	1093509.0
2022-07-18 14:00:00	MSFT	Stock	255.815	256.48	255.22	255.27	1192033.0
2022-07-18 15:00:00	MSFT	Stock	255.27	255.71	253.3	254.32	2572750.0
2022-07-18 16:00:00	MSFT	Stock	254.38	254.38	253.9	254.37	3325616.0
2022-07-18 17:00:00	MSFT	Stock	254.3	254.37	254.21	254.3	6844.0
2022-07-18 18:00:00	MSFT	Stock	254.3	254.89	254.2	254.6	9943.0
2022-07-18 19:00:00	MSFT	Stock	254.26	255.2	254.26	255.02	6802.0
2022-07-18 04:00:00	NVDA	Stock	16.0	16.247	15.943	16.23	561680.0
2022-07-18 05:00:00	NVDA	Stock	16.226	16.24	16.18	16.2	131390.0
2022-07-18 06:00:00	NVDA	Stock	16.19	16.2	16.161	16.17	105330.0
2022-07-18 07:00:00	NVDA	Stock	16.17	16.239	16.16	16.224	631040.0
2022-07-18 08:00:00	NVDA	Stock	16.2	16.36	16.069	16.33	3154140.0
2022-07-18 09:00:00	NVDA	Stock	16.319	16.7115	16.223	16.6108	93958950.0
2022-07-18 10:00:00	NVDA	Stock	16.615	16.6575	16.374	16.527	84456500.0
2022-07-18 11:00:00	NVDA	Stock	16.528	16.837	16.512	16.8194	59612640.0
2022-07-18 12:00:00	NVDA	Stock	16.82	16.897	16.649	16.669	58889700.0
2022-07-18 13:00:00	NVDA	Stock	16.669	16.71	16.205	16.217	68868350.0
2022-07-18 14:00:00	NVDA	Stock	16.216	16.316	16.061	16.088	75982200.0
2022-07-18 15:00:00	NVDA	Stock	16.087	16.223	16.002	16.099	70406740.0
2022-07-18 16:00:00	NVDA	Stock	16.101	16.115	16.0	16.06	18674250.0
2022-07-18 17:00:00	NVDA	Stock	16.035	16.101	16.015	16.045	645120.0
2022-07-18 18:00:00	NVDA	Stock	16.047	16.12	16.025	16.1	518500.0
2022-07-18 19:00:00	NVDA	Stock	16.1	16.197	16.075	16.142	691050.0
2022-07-18 04:00:00	AMZN	Stock	114.9	115.29	114.22	115.27	24365.0
2022-07-18 05:00:00	AMZN	Stock	115.27	115.27	114.93	114.99	7865.0

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

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