PREVIEW / stock_1hour / 2022-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-13.parquet
  size:    1.4 MB
  rows:    63,788
  symbols: 2,593

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-01-13 04:00:00	AAPL	Stock	175.3	175.48	175.12	175.3	16108.0
2022-01-13 05:00:00	AAPL	Stock	175.3	175.62	175.3	175.4	14070.0
2022-01-13 06:00:00	AAPL	Stock	175.41	175.56	175.01	175.3	8025.0
2022-01-13 07:00:00	AAPL	Stock	175.17	175.5	174.42	175.35	46452.0
2022-01-13 08:00:00	AAPL	Stock	175.09	175.75	175.08	175.59	372547.0
2022-01-13 09:00:00	AAPL	Stock	175.62	176.62	175.55	176.02	8221228.0
2022-01-13 10:00:00	AAPL	Stock	176.02	176.18	174.7	175.43	11399969.0
2022-01-13 11:00:00	AAPL	Stock	175.41	175.48	174.53	175.365	7551135.0
2022-01-13 12:00:00	AAPL	Stock	175.36	175.545	172.82	173.2991	9171532.0
2022-01-13 13:00:00	AAPL	Stock	173.29	173.99	172.98	173.8862	6289069.0
2022-01-13 14:00:00	AAPL	Stock	173.885	174.2	173.16	173.37	6243816.0
2022-01-13 15:00:00	AAPL	Stock	173.38	173.53	171.79	172.32	13987878.0
2022-01-13 16:00:00	AAPL	Stock	172.28	172.6	171.95	172.23	9721295.0
2022-01-13 17:00:00	AAPL	Stock	172.25	172.37	172.19	172.25	69268.0
2022-01-13 18:00:00	AAPL	Stock	172.29	172.38	172.2	172.33	25747.0
2022-01-13 19:00:00	AAPL	Stock	172.31	172.46	172.0	172.1	75969.0
2022-01-13 04:00:00	MSFT	Stock	317.73	318.59	317.73	318.45	703.0
2022-01-13 05:00:00	MSFT	Stock	318.58	319.11	318.58	318.8	1781.0
2022-01-13 06:00:00	MSFT	Stock	318.88	319.18	317.71	317.71	4902.0
2022-01-13 07:00:00	MSFT	Stock	318.0	319.05	317.45	319.0	18775.0
2022-01-13 08:00:00	MSFT	Stock	318.6	320.86	317.3201	320.31	86721.0
2022-01-13 09:00:00	MSFT	Stock	320.4	321.48	318.16	318.71	2191217.0
2022-01-13 10:00:00	MSFT	Stock	318.8745	318.97	314.28	314.32	2972040.0
2022-01-13 11:00:00	MSFT	Stock	314.28	314.7735	312.11	313.6243	3156380.0
2022-01-13 12:00:00	MSFT	Stock	313.61	313.61	308.875	309.58	3828347.0
2022-01-13 13:00:00	MSFT	Stock	309.59	310.829	308.6	310.31	2919013.0
2022-01-13 14:00:00	MSFT	Stock	310.34	311.04	307.49	307.87	3409946.0
2022-01-13 15:00:00	MSFT	Stock	307.89	307.91	304.0	304.8	9510974.0
2022-01-13 16:00:00	MSFT	Stock	304.53	305.36	304.33	304.94	5411267.0
2022-01-13 17:00:00	MSFT	Stock	305.04	305.64	305.0	305.5	46789.0
2022-01-13 18:00:00	MSFT	Stock	305.56	305.8	305.15	305.57	33692.0
2022-01-13 19:00:00	MSFT	Stock	305.59	305.84	304.8	305.7	42006.0
2022-01-13 04:00:00	NVDA	Stock	27.951	28.097	27.88	28.04	225400.0
2022-01-13 05:00:00	NVDA	Stock	28.051	28.237	28.051	28.194	168610.0
2022-01-13 06:00:00	NVDA	Stock	28.216	28.217	28.121	28.14	41130.0
2022-01-13 07:00:00	NVDA	Stock	28.13	28.3	28.125	28.27	417110.0
2022-01-13 08:00:00	NVDA	Stock	28.232	28.337	28.123	28.303	1331780.0
2022-01-13 09:00:00	NVDA	Stock	28.315	28.48	27.945	28.006	40059750.0
2022-01-13 10:00:00	NVDA	Stock	28.005	28.05	26.98	27.132	91311500.0
2022-01-13 11:00:00	NVDA	Stock	27.127	27.354	27.015	27.187	55258620.0
2022-01-13 12:00:00	NVDA	Stock	27.186	27.186	26.616	26.836	54032870.0
2022-01-13 13:00:00	NVDA	Stock	26.827	27.007	26.751	26.9505	30168930.0
2022-01-13 14:00:00	NVDA	Stock	26.946	27.071	26.6829	26.908	32432340.0
2022-01-13 15:00:00	NVDA	Stock	26.914	26.914	26.498	26.586	59597400.0
2022-01-13 16:00:00	NVDA	Stock	26.565	26.626	26.507	26.615	21628700.0
2022-01-13 17:00:00	NVDA	Stock	26.607	26.615	26.5	26.595	372340.0
2022-01-13 18:00:00	NVDA	Stock	26.6	26.615	26.58	26.6	251310.0
2022-01-13 19:00:00	NVDA	Stock	26.599	26.6	26.55	26.59	395850.0
2022-01-13 07:00:00	AMZN	Stock	165.1	165.2	165.075	165.2	13140.0
2022-01-13 08:00:00	AMZN	Stock	165.4	165.5	165.4	165.5	8000.0

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

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