PREVIEW / stock_1hour / 2022-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-04.parquet
  size:    1.4 MB
  rows:    63,347
  symbols: 2,523

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-04 04:00:00	AAPL	Stock	174.38	174.38	173.55	173.55	27221.0
2022-02-04 05:00:00	AAPL	Stock	173.51	173.51	172.48	172.51	47703.0
2022-02-04 06:00:00	AAPL	Stock	172.85	172.87	171.49	171.65	35960.0
2022-02-04 07:00:00	AAPL	Stock	171.86	173.18	171.72	173.11	221209.0
2022-02-04 08:00:00	AAPL	Stock	172.8601	173.18	170.29	170.32	877733.0
2022-02-04 09:00:00	AAPL	Stock	170.45	172.3795	170.02	172.19	9317473.0
2022-02-04 10:00:00	AAPL	Stock	172.18	172.92	171.02	171.23	10393353.0
2022-02-04 11:00:00	AAPL	Stock	171.23	172.62	170.81	172.053	7590325.0
2022-02-04 12:00:00	AAPL	Stock	172.0618	172.61	171.675	172.47	5376042.0
2022-02-04 13:00:00	AAPL	Stock	172.47	173.73	172.46	173.33	6844919.0
2022-02-04 14:00:00	AAPL	Stock	173.34	173.5	172.52	173.225	6156396.0
2022-02-04 15:00:00	AAPL	Stock	173.23	174.1	172.22	172.32	10111506.0
2022-02-04 16:00:00	AAPL	Stock	172.34	172.55	172.02	172.51	7983973.0
2022-02-04 17:00:00	AAPL	Stock	172.49	172.66	172.39	172.6	57693.0
2022-02-04 18:00:00	AAPL	Stock	172.6	172.6	172.51	172.55	22286.0
2022-02-04 19:00:00	AAPL	Stock	172.52	172.55	172.4	172.5	17045.0
2022-02-04 04:00:00	MSFT	Stock	304.9	304.9	303.61	303.61	12640.0
2022-02-04 05:00:00	MSFT	Stock	303.6	303.61	301.7	301.74	9412.0
2022-02-04 06:00:00	MSFT	Stock	302.1	302.1	300.02	300.4	16013.0
2022-02-04 07:00:00	MSFT	Stock	300.46	302.49	300.16	302.48	70800.0
2022-02-04 08:00:00	MSFT	Stock	301.2522	303.37	298.99	299.0	196686.0
2022-02-04 09:00:00	MSFT	Stock	298.91	304.625	297.28	304.295	3378300.0
2022-02-04 10:00:00	MSFT	Stock	304.29	306.43	302.54	303.43	3695936.0
2022-02-04 11:00:00	MSFT	Stock	303.4	306.06	302.82	305.15	2408586.0
2022-02-04 12:00:00	MSFT	Stock	305.22	307.0	304.61	306.41	1922307.0
2022-02-04 13:00:00	MSFT	Stock	306.415	308.125	306.415	307.57	1957044.0
2022-02-04 14:00:00	MSFT	Stock	307.61	307.9	306.18	307.4801	1899521.0
2022-02-04 15:00:00	MSFT	Stock	307.52	308.8	305.78	305.8	3773883.0
2022-02-04 16:00:00	MSFT	Stock	305.94	306.3	303.64	304.97	4121613.0
2022-02-04 17:00:00	MSFT	Stock	304.95	305.18	304.77	305.12	11079.0
2022-02-04 18:00:00	MSFT	Stock	305.12	305.44	305.11	305.32	7301.0
2022-02-04 19:00:00	MSFT	Stock	305.23	305.37	305.2	305.3	4075.0
2022-02-04 04:00:00	NVDA	Stock	24.675	24.675	24.452	24.569	25030.0
2022-02-04 05:00:00	NVDA	Stock	24.46	24.471	24.246	24.35	169460.0
2022-02-04 06:00:00	NVDA	Stock	24.35	24.35	24.0	24.081	197840.0
2022-02-04 07:00:00	NVDA	Stock	24.096	24.3	24.05	24.263	350450.0
2022-02-04 08:00:00	NVDA	Stock	24.06	24.299	23.777	23.79	2057060.0
2022-02-04 09:00:00	NVDA	Stock	23.777	24.251	23.6	24.169	35488630.0
2022-02-04 10:00:00	NVDA	Stock	24.178	24.497	23.982	24.0079	50127500.0
2022-02-04 11:00:00	NVDA	Stock	24.0	24.249	23.68	24.1254	35648680.0
2022-02-04 12:00:00	NVDA	Stock	24.136	24.163	23.957	24.134	23172520.0
2022-02-04 13:00:00	NVDA	Stock	24.139	24.454	24.139	24.414	20787200.0
2022-02-04 14:00:00	NVDA	Stock	24.422	24.553	24.205	24.5015	22782550.0
2022-02-04 15:00:00	NVDA	Stock	24.501	24.635	24.303	24.313	39415910.0
2022-02-04 16:00:00	NVDA	Stock	24.319	24.355	24.188	24.217	26024280.0
2022-02-04 17:00:00	NVDA	Stock	24.238	24.252	24.21	24.24	302700.0
2022-02-04 18:00:00	NVDA	Stock	24.251	24.295	24.225	24.25	208800.0
2022-02-04 19:00:00	NVDA	Stock	24.292	24.3	24.265	24.3	146750.0
2022-02-04 04:00:00	AMZN	Stock	157.159	157.159	155.75	156.65	120640.0
2022-02-04 05:00:00	AMZN	Stock	156.65	156.65	155.6	155.6	148240.0

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

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