PREVIEW / stock_1hour / 2021-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-23.parquet
  size:    1.4 MB
  rows:    64,302
  symbols: 2,814

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-07-23 04:00:00	AAPL	Stock	147.5	147.9	147.5	147.78	11615.0
2021-07-23 05:00:00	AAPL	Stock	147.75	147.85	147.6	147.61	7264.0
2021-07-23 06:00:00	AAPL	Stock	147.54	147.6	147.49	147.52	6750.0
2021-07-23 07:00:00	AAPL	Stock	147.58	147.8	147.32	147.51	110342.0
2021-07-23 08:00:00	AAPL	Stock	147.7	147.75	147.1301	147.21	373300.0
2021-07-23 09:00:00	AAPL	Stock	147.2	148.02	146.92	147.675	10940982.0
2021-07-23 10:00:00	AAPL	Stock	147.675	148.16	147.57	147.865	9258733.0
2021-07-23 11:00:00	AAPL	Stock	147.86	148.27	147.77	148.1	6918780.0
2021-07-23 12:00:00	AAPL	Stock	148.1	148.26	147.85	148.15	4852629.0
2021-07-23 13:00:00	AAPL	Stock	148.145	148.64	148.13	148.43	6198194.0
2021-07-23 14:00:00	AAPL	Stock	148.42	148.7177	148.28	148.445	5318287.0
2021-07-23 15:00:00	AAPL	Stock	148.45	148.63	148.19	148.57	8723669.0
2021-07-23 16:00:00	AAPL	Stock	148.56	148.56	148.16	148.3	4418511.0
2021-07-23 17:00:00	AAPL	Stock	148.3	148.31	148.11	148.18	175805.0
2021-07-23 18:00:00	AAPL	Stock	148.18	148.31	148.16	148.28	36946.0
2021-07-23 19:00:00	AAPL	Stock	148.28	148.31	148.2	148.27	46555.0
2021-07-23 04:00:00	MSFT	Stock	288.27	288.96	287.82	287.82	6608.0
2021-07-23 05:00:00	MSFT	Stock	288.05	288.2	288.05	288.05	4013.0
2021-07-23 06:00:00	MSFT	Stock	288.05	288.49	288.05	288.37	3638.0
2021-07-23 07:00:00	MSFT	Stock	288.35	288.39	287.66	287.94	20940.0
2021-07-23 08:00:00	MSFT	Stock	288.3999	288.4	287.15	287.36	42040.0
2021-07-23 09:00:00	MSFT	Stock	287.21	288.54	286.5	288.0	2883622.0
2021-07-23 10:00:00	MSFT	Stock	287.9968	288.8	287.84	288.44	2731709.0
2021-07-23 11:00:00	MSFT	Stock	288.455	289.68	288.28	289.2619	2331828.0
2021-07-23 12:00:00	MSFT	Stock	289.27	289.67	288.88	288.99	1731496.0
2021-07-23 13:00:00	MSFT	Stock	289.0	289.87	288.992	289.31	1539493.0
2021-07-23 14:00:00	MSFT	Stock	289.32	289.68	289.2	289.315	1272231.0
2021-07-23 15:00:00	MSFT	Stock	289.32	289.99	288.6	289.71	3065484.0
2021-07-23 16:00:00	MSFT	Stock	289.67	290.0	289.3001	289.44	2463683.0
2021-07-23 17:00:00	MSFT	Stock	289.49	289.64	289.44	289.64	8150.0
2021-07-23 18:00:00	MSFT	Stock	289.44	289.64	289.44	289.5	4366.0
2021-07-23 19:00:00	MSFT	Stock	289.44	289.63	289.44	289.52	7429.0
2021-07-23 04:00:00	NVDA	Stock	19.649	19.7	19.595	19.663	118840.0
2021-07-23 05:00:00	NVDA	Stock	19.669	19.749	19.669	19.749	68750.0
2021-07-23 06:00:00	NVDA	Stock	19.749	19.785	19.728	19.728	63480.0
2021-07-23 07:00:00	NVDA	Stock	19.724	19.78	19.632	19.675	269970.0
2021-07-23 08:00:00	NVDA	Stock	19.73	19.765	19.63	19.7	958530.0
2021-07-23 09:00:00	NVDA	Stock	19.7	19.744	19.35	19.437	25632160.0
2021-07-23 10:00:00	NVDA	Stock	19.4335	19.449	19.25	19.303	25072310.0
2021-07-23 11:00:00	NVDA	Stock	19.3055	19.531	19.262	19.488	20834820.0
2021-07-23 12:00:00	NVDA	Stock	19.49	19.525	19.407	19.4406	12251670.0
2021-07-23 13:00:00	NVDA	Stock	19.442	19.494	19.418	19.4625	9470390.0
2021-07-23 14:00:00	NVDA	Stock	19.4638	19.567	19.444	19.488	16969130.0
2021-07-23 15:00:00	NVDA	Stock	19.488	19.568	19.477	19.553	25649810.0
2021-07-23 16:00:00	NVDA	Stock	19.559	19.559	19.52	19.525	10765860.0
2021-07-23 17:00:00	NVDA	Stock	19.504	19.515	19.45	19.475	165650.0
2021-07-23 18:00:00	NVDA	Stock	19.486	19.495	19.46	19.473	98140.0
2021-07-23 19:00:00	NVDA	Stock	19.48	19.495	19.43	19.43	93940.0
2021-07-23 06:00:00	AMZN	Stock	182.65	182.775	182.65	182.65	13760.0
2021-07-23 07:00:00	AMZN	Stock	182.65	182.7055	182.4005	182.5435	51420.0

> showing 50 of 64,302 rows — these rows as CSV

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