PREVIEW / stock_1hour / 2022-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-02.parquet
  size:    1.4 MB
  rows:    60,917
  symbols: 2,066

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-12-02 04:00:00	AAPL	Stock	148.49	148.49	147.95	148.37	13895.0
2022-12-02 05:00:00	AAPL	Stock	148.32	148.37	148.3	148.36	4860.0
2022-12-02 06:00:00	AAPL	Stock	148.28	148.28	148.15	148.25	5540.0
2022-12-02 07:00:00	AAPL	Stock	148.25	148.25	148.03	148.24	27567.0
2022-12-02 08:00:00	AAPL	Stock	148.1691	148.57	145.02	145.8	827126.0
2022-12-02 09:00:00	AAPL	Stock	145.74	146.9	145.52	146.26	7047973.0
2022-12-02 10:00:00	AAPL	Stock	146.255	146.9	145.65	146.21	8352505.0
2022-12-02 11:00:00	AAPL	Stock	146.21	146.98	145.88	146.6371	5823565.0
2022-12-02 12:00:00	AAPL	Stock	146.64	146.95	146.105	146.24	3810878.0
2022-12-02 13:00:00	AAPL	Stock	146.235	146.6	146.05	146.4699	3331347.0
2022-12-02 14:00:00	AAPL	Stock	146.4699	146.96	146.09	146.92	4101346.0
2022-12-02 15:00:00	AAPL	Stock	146.92	148.0	146.84	147.8	12069894.0
2022-12-02 16:00:00	AAPL	Stock	147.8	147.87	147.44	147.4407	11913381.0
2022-12-02 17:00:00	AAPL	Stock	147.5	147.65	147.5	147.57	26098.0
2022-12-02 18:00:00	AAPL	Stock	147.6	147.6	147.5	147.53	5317.0
2022-12-02 19:00:00	AAPL	Stock	147.53	147.53	147.41	147.5	13041.0
2022-12-02 04:00:00	MSFT	Stock	254.24	254.7	254.24	254.7	715.0
2022-12-02 05:00:00	MSFT	Stock	254.55	254.55	254.45	254.45	252.0
2022-12-02 07:00:00	MSFT	Stock	254.19	254.25	253.71	254.05	5130.0
2022-12-02 08:00:00	MSFT	Stock	253.8849	254.337	248.1	249.79	137439.0
2022-12-02 09:00:00	MSFT	Stock	249.71	251.5	248.92	250.74	2154975.0
2022-12-02 10:00:00	MSFT	Stock	250.67	252.8	250.12	251.605	2150823.0
2022-12-02 11:00:00	MSFT	Stock	251.62	253.8	250.87	252.82	1704171.0
2022-12-02 12:00:00	MSFT	Stock	252.81	253.98	252.42	253.02	1462883.0
2022-12-02 13:00:00	MSFT	Stock	253.01	253.8	252.28	253.4518	1102678.0
2022-12-02 14:00:00	MSFT	Stock	253.45	254.5	252.97	254.4001	1346815.0
2022-12-02 15:00:00	MSFT	Stock	254.4	256.06	253.8	255.02	3126732.0
2022-12-02 16:00:00	MSFT	Stock	255.02	255.02	254.21	254.81	3184583.0
2022-12-02 17:00:00	MSFT	Stock	254.85	254.9	254.5	254.86	5571.0
2022-12-02 18:00:00	MSFT	Stock	254.71	254.71	254.61	254.61	2257.0
2022-12-02 19:00:00	MSFT	Stock	254.89	254.89	254.6201	254.66	1043.0
2022-12-02 04:00:00	NVDA	Stock	17.072	17.072	16.962	16.99	6710.0
2022-12-02 05:00:00	NVDA	Stock	16.99	17.033	16.981	17.033	48810.0
2022-12-02 06:00:00	NVDA	Stock	17.05	17.05	17.026	17.026	61940.0
2022-12-02 07:00:00	NVDA	Stock	17.022	17.072	17.016	17.063	100250.0
2022-12-02 08:00:00	NVDA	Stock	17.021	17.15	16.446	16.6	5772990.0
2022-12-02 09:00:00	NVDA	Stock	16.599	16.808	16.445	16.545	58274270.0
2022-12-02 10:00:00	NVDA	Stock	16.544	16.707	16.499	16.5855	55365940.0
2022-12-02 11:00:00	NVDA	Stock	16.585	16.771	16.535	16.679	31783830.0
2022-12-02 12:00:00	NVDA	Stock	16.6835	16.74	16.5915	16.605	22288570.0
2022-12-02 13:00:00	NVDA	Stock	16.608	16.698	16.546	16.682	19451400.0
2022-12-02 14:00:00	NVDA	Stock	16.6831	16.821	16.633	16.816	28217170.0
2022-12-02 15:00:00	NVDA	Stock	16.817	16.9326	16.733	16.883	57346580.0
2022-12-02 16:00:00	NVDA	Stock	16.884	16.884	16.852	16.855	16913750.0
2022-12-02 17:00:00	NVDA	Stock	16.861	16.88	16.855	16.874	76690.0
2022-12-02 18:00:00	NVDA	Stock	16.877	16.89	16.86	16.867	72080.0
2022-12-02 19:00:00	NVDA	Stock	16.865	16.89	16.86	16.89	69760.0
2022-12-02 04:00:00	AMZN	Stock	95.53	95.85	95.15	95.68	14693.0
2022-12-02 05:00:00	AMZN	Stock	95.67	95.79	95.6	95.77	6363.0
2022-12-02 06:00:00	AMZN	Stock	95.8	95.85	95.59	95.7	3648.0

> showing 50 of 60,917 rows — these rows as CSV

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