PREVIEW / stock_1hour / 2022-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-31.parquet
  size:    1.4 MB
  rows:    62,450
  symbols: 2,206

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-08-31 04:00:00	AAPL	Stock	159.91	160.0	159.3	159.72	31288.0
2022-08-31 05:00:00	AAPL	Stock	159.65	159.66	159.3	159.59	38859.0
2022-08-31 06:00:00	AAPL	Stock	159.45	160.35	159.45	160.11	29983.0
2022-08-31 07:00:00	AAPL	Stock	159.99	160.1	159.43	159.72	84218.0
2022-08-31 08:00:00	AAPL	Stock	159.7	160.76	158.513	160.02	335244.0
2022-08-31 09:00:00	AAPL	Stock	160.02	160.58	158.8799	160.13	8628577.0
2022-08-31 10:00:00	AAPL	Stock	160.13	160.22	158.87	159.06	9047226.0
2022-08-31 11:00:00	AAPL	Stock	159.045	159.77	158.405	159.6001	5982649.0
2022-08-31 12:00:00	AAPL	Stock	159.605	159.705	158.72	159.041	4334821.0
2022-08-31 13:00:00	AAPL	Stock	159.045	159.3499	158.25	158.49	4049055.0
2022-08-31 14:00:00	AAPL	Stock	158.4904	158.74	157.6927	157.925	5487287.0
2022-08-31 15:00:00	AAPL	Stock	157.93	159.22	157.14	157.17	14435082.0
2022-08-31 16:00:00	AAPL	Stock	157.17	157.7	157.17	157.7	21894665.0
2022-08-31 17:00:00	AAPL	Stock	157.62	157.69	157.29	157.35	116447.0
2022-08-31 18:00:00	AAPL	Stock	157.35	157.77	156.52	156.61	85473.0
2022-08-31 19:00:00	AAPL	Stock	156.61	156.66	155.77	156.0	135968.0
2022-08-31 04:00:00	MSFT	Stock	264.0	264.3	263.79	263.98	1627.0
2022-08-31 05:00:00	MSFT	Stock	263.4	263.48	263.25	263.25	1427.0
2022-08-31 06:00:00	MSFT	Stock	263.25	265.58	263.25	265.49	6183.0
2022-08-31 07:00:00	MSFT	Stock	264.8	265.0	264.1	264.1	6578.0
2022-08-31 08:00:00	MSFT	Stock	264.75	266.22	262.313	265.66	23070.0
2022-08-31 09:00:00	MSFT	Stock	265.5	267.11	263.92	265.78	2008881.0
2022-08-31 10:00:00	MSFT	Stock	265.81	265.86	263.25	263.88	1678019.0
2022-08-31 11:00:00	MSFT	Stock	263.9	264.9	262.1761	264.59	1430968.0
2022-08-31 12:00:00	MSFT	Stock	264.62	264.91	263.42	263.67	849126.0
2022-08-31 13:00:00	MSFT	Stock	263.65	264.06	262.36	262.87	973401.0
2022-08-31 14:00:00	MSFT	Stock	262.93	263.56	262.0452	262.405	950507.0
2022-08-31 15:00:00	MSFT	Stock	262.39	263.92	261.33	261.45	3199191.0
2022-08-31 16:00:00	MSFT	Stock	261.47	261.93	261.35	261.47	6885933.0
2022-08-31 17:00:00	MSFT	Stock	261.5047	261.7	261.13	261.35	14175.0
2022-08-31 18:00:00	MSFT	Stock	261.4	262.0	260.1	260.35	18430.0
2022-08-31 19:00:00	MSFT	Stock	260.3	260.3	259.01	259.5	18040.0
2022-08-31 04:00:00	NVDA	Stock	15.6	15.611	15.496	15.503	365150.0
2022-08-31 05:00:00	NVDA	Stock	15.5	15.535	15.49	15.535	16040.0
2022-08-31 06:00:00	NVDA	Stock	15.493	15.656	15.493	15.613	64240.0
2022-08-31 07:00:00	NVDA	Stock	15.605	15.618	15.55	15.565	318560.0
2022-08-31 08:00:00	NVDA	Stock	15.5723	15.762	15.222	15.34	5041960.0
2022-08-31 09:00:00	NVDA	Stock	15.33	15.54	15.192	15.3068	63677900.0
2022-08-31 10:00:00	NVDA	Stock	15.311	15.416	15.015	15.031	73009080.0
2022-08-31 11:00:00	NVDA	Stock	15.0305	15.1944	14.9763	15.162	57366150.0
2022-08-31 12:00:00	NVDA	Stock	15.1621	15.22	15.028	15.044	40706650.0
2022-08-31 13:00:00	NVDA	Stock	15.0437	15.092	14.9585	15.0322	41026310.0
2022-08-31 14:00:00	NVDA	Stock	15.033	15.1039	14.987	15.0315	37938840.0
2022-08-31 15:00:00	NVDA	Stock	15.033	15.29	15.008	15.098	76697960.0
2022-08-31 16:00:00	NVDA	Stock	15.094	15.14	15.0717	15.1	38989340.0
2022-08-31 17:00:00	NVDA	Stock	15.098	15.098	14.325	14.47	8822330.0
2022-08-31 18:00:00	NVDA	Stock	14.46	14.499	14.22	14.244	5424300.0
2022-08-31 19:00:00	NVDA	Stock	14.24	14.25	14.075	14.104	4796090.0
2022-08-31 04:00:00	AMZN	Stock	129.5	129.5	128.4	128.85	9750.0
2022-08-31 05:00:00	AMZN	Stock	128.75	128.9	128.52	128.9	6078.0

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

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