PREVIEW / stock_1hour / 2022-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-01.parquet
  size:    1.4 MB
  rows:    64,360
  symbols: 2,550

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-03-01 04:00:00	AAPL	Stock	164.74	165.01	163.76	163.76	14707.0
2022-03-01 05:00:00	AAPL	Stock	163.78	164.1	163.28	164.1	13255.0
2022-03-01 06:00:00	AAPL	Stock	163.85	164.05	163.2	163.52	7028.0
2022-03-01 07:00:00	AAPL	Stock	163.58	164.32	163.57	163.95	100853.0
2022-03-01 08:00:00	AAPL	Stock	163.95	165.532	163.58	164.7	550898.0
2022-03-01 09:00:00	AAPL	Stock	164.7	166.51	164.36	165.73	10616998.0
2022-03-01 10:00:00	AAPL	Stock	165.75	166.6	164.945	165.16	12103244.0
2022-03-01 11:00:00	AAPL	Stock	165.17	165.75	163.31	163.58	9047564.0
2022-03-01 12:00:00	AAPL	Stock	163.585	164.4	163.0213	164.11	6750655.0
2022-03-01 13:00:00	AAPL	Stock	164.1	164.4	162.51	162.9925	6772341.0
2022-03-01 14:00:00	AAPL	Stock	162.9981	163.51	162.57	162.72	5942291.0
2022-03-01 15:00:00	AAPL	Stock	162.725	163.89	161.97	163.18	12845837.0
2022-03-01 16:00:00	AAPL	Stock	163.2	163.97	163.2	163.424	7444491.0
2022-03-01 17:00:00	AAPL	Stock	163.4	163.45	163.21	163.31	18781.0
2022-03-01 18:00:00	AAPL	Stock	163.33	163.73	163.21	163.72	54895.0
2022-03-01 19:00:00	AAPL	Stock	163.72	163.8	163.4	163.74	42990.0
2022-03-01 04:00:00	MSFT	Stock	297.54	297.55	296.67	296.68	1719.0
2022-03-01 05:00:00	MSFT	Stock	296.8	297.2	296.62	297.2	1807.0
2022-03-01 06:00:00	MSFT	Stock	297.2	297.2	296.74	296.74	1875.0
2022-03-01 07:00:00	MSFT	Stock	296.58	297.05	290.43	296.12	33276.0
2022-03-01 08:00:00	MSFT	Stock	296.199	298.48	295.5	298.21	27748.0
2022-03-01 09:00:00	MSFT	Stock	297.76	298.8817	295.51	298.41	2387248.0
2022-03-01 10:00:00	MSFT	Stock	298.57	299.97	297.25	297.51	2836549.0
2022-03-01 11:00:00	MSFT	Stock	297.51	299.36	294.72	295.21	2253680.0
2022-03-01 12:00:00	MSFT	Stock	295.15	297.21	294.58	296.559	1724453.0
2022-03-01 13:00:00	MSFT	Stock	296.51	297.18	294.25	294.8	1802831.0
2022-03-01 14:00:00	MSFT	Stock	294.82	295.9399	294.13	294.225	2322817.0
2022-03-01 15:00:00	MSFT	Stock	294.24	296.37	292.15	294.95	4490192.0
2022-03-01 16:00:00	MSFT	Stock	294.95	295.85	294.83	295.68	3749420.0
2022-03-01 17:00:00	MSFT	Stock	295.63	295.78	295.31	295.42	13106.0
2022-03-01 18:00:00	MSFT	Stock	295.43	295.97	295.2	295.97	12002.0
2022-03-01 19:00:00	MSFT	Stock	296.15	296.8	295.75	296.0	10915.0
2022-03-01 04:00:00	NVDA	Stock	24.4	24.4	24.05	24.072	49320.0
2022-03-01 05:00:00	NVDA	Stock	24.05	24.169	24.0	24.169	53670.0
2022-03-01 06:00:00	NVDA	Stock	24.167	24.18	24.029	24.05	24310.0
2022-03-01 07:00:00	NVDA	Stock	24.069	24.22	24.031	24.15	247970.0
2022-03-01 08:00:00	NVDA	Stock	24.0506	24.35	24.035	24.26	760700.0
2022-03-01 09:00:00	NVDA	Stock	24.261	24.377	24.013	24.192	32739980.0
2022-03-01 10:00:00	NVDA	Stock	24.211	24.37	23.808	23.8385	51735980.0
2022-03-01 11:00:00	NVDA	Stock	23.841	24.025	23.467	23.499	39788140.0
2022-03-01 12:00:00	NVDA	Stock	23.4902	23.597	23.36	23.472	35638550.0
2022-03-01 13:00:00	NVDA	Stock	23.46	23.542	23.132	23.2501	32963810.0
2022-03-01 14:00:00	NVDA	Stock	23.262	23.474	23.158	23.335	35771140.0
2022-03-01 15:00:00	NVDA	Stock	23.334	23.67	23.149	23.482	55025160.0
2022-03-01 16:00:00	NVDA	Stock	23.4821	23.565	23.42	23.5	23005290.0
2022-03-01 17:00:00	NVDA	Stock	23.51	23.513	23.451	23.474	132950.0
2022-03-01 18:00:00	NVDA	Stock	23.478	23.504	23.456	23.499	132110.0
2022-03-01 19:00:00	NVDA	Stock	23.52	23.552	23.499	23.552	241900.0
2022-03-01 05:00:00	AMZN	Stock	152.2485	152.25	152.225	152.25	8760.0
2022-03-01 07:00:00	AMZN	Stock	152.4375	152.5105	152.35	152.4	26640.0

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

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