PREVIEW / stock_1hour / 2021-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-02.parquet
  size:    1.5 MB
  rows:    66,866
  symbols: 2,681

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
2021-11-02 04:00:00	AAPL	Stock	148.67	148.95	148.55	148.71	20396.0
2021-11-02 05:00:00	AAPL	Stock	148.68	148.92	148.68	148.78	18463.0
2021-11-02 06:00:00	AAPL	Stock	148.79	148.8	148.67	148.7	8181.0
2021-11-02 07:00:00	AAPL	Stock	148.7	148.79	148.59	148.59	75342.0
2021-11-02 08:00:00	AAPL	Stock	148.77	148.79	148.59	148.59	173745.0
2021-11-02 09:00:00	AAPL	Stock	148.59	150.4894	148.46	149.93	9725575.0
2021-11-02 10:00:00	AAPL	Stock	149.94	150.915	149.3335	150.8601	9780453.0
2021-11-02 11:00:00	AAPL	Stock	150.87	151.57	150.62	150.9401	8207491.0
2021-11-02 12:00:00	AAPL	Stock	150.94	151.48	150.585	151.4	5689501.0
2021-11-02 13:00:00	AAPL	Stock	151.41	151.47	150.86	150.9576	4430324.0
2021-11-02 14:00:00	AAPL	Stock	150.955	150.99	150.07	150.365	5367718.0
2021-11-02 15:00:00	AAPL	Stock	150.3684	150.435	149.82	150.0	7520720.0
2021-11-02 16:00:00	AAPL	Stock	150.02	150.04	149.82	149.95	5493304.0
2021-11-02 17:00:00	AAPL	Stock	149.93	149.9899	149.81	149.83	25581.0
2021-11-02 18:00:00	AAPL	Stock	149.83	149.86	149.8	149.84	16446.0
2021-11-02 19:00:00	AAPL	Stock	149.83	149.94	149.82	149.85	36375.0
2021-11-02 04:00:00	MSFT	Stock	329.9	330.19	329.37	329.97	5194.0
2021-11-02 05:00:00	MSFT	Stock	329.79	331.45	329.79	330.54	8130.0
2021-11-02 06:00:00	MSFT	Stock	330.39	330.8	329.84	330.73	2668.0
2021-11-02 07:00:00	MSFT	Stock	330.5	330.93	330.28	330.28	10759.0
2021-11-02 08:00:00	MSFT	Stock	330.8	330.95	330.0	330.36	44977.0
2021-11-02 09:00:00	MSFT	Stock	330.38	333.0	329.85	332.1099	2536464.0
2021-11-02 10:00:00	MSFT	Stock	332.11	332.48	331.0196	332.185	2262083.0
2021-11-02 11:00:00	MSFT	Stock	332.23	333.28	331.77	332.83	2572062.0
2021-11-02 12:00:00	MSFT	Stock	332.842	333.0	332.06	332.565	1554123.0
2021-11-02 13:00:00	MSFT	Stock	332.58	333.095	332.17	332.66	1236540.0
2021-11-02 14:00:00	MSFT	Stock	332.67	333.11	332.0541	333.1	2385969.0
2021-11-02 15:00:00	MSFT	Stock	333.085	333.45	332.8	333.26	3139888.0
2021-11-02 16:00:00	MSFT	Stock	333.13	333.45	332.64	333.0999	3277488.0
2021-11-02 17:00:00	MSFT	Stock	333.1	333.1	332.71	332.88	5675.0
2021-11-02 18:00:00	MSFT	Stock	332.72	332.99	332.64	332.99	4326.0
2021-11-02 19:00:00	MSFT	Stock	332.96	333.13	332.88	333.13	10609.0
2021-11-02 04:00:00	NVDA	Stock	25.9	25.9	25.798	25.8	62680.0
2021-11-02 05:00:00	NVDA	Stock	25.803	25.853	25.79	25.79	37230.0
2021-11-02 06:00:00	NVDA	Stock	25.797	25.855	25.797	25.855	15680.0
2021-11-02 07:00:00	NVDA	Stock	25.854	25.878	25.7	25.762	103920.0
2021-11-02 08:00:00	NVDA	Stock	25.8	25.8915	25.7	25.791	290220.0
2021-11-02 09:00:00	NVDA	Stock	25.78	26.236	25.765	26.198	34895710.0
2021-11-02 10:00:00	NVDA	Stock	26.198	26.27	25.898	26.215	35425250.0
2021-11-02 11:00:00	NVDA	Stock	26.218	26.678	26.214	26.469	40091340.0
2021-11-02 12:00:00	NVDA	Stock	26.468	26.6	26.3867	26.561	21918330.0
2021-11-02 13:00:00	NVDA	Stock	26.564	26.576	26.378	26.413	15790320.0
2021-11-02 14:00:00	NVDA	Stock	26.411	26.45	26.1831	26.3878	25992190.0
2021-11-02 15:00:00	NVDA	Stock	26.3874	26.52	26.344	26.404	22167040.0
2021-11-02 16:00:00	NVDA	Stock	26.401	26.5	26.375	26.462	13516550.0
2021-11-02 17:00:00	NVDA	Stock	26.461	26.461	26.403	26.45	40770.0
2021-11-02 18:00:00	NVDA	Stock	26.449	26.49	26.431	26.475	168450.0
2021-11-02 19:00:00	NVDA	Stock	26.497	26.5	26.45	26.471	201510.0
2021-11-02 04:00:00	AMZN	Stock	165.95	165.95	165.95	165.95	2000.0
2021-11-02 05:00:00	AMZN	Stock	165.9	165.9	165.9	165.9	2000.0

> showing 50 of 66,866 rows — these rows as CSV

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