PREVIEW / stock_1hour / 2021-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-09.parquet
  size:    1.5 MB
  rows:    67,364
  symbols: 2,682

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-09 04:00:00	AAPL	Stock	150.03	150.33	150.01	150.12	14227.0
2021-11-09 05:00:00	AAPL	Stock	150.13	150.28	150.1	150.15	8026.0
2021-11-09 06:00:00	AAPL	Stock	150.12	150.16	150.0	150.03	12237.0
2021-11-09 07:00:00	AAPL	Stock	150.03	150.24	149.84	149.95	86529.0
2021-11-09 08:00:00	AAPL	Stock	150.06	150.44	149.85	150.28	1870546.0
2021-11-09 09:00:00	AAPL	Stock	150.25	151.428	150.06	150.96	8511851.0
2021-11-09 10:00:00	AAPL	Stock	150.95	151.2	150.15	150.865	7318475.0
2021-11-09 11:00:00	AAPL	Stock	150.87	151.17	150.575	150.8784	4170546.0
2021-11-09 12:00:00	AAPL	Stock	150.875	151.24	150.5	151.0101	4458512.0
2021-11-09 13:00:00	AAPL	Stock	151.015	151.22	150.545	150.71	3222240.0
2021-11-09 14:00:00	AAPL	Stock	150.7	150.98	150.615	150.825	3312129.0
2021-11-09 15:00:00	AAPL	Stock	150.82	151.13	150.625	150.83	5849280.0
2021-11-09 16:00:00	AAPL	Stock	150.81	150.9	150.33	150.5	7142359.0
2021-11-09 17:00:00	AAPL	Stock	150.51	150.67	150.5	150.66	26025.0
2021-11-09 18:00:00	AAPL	Stock	150.64	150.64	150.5	150.5	20429.0
2021-11-09 19:00:00	AAPL	Stock	150.49	150.67	150.46	150.65	34681.0
2021-11-09 04:00:00	MSFT	Stock	336.55	336.74	336.23	336.3	4092.0
2021-11-09 05:00:00	MSFT	Stock	336.49	337.3	336.49	337.23	3909.0
2021-11-09 06:00:00	MSFT	Stock	337.38	337.42	337.1	337.11	6546.0
2021-11-09 07:00:00	MSFT	Stock	337.08	337.08	336.1	336.35	19970.0
2021-11-09 08:00:00	MSFT	Stock	336.5305	337.35	336.08	337.06	189267.0
2021-11-09 09:00:00	MSFT	Stock	337.16	338.72	336.5	336.9	2042394.0
2021-11-09 10:00:00	MSFT	Stock	336.89	337.83	336.06	337.03	2074895.0
2021-11-09 11:00:00	MSFT	Stock	337.02	337.25	336.15	336.61	1421962.0
2021-11-09 12:00:00	MSFT	Stock	336.58	336.8	335.79	336.08	1281451.0
2021-11-09 13:00:00	MSFT	Stock	336.08	336.27	334.53	334.72	1336094.0
2021-11-09 14:00:00	MSFT	Stock	334.72	336.029	334.65	335.96	1185154.0
2021-11-09 15:00:00	MSFT	Stock	335.94	336.7	335.47	335.93	2024385.0
2021-11-09 16:00:00	MSFT	Stock	335.95	335.95	335.24	335.4	2348084.0
2021-11-09 17:00:00	MSFT	Stock	335.4	335.5	335.25	335.3	2354.0
2021-11-09 18:00:00	MSFT	Stock	335.34	335.4	335.0	335.26	4538.0
2021-11-09 19:00:00	MSFT	Stock	335.2	335.67	335.2	335.49	12470.0
2021-11-09 04:00:00	NVDA	Stock	31.31	31.892	31.31	31.851	383400.0
2021-11-09 05:00:00	NVDA	Stock	31.867	32.289	31.853	32.076	523040.0
2021-11-09 06:00:00	NVDA	Stock	32.09	32.427	32.0	32.225	441890.0
2021-11-09 07:00:00	NVDA	Stock	32.2	32.735	32.018	32.304	2589780.0
2021-11-09 08:00:00	NVDA	Stock	32.7004	32.746	30.727	32.3061	5589470.0
2021-11-09 09:00:00	NVDA	Stock	32.306	32.598	30.88	30.922	104093500.0
2021-11-09 10:00:00	NVDA	Stock	30.92	31.545	30.9085	31.0721	81008570.0
2021-11-09 11:00:00	NVDA	Stock	31.0755	31.623	31.04	31.1665	55898440.0
2021-11-09 12:00:00	NVDA	Stock	31.167	31.176	30.104	30.39	63190250.0
2021-11-09 13:00:00	NVDA	Stock	30.384	30.55	29.964	30.1827	46840120.0
2021-11-09 14:00:00	NVDA	Stock	30.18	30.66	30.141	30.522	39033320.0
2021-11-09 15:00:00	NVDA	Stock	30.516	30.745	30.3141	30.671	48915350.0
2021-11-09 16:00:00	NVDA	Stock	30.657	30.67	30.399	30.475	12771550.0
2021-11-09 17:00:00	NVDA	Stock	30.48	30.657	30.25	30.275	1778190.0
2021-11-09 18:00:00	NVDA	Stock	30.263	30.275	30.033	30.137	896100.0
2021-11-09 19:00:00	NVDA	Stock	30.17	30.223	30.1	30.11	461570.0
2021-11-09 07:00:00	AMZN	Stock	174.9	175.635	174.9	175.35	39000.0
2021-11-09 08:00:00	AMZN	Stock	175.1104	176.0	174.0129	175.95	177720.0

> showing 50 of 67,364 rows — these rows as CSV

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