PREVIEW / stock_1hour / 2022-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-11.parquet
  size:    1.4 MB
  rows:    63,759
  symbols: 2,547

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-02-11 04:00:00	AAPL	Stock	171.18	171.55	170.76	170.96	20691.0
2022-02-11 05:00:00	AAPL	Stock	170.99	171.4	170.99	171.4	9144.0
2022-02-11 06:00:00	AAPL	Stock	171.31	171.31	170.74	171.06	8510.0
2022-02-11 07:00:00	AAPL	Stock	171.12	172.26	171.12	171.98	112800.0
2022-02-11 08:00:00	AAPL	Stock	171.2801	172.74	171.19	172.5	429667.0
2022-02-11 09:00:00	AAPL	Stock	172.47	173.08	171.62	171.8287	7491179.0
2022-02-11 10:00:00	AAPL	Stock	171.82	172.695	171.03	172.0899	10669382.0
2022-02-11 11:00:00	AAPL	Stock	172.09	172.56	171.3	171.79	6486720.0
2022-02-11 12:00:00	AAPL	Stock	171.78	172.2	171.35	171.515	5266601.0
2022-02-11 13:00:00	AAPL	Stock	171.51	171.85	168.89	169.15	9706316.0
2022-02-11 14:00:00	AAPL	Stock	169.14	170.0	168.29	168.82	11827691.0
2022-02-11 15:00:00	AAPL	Stock	168.84	169.7	168.04	168.43	15849136.0
2022-02-11 16:00:00	AAPL	Stock	168.45	169.3	168.32	168.6	9155950.0
2022-02-11 17:00:00	AAPL	Stock	168.6	168.78	168.58	168.7	30460.0
2022-02-11 18:00:00	AAPL	Stock	168.68	168.74	168.37	168.42	30251.0
2022-02-11 19:00:00	AAPL	Stock	168.36	168.47	168.1	168.2	68534.0
2022-02-11 04:00:00	MSFT	Stock	300.0	300.98	299.74	299.75	5838.0
2022-02-11 05:00:00	MSFT	Stock	299.74	300.35	299.74	300.18	2500.0
2022-02-11 06:00:00	MSFT	Stock	300.01	300.52	299.5	300.5	4610.0
2022-02-11 07:00:00	MSFT	Stock	300.6	302.7	300.58	301.8	60701.0
2022-02-11 08:00:00	MSFT	Stock	300.3839	303.75	298.99	303.28	342205.0
2022-02-11 09:00:00	MSFT	Stock	303.28	304.29	300.98	301.4754	2619434.0
2022-02-11 10:00:00	MSFT	Stock	301.46	302.98	299.02	300.185	3661708.0
2022-02-11 11:00:00	MSFT	Stock	300.17	301.3241	299.21	300.4	2460180.0
2022-02-11 12:00:00	MSFT	Stock	300.39	301.28	299.2548	299.455	1724752.0
2022-02-11 13:00:00	MSFT	Stock	299.46	300.365	295.16	296.0401	3110781.0
2022-02-11 14:00:00	MSFT	Stock	296.02	298.3	295.06	296.18	3478990.0
2022-02-11 15:00:00	MSFT	Stock	296.18	297.62	294.22	294.99	5368399.0
2022-02-11 16:00:00	MSFT	Stock	294.92	295.77	294.53	295.05	4919858.0
2022-02-11 17:00:00	MSFT	Stock	295.05	295.46	294.81	295.0	13936.0
2022-02-11 18:00:00	MSFT	Stock	294.91	295.0	294.5	294.51	9188.0
2022-02-11 19:00:00	MSFT	Stock	294.56	294.65	294.23	294.4	15251.0
2022-02-11 04:00:00	NVDA	Stock	25.532	25.603	25.474	25.474	102310.0
2022-02-11 05:00:00	NVDA	Stock	25.51	25.655	25.482	25.655	47220.0
2022-02-11 06:00:00	NVDA	Stock	25.647	25.647	25.55	25.57	46540.0
2022-02-11 07:00:00	NVDA	Stock	25.565	25.962	25.506	25.94	780430.0
2022-02-11 08:00:00	NVDA	Stock	25.695	26.12	25.15	26.074	1400150.0
2022-02-11 09:00:00	NVDA	Stock	26.097	26.155	25.307	25.341	45850710.0
2022-02-11 10:00:00	NVDA	Stock	25.338	25.633	25.043	25.056	69893920.0
2022-02-11 11:00:00	NVDA	Stock	25.056	25.249	24.747	24.88	53364800.0
2022-02-11 12:00:00	NVDA	Stock	24.873	25.014	24.67	24.7134	33640170.0
2022-02-11 13:00:00	NVDA	Stock	24.71	24.887	24.31	24.331	44213660.0
2022-02-11 14:00:00	NVDA	Stock	24.327	24.459	23.773	23.928	61756470.0
2022-02-11 15:00:00	NVDA	Stock	23.932	24.187	23.785	23.948	86154750.0
2022-02-11 16:00:00	NVDA	Stock	23.949	24.05	23.844	23.99	36855850.0
2022-02-11 17:00:00	NVDA	Stock	23.995	23.997	23.878	23.905	540260.0
2022-02-11 18:00:00	NVDA	Stock	23.914	23.926	23.815	23.84	371670.0
2022-02-11 19:00:00	NVDA	Stock	23.847	23.864	23.8	23.81	568010.0
2022-02-11 04:00:00	AMZN	Stock	157.6	157.6	157.6	157.6	4000.0
2022-02-11 06:00:00	AMZN	Stock	157.7	157.7	157.7	157.7	2000.0

> showing 50 of 63,759 rows — these rows as CSV

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