PREVIEW / stock_1hour / 2022-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-01.parquet
  size:    1.4 MB
  rows:    62,540
  symbols: 2,234

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-09-01 04:00:00	AAPL	Stock	156.0	156.42	155.74	155.98	47977.0
2022-09-01 05:00:00	AAPL	Stock	156.0	156.05	155.51	156.0	19953.0
2022-09-01 06:00:00	AAPL	Stock	156.0	156.14	155.89	156.14	20256.0
2022-09-01 07:00:00	AAPL	Stock	156.03	156.95	155.95	156.58	93354.0
2022-09-01 08:00:00	AAPL	Stock	156.0	157.22	155.29	156.23	489371.0
2022-09-01 09:00:00	AAPL	Stock	156.23	157.48	155.92	157.37	8964952.0
2022-09-01 10:00:00	AAPL	Stock	157.37	157.68	155.74	155.74	9986347.0
2022-09-01 11:00:00	AAPL	Stock	155.75	156.41	155.16	155.5107	8880692.0
2022-09-01 12:00:00	AAPL	Stock	155.515	156.03	154.67	154.96	6587575.0
2022-09-01 13:00:00	AAPL	Stock	154.97	155.99	154.82	155.875	6114430.0
2022-09-01 14:00:00	AAPL	Stock	155.885	157.42	155.79	156.85	7438275.0
2022-09-01 15:00:00	AAPL	Stock	156.85	158.42	156.72	157.97	10091161.0
2022-09-01 16:00:00	AAPL	Stock	157.96	158.5	157.88	158.44	5851490.0
2022-09-01 17:00:00	AAPL	Stock	158.39	158.59	157.96	158.55	77905.0
2022-09-01 18:00:00	AAPL	Stock	158.55	158.7	158.27	158.27	59718.0
2022-09-01 19:00:00	AAPL	Stock	158.27	158.65	158.24	158.62	38098.0
2022-09-01 04:00:00	MSFT	Stock	258.89	259.67	258.56	259.15	3055.0
2022-09-01 05:00:00	MSFT	Stock	259.14	259.25	258.11	259.05	2776.0
2022-09-01 06:00:00	MSFT	Stock	259.29	259.79	259.21	259.79	2298.0
2022-09-01 07:00:00	MSFT	Stock	259.55	260.2	259.49	259.57	52526.0
2022-09-01 08:00:00	MSFT	Stock	259.5239	260.817	258.4	258.5	42326.0
2022-09-01 09:00:00	MSFT	Stock	258.51	259.63	257.89	259.46	2060243.0
2022-09-01 10:00:00	MSFT	Stock	259.45	259.8295	255.68	255.7	2474925.0
2022-09-01 11:00:00	MSFT	Stock	255.7	256.96	255.41	255.8	2019289.0
2022-09-01 12:00:00	MSFT	Stock	255.79	256.94	255.52	255.84	1098869.0
2022-09-01 13:00:00	MSFT	Stock	255.835	257.51	255.7072	256.485	1197314.0
2022-09-01 14:00:00	MSFT	Stock	256.48	258.5801	256.05	258.11	1628905.0
2022-09-01 15:00:00	MSFT	Stock	258.1	260.89	258.0	260.38	3268565.0
2022-09-01 16:00:00	MSFT	Stock	260.38	260.78	256.33	259.76	3120137.0
2022-09-01 17:00:00	MSFT	Stock	259.99	260.0	259.25	260.0	25157.0
2022-09-01 18:00:00	MSFT	Stock	260.1	260.41	259.24	259.94	22588.0
2022-09-01 19:00:00	MSFT	Stock	259.76	259.89	259.32	259.78	8086.0
2022-09-01 04:00:00	NVDA	Stock	14.169	14.338	14.069	14.318	1434810.0
2022-09-01 05:00:00	NVDA	Stock	14.328	14.371	14.247	14.284	354420.0
2022-09-01 06:00:00	NVDA	Stock	14.291	14.291	14.234	14.275	339950.0
2022-09-01 07:00:00	NVDA	Stock	14.271	14.56	14.205	14.403	5918610.0
2022-09-01 08:00:00	NVDA	Stock	14.2247	15.094	14.119	14.438	8009150.0
2022-09-01 09:00:00	NVDA	Stock	14.435	14.448	13.859	13.914	157676710.0
2022-09-01 10:00:00	NVDA	Stock	13.909	13.977	13.503	13.5145	178001730.0
2022-09-01 11:00:00	NVDA	Stock	13.514	13.533	13.276	13.3785	169067400.0
2022-09-01 12:00:00	NVDA	Stock	13.3795	13.444	13.2702	13.384	86720030.0
2022-09-01 13:00:00	NVDA	Stock	13.384	13.554	13.368	13.4351	78475060.0
2022-09-01 14:00:00	NVDA	Stock	13.437	13.827	13.431	13.7855	115881560.0
2022-09-01 15:00:00	NVDA	Stock	13.786	13.98	13.73	13.936	114735240.0
2022-09-01 16:00:00	NVDA	Stock	13.937	13.994	13.925	13.972	22472190.0
2022-09-01 17:00:00	NVDA	Stock	13.977	14.019	13.937	14.007	786290.0
2022-09-01 18:00:00	NVDA	Stock	14.007	14.015	13.938	13.945	834330.0
2022-09-01 19:00:00	NVDA	Stock	13.942	13.959	13.85	13.87	971280.0
2022-09-01 04:00:00	AMZN	Stock	125.2	125.76	125.2	125.5	25670.0
2022-09-01 05:00:00	AMZN	Stock	125.6	125.77	125.37	125.72	6736.0

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

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