PREVIEW / stock_1hour / 2022-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-31.parquet
  size:    1.4 MB
  rows:    65,135
  symbols: 2,610

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-31 04:00:00	AAPL	Stock	170.7	172.01	170.7	171.55	62951.0
2022-01-31 05:00:00	AAPL	Stock	171.5	171.57	170.08	170.33	172449.0
2022-01-31 06:00:00	AAPL	Stock	170.49	170.82	170.21	170.61	63129.0
2022-01-31 07:00:00	AAPL	Stock	170.69	170.85	169.63	170.3	298906.0
2022-01-31 08:00:00	AAPL	Stock	170.55	170.86	169.63	170.57	789686.0
2022-01-31 09:00:00	AAPL	Stock	170.57	172.9	169.51	172.52	15310505.0
2022-01-31 10:00:00	AAPL	Stock	172.53	173.62	172.27	173.08	15877023.0
2022-01-31 11:00:00	AAPL	Stock	173.07	173.58	172.38	173.295	9489793.0
2022-01-31 12:00:00	AAPL	Stock	173.3	173.335	172.35	172.9708	7357517.0
2022-01-31 13:00:00	AAPL	Stock	172.98	173.545	172.7	173.28	6685887.0
2022-01-31 14:00:00	AAPL	Stock	173.28	173.74	173.155	173.4801	7092815.0
2022-01-31 15:00:00	AAPL	Stock	173.49	175.0	172.77	174.8	19567836.0
2022-01-31 16:00:00	AAPL	Stock	174.66	174.96	174.2	174.35	15235697.0
2022-01-31 17:00:00	AAPL	Stock	174.35	174.4	174.05	174.17	94772.0
2022-01-31 18:00:00	AAPL	Stock	174.19	174.49	174.19	174.48	58382.0
2022-01-31 19:00:00	AAPL	Stock	174.48	174.5	174.2	174.4	63338.0
2022-01-31 04:00:00	MSFT	Stock	310.0	310.58	309.5	309.8	6705.0
2022-01-31 05:00:00	MSFT	Stock	309.53	309.53	308.8	309.53	3883.0
2022-01-31 06:00:00	MSFT	Stock	309.49	309.9	308.59	309.2	6055.0
2022-01-31 07:00:00	MSFT	Stock	309.44	309.44	307.0	308.1	50787.0
2022-01-31 08:00:00	MSFT	Stock	309.5	309.5	307.05	308.48	48208.0
2022-01-31 09:00:00	MSFT	Stock	308.65	310.84	306.37	310.8	4534847.0
2022-01-31 10:00:00	MSFT	Stock	310.8	312.38	308.09	308.725	4619792.0
2022-01-31 11:00:00	MSFT	Stock	308.69	310.4	307.08	309.74	3398872.0
2022-01-31 12:00:00	MSFT	Stock	309.76	309.86	307.59	308.27	2723368.0
2022-01-31 13:00:00	MSFT	Stock	308.25	308.6188	307.33	307.8	2319068.0
2022-01-31 14:00:00	MSFT	Stock	307.83	309.14	307.61	308.9	2415641.0
2022-01-31 15:00:00	MSFT	Stock	308.91	311.52	307.0	310.93	5856048.0
2022-01-31 16:00:00	MSFT	Stock	310.98	311.68	309.62	309.99	7423414.0
2022-01-31 17:00:00	MSFT	Stock	309.76	310.4899	309.7	310.19	16610.0
2022-01-31 18:00:00	MSFT	Stock	310.2	310.33	309.71	309.95	28448.0
2022-01-31 19:00:00	MSFT	Stock	309.91	310.3	309.7	310.06	18071.0
2022-01-31 04:00:00	NVDA	Stock	23.246	23.445	23.199	23.3	126760.0
2022-01-31 05:00:00	NVDA	Stock	23.366	23.385	23.145	23.23	87440.0
2022-01-31 06:00:00	NVDA	Stock	23.235	23.24	23.1	23.16	132600.0
2022-01-31 07:00:00	NVDA	Stock	23.151	23.2	22.84	23.01	667820.0
2022-01-31 08:00:00	NVDA	Stock	23.1795	23.278	22.851	23.2	1723840.0
2022-01-31 09:00:00	NVDA	Stock	23.19	23.686	23.052	23.633	57203560.0
2022-01-31 10:00:00	NVDA	Stock	23.634	23.901	23.606	23.828	76192930.0
2022-01-31 11:00:00	NVDA	Stock	23.822	24.015	23.662	23.9734	59340520.0
2022-01-31 12:00:00	NVDA	Stock	23.971	24.055	23.789	24.001	43239670.0
2022-01-31 13:00:00	NVDA	Stock	24.0053	24.074	23.823	23.968	35685780.0
2022-01-31 14:00:00	NVDA	Stock	23.973	24.249	23.922	24.182	41730440.0
2022-01-31 15:00:00	NVDA	Stock	24.1808	24.509	23.867	24.505	77653110.0
2022-01-31 16:00:00	NVDA	Stock	24.486	24.575	24.405	24.56	35244440.0
2022-01-31 17:00:00	NVDA	Stock	24.564	24.698	24.53	24.65	676870.0
2022-01-31 18:00:00	NVDA	Stock	24.65	24.668	24.585	24.653	328190.0
2022-01-31 19:00:00	NVDA	Stock	24.647	24.789	24.621	24.77	555450.0
2022-01-31 04:00:00	AMZN	Stock	145.454	145.5	145.454	145.5	4000.0
2022-01-31 05:00:00	AMZN	Stock	145.0	145.125	145.0	145.0	6800.0

> showing 50 of 65,135 rows — these rows as CSV

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