PREVIEW / stock_1hour / 2022-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-26.parquet
  size:    1.3 MB
  rows:    61,085
  symbols: 2,257

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-26 04:00:00	AAPL	Stock	153.24	153.24	152.08	152.55	22721.0
2022-07-26 05:00:00	AAPL	Stock	152.65	152.85	152.5	152.69	11211.0
2022-07-26 06:00:00	AAPL	Stock	152.83	152.85	152.13	152.4	33910.0
2022-07-26 07:00:00	AAPL	Stock	152.35	152.47	152.0	152.11	70937.0
2022-07-26 08:00:00	AAPL	Stock	152.31	152.568	151.5	151.89	333360.0
2022-07-26 09:00:00	AAPL	Stock	151.96	153.085	151.54	152.18	6921832.0
2022-07-26 10:00:00	AAPL	Stock	152.18	152.47	151.1884	151.605	6296129.0
2022-07-26 11:00:00	AAPL	Stock	151.61	151.68	150.85	150.99	4504221.0
2022-07-26 12:00:00	AAPL	Stock	151.0	151.69	150.8	151.63	3977800.0
2022-07-26 13:00:00	AAPL	Stock	151.63	152.18	151.55	151.855	4102417.0
2022-07-26 14:00:00	AAPL	Stock	151.87	152.49	151.3424	151.59	5393203.0
2022-07-26 15:00:00	AAPL	Stock	151.585	151.75	151.1499	151.56	8706756.0
2022-07-26 16:00:00	AAPL	Stock	151.56	152.48	151.33	152.31	6320298.0
2022-07-26 17:00:00	AAPL	Stock	152.44	152.58	152.2	152.37	80356.0
2022-07-26 18:00:00	AAPL	Stock	152.44	152.82	152.08	152.32	381181.0
2022-07-26 19:00:00	AAPL	Stock	152.3	152.83	152.3	152.83	80119.0
2022-07-26 04:00:00	MSFT	Stock	259.17	259.17	258.57	258.98	2952.0
2022-07-26 05:00:00	MSFT	Stock	259.05	259.13	258.7	258.88	1162.0
2022-07-26 06:00:00	MSFT	Stock	259.15	259.15	258.0	258.48	3278.0
2022-07-26 07:00:00	MSFT	Stock	258.72	258.89	258.02	258.5	10066.0
2022-07-26 08:00:00	MSFT	Stock	258.5	258.99	258.15	258.5	32028.0
2022-07-26 09:00:00	MSFT	Stock	258.65	260.88	253.64	255.66	2988344.0
2022-07-26 10:00:00	MSFT	Stock	255.6	255.96	252.87	253.63	2494930.0
2022-07-26 11:00:00	MSFT	Stock	253.64	253.8238	250.65	251.03	2547185.0
2022-07-26 12:00:00	MSFT	Stock	251.02	251.52	249.9	250.2617	2927653.0
2022-07-26 13:00:00	MSFT	Stock	250.2601	251.37	250.0	250.14	1733022.0
2022-07-26 14:00:00	MSFT	Stock	250.15	251.4625	249.69	250.29	2372808.0
2022-07-26 15:00:00	MSFT	Stock	250.28	252.3372	249.57	251.745	5151388.0
2022-07-26 16:00:00	MSFT	Stock	251.819	254.45	243.02	252.8	6041469.0
2022-07-26 17:00:00	MSFT	Stock	252.84	252.9	248.11	249.66	645890.0
2022-07-26 18:00:00	MSFT	Stock	249.85	269.41	249.65	262.56	1727741.0
2022-07-26 19:00:00	MSFT	Stock	262.61	263.4	261.0	261.9	186893.0
2022-07-26 04:00:00	NVDA	Stock	17.024	17.024	16.95	16.95	22890.0
2022-07-26 05:00:00	NVDA	Stock	16.972	16.972	16.972	16.972	4390.0
2022-07-26 06:00:00	NVDA	Stock	16.95	16.95	16.872	16.872	16990.0
2022-07-26 07:00:00	NVDA	Stock	16.884	16.927	16.875	16.89	127080.0
2022-07-26 08:00:00	NVDA	Stock	16.91	17.13	16.81	16.86	954530.0
2022-07-26 09:00:00	NVDA	Stock	16.86	16.924	16.67	16.8215	45662710.0
2022-07-26 10:00:00	NVDA	Stock	16.8215	16.918	16.646	16.767	59678920.0
2022-07-26 11:00:00	NVDA	Stock	16.765	16.785	16.515	16.5171	46618770.0
2022-07-26 12:00:00	NVDA	Stock	16.518	16.658	16.507	16.6412	33726170.0
2022-07-26 13:00:00	NVDA	Stock	16.64	16.692	16.597	16.612	27370970.0
2022-07-26 14:00:00	NVDA	Stock	16.614	16.699	16.507	16.559	30240830.0
2022-07-26 15:00:00	NVDA	Stock	16.559	16.58	16.478	16.531	48758440.0
2022-07-26 16:00:00	NVDA	Stock	16.53	16.742	16.45	16.732	24309400.0
2022-07-26 17:00:00	NVDA	Stock	16.74	16.74	16.635	16.712	772600.0
2022-07-26 18:00:00	NVDA	Stock	16.724	16.9	16.692	16.848	1926870.0
2022-07-26 19:00:00	NVDA	Stock	16.854	16.915	16.811	16.902	868730.0
2022-07-26 04:00:00	AMZN	Stock	117.01	117.38	116.53	117.3	38210.0
2022-07-26 05:00:00	AMZN	Stock	117.38	117.43	117.1	117.4	25187.0

> showing 50 of 61,085 rows — these rows as CSV

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