PREVIEW / stock_1hour / 2022-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-25.parquet
  size:    1.4 MB
  rows:    61,429
  symbols: 2,312

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-25 04:00:00	AAPL	Stock	154.12	154.44	153.76	154.35	19295.0
2022-07-25 05:00:00	AAPL	Stock	154.34	154.99	154.19	154.97	35759.0
2022-07-25 06:00:00	AAPL	Stock	154.95	155.17	154.79	155.17	27710.0
2022-07-25 07:00:00	AAPL	Stock	155.1	155.29	154.55	154.77	101347.0
2022-07-25 08:00:00	AAPL	Stock	155.0793	155.2397	153.39	154.46	332013.0
2022-07-25 09:00:00	AAPL	Stock	154.42	155.04	153.5125	153.5355	7515231.0
2022-07-25 10:00:00	AAPL	Stock	153.5499	153.94	152.455	153.099	8643418.0
2022-07-25 11:00:00	AAPL	Stock	153.0909	153.7199	152.358	153.645	5937285.0
2022-07-25 12:00:00	AAPL	Stock	153.6484	154.08	153.25	153.709	4240442.0
2022-07-25 13:00:00	AAPL	Stock	153.72	153.97	153.25	153.28	2927943.0
2022-07-25 14:00:00	AAPL	Stock	153.28	153.34	152.495	152.6099	3865865.0
2022-07-25 15:00:00	AAPL	Stock	152.61	153.02	152.28	152.949	7927893.0
2022-07-25 16:00:00	AAPL	Stock	152.98	153.15	152.0	152.63	4655489.0
2022-07-25 17:00:00	AAPL	Stock	152.72	152.78	152.41	152.54	64070.0
2022-07-25 18:00:00	AAPL	Stock	152.55	152.69	152.42	152.55	52785.0
2022-07-25 19:00:00	AAPL	Stock	152.51	152.68	152.25	152.68	51234.0
2022-07-25 04:00:00	MSFT	Stock	260.49	261.69	260.49	261.5	8948.0
2022-07-25 05:00:00	MSFT	Stock	261.5	261.89	261.5	261.89	3535.0
2022-07-25 06:00:00	MSFT	Stock	262.0	262.0	261.56	261.75	3156.0
2022-07-25 07:00:00	MSFT	Stock	261.75	261.8	261.23	261.31	17454.0
2022-07-25 08:00:00	MSFT	Stock	261.35	261.94	259.71	261.75	40545.0
2022-07-25 09:00:00	MSFT	Stock	261.4722	261.85	257.15	258.11	2356868.0
2022-07-25 10:00:00	MSFT	Stock	258.15	259.1902	256.81	258.88	1943501.0
2022-07-25 11:00:00	MSFT	Stock	258.88	259.71	257.9	259.2	1417047.0
2022-07-25 12:00:00	MSFT	Stock	259.19	259.63	258.1401	259.045	922759.0
2022-07-25 13:00:00	MSFT	Stock	259.071	259.69	258.23	258.23	860407.0
2022-07-25 14:00:00	MSFT	Stock	258.24	258.39	257.2801	257.47	990762.0
2022-07-25 15:00:00	MSFT	Stock	257.46	259.12	256.88	258.82	2556979.0
2022-07-25 16:00:00	MSFT	Stock	259.19	259.38	258.21	258.6	2742496.0
2022-07-25 17:00:00	MSFT	Stock	258.8	259.0	258.15	258.5	14796.0
2022-07-25 18:00:00	MSFT	Stock	258.53	258.74	258.15	258.49	19391.0
2022-07-25 19:00:00	MSFT	Stock	258.31	258.49	258.01	258.36	13788.0
2022-07-25 04:00:00	NVDA	Stock	17.274	17.419	17.274	17.419	108070.0
2022-07-25 05:00:00	NVDA	Stock	17.4	17.44	17.395	17.44	53730.0
2022-07-25 06:00:00	NVDA	Stock	17.453	17.453	17.338	17.38	175520.0
2022-07-25 07:00:00	NVDA	Stock	17.368	17.384	17.268	17.277	268000.0
2022-07-25 08:00:00	NVDA	Stock	17.36	17.385	17.105	17.165	1902910.0
2022-07-25 09:00:00	NVDA	Stock	17.1378	17.2	16.74	16.962	70049440.0
2022-07-25 10:00:00	NVDA	Stock	16.964	16.9899	16.649	16.791	74184370.0
2022-07-25 11:00:00	NVDA	Stock	16.789	16.897	16.663	16.8596	44807730.0
2022-07-25 12:00:00	NVDA	Stock	16.861	16.994	16.789	16.9309	39621720.0
2022-07-25 13:00:00	NVDA	Stock	16.931	16.974	16.795	16.798	33500810.0
2022-07-25 14:00:00	NVDA	Stock	16.799	16.929	16.76	16.853	38424680.0
2022-07-25 15:00:00	NVDA	Stock	16.852	17.039	16.761	17.03	66602710.0
2022-07-25 16:00:00	NVDA	Stock	17.029	17.1	16.975	17.036	22179770.0
2022-07-25 17:00:00	NVDA	Stock	17.002	17.0376	16.9534	16.964	413700.0
2022-07-25 18:00:00	NVDA	Stock	16.974	16.99	16.932	16.958	265840.0
2022-07-25 19:00:00	NVDA	Stock	16.95	16.974	16.92	16.943	235970.0
2022-07-25 04:00:00	AMZN	Stock	122.3	123.04	122.3	123.02	13447.0
2022-07-25 05:00:00	AMZN	Stock	122.99	123.35	122.94	123.2	10792.0

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

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