PREVIEW / stock_1hour / 2022-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-28.parquet
  size:    1.4 MB
  rows:    65,362
  symbols: 2,646

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-28 04:00:00	AAPL	Stock	167.8	167.8	165.75	165.91	135182.0
2022-01-28 05:00:00	AAPL	Stock	165.99	166.0	165.02	165.67	132956.0
2022-01-28 06:00:00	AAPL	Stock	165.68	165.76	164.29	165.4	170927.0
2022-01-28 07:00:00	AAPL	Stock	165.5	165.94	162.8	163.39	895033.0
2022-01-28 08:00:00	AAPL	Stock	165.4501	165.79	161.86	164.0	2824797.0
2022-01-28 09:00:00	AAPL	Stock	163.99	166.865	162.8	164.4501	22754332.0
2022-01-28 10:00:00	AAPL	Stock	164.48	166.85	164.01	166.84	22932408.0
2022-01-28 11:00:00	AAPL	Stock	166.84	168.77	166.62	168.77	20320165.0
2022-01-28 12:00:00	AAPL	Stock	168.77	169.14	167.71	168.12	14057921.0
2022-01-28 13:00:00	AAPL	Stock	168.11	168.86	167.73	168.45	10287696.0
2022-01-28 14:00:00	AAPL	Stock	168.44	168.76	166.52	167.835	13065770.0
2022-01-28 15:00:00	AAPL	Stock	167.83	170.35	167.73	170.3499	27775169.0
2022-01-28 16:00:00	AAPL	Stock	170.12	170.33	169.95	170.02	10673570.0
2022-01-28 17:00:00	AAPL	Stock	170.03	170.55	169.99	170.35	242494.0
2022-01-28 18:00:00	AAPL	Stock	170.35	170.53	170.34	170.48	80421.0
2022-01-28 19:00:00	AAPL	Stock	170.47	170.82	170.33	170.7	139270.0
2022-01-28 04:00:00	MSFT	Stock	301.19	302.5	300.1	301.6	11643.0
2022-01-28 05:00:00	MSFT	Stock	301.2	301.4	299.6	299.76	18317.0
2022-01-28 06:00:00	MSFT	Stock	300.17	300.5	298.99	299.58	9129.0
2022-01-28 07:00:00	MSFT	Stock	299.83	300.38	295.61	296.84	83861.0
2022-01-28 08:00:00	MSFT	Stock	299.59	301.34	295.55	300.98	163559.0
2022-01-28 09:00:00	MSFT	Stock	300.67	301.05	294.53	295.19	3808670.0
2022-01-28 10:00:00	MSFT	Stock	295.19	302.23	294.45	302.16	5384118.0
2022-01-28 11:00:00	MSFT	Stock	302.16	305.4	300.96	305.1	4577945.0
2022-01-28 12:00:00	MSFT	Stock	305.13	305.25	302.22	302.44	3126897.0
2022-01-28 13:00:00	MSFT	Stock	302.47	304.5697	302.4	303.6165	2762310.0
2022-01-28 14:00:00	MSFT	Stock	303.6	304.37	299.95	303.09	3371447.0
2022-01-28 15:00:00	MSFT	Stock	303.09	308.48	302.76	308.29	7391098.0
2022-01-28 16:00:00	MSFT	Stock	308.26	308.5	299.84	308.28	5046249.0
2022-01-28 17:00:00	MSFT	Stock	308.25	308.4	308.1	308.3	41904.0
2022-01-28 18:00:00	MSFT	Stock	308.3	308.68	308.3	308.65	6186.0
2022-01-28 19:00:00	MSFT	Stock	308.4	309.0	308.38	308.87	8783.0
2022-01-28 04:00:00	NVDA	Stock	22.127	22.255	22.078	22.225	85190.0
2022-01-28 05:00:00	NVDA	Stock	22.223	22.223	21.721	21.799	192120.0
2022-01-28 06:00:00	NVDA	Stock	21.897	22.005	21.65	21.849	229960.0
2022-01-28 07:00:00	NVDA	Stock	21.886	21.943	21.47	21.542	1149220.0
2022-01-28 08:00:00	NVDA	Stock	21.53	22.0824	21.4713	22.0	2251850.0
2022-01-28 09:00:00	NVDA	Stock	21.99	22.248	21.315	21.469	50877200.0
2022-01-28 10:00:00	NVDA	Stock	21.48	22.321	21.296	22.317	69314750.0
2022-01-28 11:00:00	NVDA	Stock	22.313	22.578	22.091	22.4675	63339870.0
2022-01-28 12:00:00	NVDA	Stock	22.469	22.496	22.124	22.173	29756080.0
2022-01-28 13:00:00	NVDA	Stock	22.163	22.389	22.063	22.091	34114420.0
2022-01-28 14:00:00	NVDA	Stock	22.095	22.215	21.58	22.068	49813840.0
2022-01-28 15:00:00	NVDA	Stock	22.064	22.858	21.987	22.844	81680840.0
2022-01-28 16:00:00	NVDA	Stock	22.84	22.95	21.944	22.89	22629680.0
2022-01-28 17:00:00	NVDA	Stock	22.89	23.05	22.882	22.979	732010.0
2022-01-28 18:00:00	NVDA	Stock	22.99	23.1	22.951	23.08	322130.0
2022-01-28 19:00:00	NVDA	Stock	23.07	23.14	23.04	23.139	388830.0
2022-01-28 07:00:00	AMZN	Stock	139.817	140.025	138.511	139.005	66800.0
2022-01-28 08:00:00	AMZN	Stock	140.151	140.878	138.5	140.369	189000.0

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

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