PREVIEW / stock_1hour / 2021-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-13.parquet
  size:    1.4 MB
  rows:    64,033
  symbols: 2,693

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-10-13 04:00:00	AAPL	Stock	140.2	140.72	139.93	140.5	57898.0
2021-10-13 05:00:00	AAPL	Stock	140.45	140.75	140.26	140.59	23728.0
2021-10-13 06:00:00	AAPL	Stock	140.56	141.1	140.26	140.26	29883.0
2021-10-13 07:00:00	AAPL	Stock	140.4	140.89	140.05	140.61	304572.0
2021-10-13 08:00:00	AAPL	Stock	140.4701	141.157	140.03	140.51	806731.0
2021-10-13 09:00:00	AAPL	Stock	140.49	141.5512	139.56	139.73	12184971.0
2021-10-13 10:00:00	AAPL	Stock	139.73	140.1832	139.5	139.805	10236515.0
2021-10-13 11:00:00	AAPL	Stock	139.8	140.1354	139.2	140.125	9248710.0
2021-10-13 12:00:00	AAPL	Stock	140.12	140.148	139.8	140.02	5049732.0
2021-10-13 13:00:00	AAPL	Stock	140.02	140.677	140.0	140.435	5734878.0
2021-10-13 14:00:00	AAPL	Stock	140.45	140.99	140.19	140.375	7093289.0
2021-10-13 15:00:00	AAPL	Stock	140.37	141.03	140.271	140.96	9464466.0
2021-10-13 16:00:00	AAPL	Stock	140.91	140.98	140.83	140.9	9003931.0
2021-10-13 17:00:00	AAPL	Stock	140.88	140.94	140.82	140.91	16271.0
2021-10-13 18:00:00	AAPL	Stock	140.96	141.12	140.84	141.01	39076.0
2021-10-13 19:00:00	AAPL	Stock	141.05	141.255	141.03	141.24	33773.0
2021-10-13 04:00:00	MSFT	Stock	293.34	294.99	293.0	294.58	6851.0
2021-10-13 05:00:00	MSFT	Stock	294.78	295.0	294.72	294.8	3710.0
2021-10-13 06:00:00	MSFT	Stock	294.72	295.37	294.7	294.7	7422.0
2021-10-13 07:00:00	MSFT	Stock	294.89	295.0	294.15	294.8	38829.0
2021-10-13 08:00:00	MSFT	Stock	294.25	295.48	292.97	293.65	74302.0
2021-10-13 09:00:00	MSFT	Stock	293.7	297.28	293.62	295.52	2028880.0
2021-10-13 10:00:00	MSFT	Stock	295.53	296.0899	293.8204	294.16	2016467.0
2021-10-13 11:00:00	MSFT	Stock	294.14	294.96	293.49	294.49	1434385.0
2021-10-13 12:00:00	MSFT	Stock	294.51	294.57	293.7	294.045	886277.0
2021-10-13 13:00:00	MSFT	Stock	294.04	295.35	294.02	294.835	1148625.0
2021-10-13 14:00:00	MSFT	Stock	294.85	296.65	294.22	295.74	1679888.0
2021-10-13 15:00:00	MSFT	Stock	295.74	296.87	295.32	296.37	3113692.0
2021-10-13 16:00:00	MSFT	Stock	296.33	296.4	295.92	296.2	4210771.0
2021-10-13 17:00:00	MSFT	Stock	296.23	296.4	296.17	296.35	1869.0
2021-10-13 18:00:00	MSFT	Stock	296.35	296.73	296.31	296.69	2300.0
2021-10-13 19:00:00	MSFT	Stock	296.76	296.88	296.58	296.88	2689.0
2021-10-13 04:00:00	NVDA	Stock	20.668	20.878	20.668	20.844	62560.0
2021-10-13 05:00:00	NVDA	Stock	20.84	20.865	20.84	20.845	10940.0
2021-10-13 06:00:00	NVDA	Stock	20.849	20.87	20.83	20.83	15610.0
2021-10-13 07:00:00	NVDA	Stock	20.822	20.83	20.711	20.8	318930.0
2021-10-13 08:00:00	NVDA	Stock	20.8	20.828	20.675	20.736	826710.0
2021-10-13 09:00:00	NVDA	Stock	20.75	20.99	20.725	20.855	25186870.0
2021-10-13 10:00:00	NVDA	Stock	20.86	20.939	20.7354	20.8174	19875780.0
2021-10-13 11:00:00	NVDA	Stock	20.823	20.872	20.713	20.856	12949890.0
2021-10-13 12:00:00	NVDA	Stock	20.856	20.8646	20.785	20.804	9272470.0
2021-10-13 13:00:00	NVDA	Stock	20.804	20.915	20.7925	20.866	10946280.0
2021-10-13 14:00:00	NVDA	Stock	20.864	20.943	20.808	20.892	12448080.0
2021-10-13 15:00:00	NVDA	Stock	20.894	20.947	20.852	20.947	16919290.0
2021-10-13 16:00:00	NVDA	Stock	20.939	20.98	20.909	20.97	18471420.0
2021-10-13 17:00:00	NVDA	Stock	20.971	20.986	20.955	20.965	145650.0
2021-10-13 18:00:00	NVDA	Stock	20.98	20.999	20.966	20.998	112120.0
2021-10-13 19:00:00	NVDA	Stock	20.991	21.021	20.991	21.001	230460.0
2021-10-13 05:00:00	AMZN	Stock	163.326	163.326	163.326	163.326	2000.0
2021-10-13 06:00:00	AMZN	Stock	163.5	163.5	163.425	163.425	10000.0

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

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