PREVIEW / stock_1hour / 2022-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-19.parquet
  size:    1.4 MB
  rows:    65,536
  symbols: 2,617

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-19 04:00:00	AAPL	Stock	169.3	170.1	169.3	170.1	38174.0
2022-01-19 05:00:00	AAPL	Stock	170.16	170.35	170.08	170.35	14038.0
2022-01-19 06:00:00	AAPL	Stock	170.43	170.5	170.0	170.25	8243.0
2022-01-19 07:00:00	AAPL	Stock	170.27	170.35	169.87	170.24	69856.0
2022-01-19 08:00:00	AAPL	Stock	170.3001	170.88	169.95	170.72	434512.0
2022-01-19 09:00:00	AAPL	Stock	170.76	170.98	169.28	170.9315	9034099.0
2022-01-19 10:00:00	AAPL	Stock	170.95	171.08	168.64	168.895	11640946.0
2022-01-19 11:00:00	AAPL	Stock	168.9	169.2485	167.32	168.33	12233356.0
2022-01-19 12:00:00	AAPL	Stock	168.33	169.62	168.33	169.08	6978446.0
2022-01-19 13:00:00	AAPL	Stock	169.08	169.45	168.37	168.45	6268642.0
2022-01-19 14:00:00	AAPL	Stock	168.44	168.66	167.54	167.95	8210664.0
2022-01-19 15:00:00	AAPL	Stock	167.95	168.2699	165.94	166.21	14517770.0
2022-01-19 16:00:00	AAPL	Stock	166.23	166.23	165.01	165.75	9236490.0
2022-01-19 17:00:00	AAPL	Stock	165.74	165.85	165.57	165.7301	67423.0
2022-01-19 18:00:00	AAPL	Stock	165.75	165.99	165.31	165.46	82267.0
2022-01-19 19:00:00	AAPL	Stock	165.46	166.1	165.46	165.72	112365.0
2022-01-19 04:00:00	MSFT	Stock	302.61	303.9	302.5	303.9	5988.0
2022-01-19 05:00:00	MSFT	Stock	303.87	304.6	303.78	304.16	4376.0
2022-01-19 06:00:00	MSFT	Stock	304.63	304.72	304.15	304.72	9537.0
2022-01-19 07:00:00	MSFT	Stock	304.72	305.0	304.32	304.99	34672.0
2022-01-19 08:00:00	MSFT	Stock	304.5	307.0	303.406	306.7	95542.0
2022-01-19 09:00:00	MSFT	Stock	306.65	313.9	305.3	313.38	5995048.0
2022-01-19 10:00:00	MSFT	Stock	313.38	313.9093	307.32	307.915	6279907.0
2022-01-19 11:00:00	MSFT	Stock	307.9	309.35	306.29	308.65	3986838.0
2022-01-19 12:00:00	MSFT	Stock	308.61	311.35	308.61	311.18	3387552.0
2022-01-19 13:00:00	MSFT	Stock	311.26	311.325	309.06	309.58	2180592.0
2022-01-19 14:00:00	MSFT	Stock	309.56	309.88	307.6	308.31	2134959.0
2022-01-19 15:00:00	MSFT	Stock	308.32	308.87	302.7	303.31	5198126.0
2022-01-19 16:00:00	MSFT	Stock	303.37	304.0	302.86	303.45	4450571.0
2022-01-19 17:00:00	MSFT	Stock	303.42	303.9499	303.0	303.7	26095.0
2022-01-19 18:00:00	MSFT	Stock	303.89	304.65	302.9	303.0	24679.0
2022-01-19 19:00:00	MSFT	Stock	303.1	304.5	303.0	304.39	39833.0
2022-01-19 04:00:00	NVDA	Stock	25.74	26.13	25.735	26.127	325500.0
2022-01-19 05:00:00	NVDA	Stock	26.082	26.1	25.984	26.015	132140.0
2022-01-19 06:00:00	NVDA	Stock	26.04	26.043	25.913	26.029	51180.0
2022-01-19 07:00:00	NVDA	Stock	26.02	26.045	25.96	26.034	402210.0
2022-01-19 08:00:00	NVDA	Stock	25.985	26.175	25.95	26.169	1311730.0
2022-01-19 09:00:00	NVDA	Stock	26.15	26.5432	26.009	26.495	48604940.0
2022-01-19 10:00:00	NVDA	Stock	26.497	26.506	25.42	25.663	62516610.0
2022-01-19 11:00:00	NVDA	Stock	25.656	25.807	25.063	25.334	68705380.0
2022-01-19 12:00:00	NVDA	Stock	25.331	25.899	25.328	25.819	50216680.0
2022-01-19 13:00:00	NVDA	Stock	25.819	25.832	25.475	25.599	25360610.0
2022-01-19 14:00:00	NVDA	Stock	25.593	25.635	25.293	25.438	29249300.0
2022-01-19 15:00:00	NVDA	Stock	25.442	25.518	25.052	25.062	42201170.0
2022-01-19 16:00:00	NVDA	Stock	25.067	25.123	24.901	24.98	15135020.0
2022-01-19 17:00:00	NVDA	Stock	24.998	25.016	24.945	24.995	481640.0
2022-01-19 18:00:00	NVDA	Stock	24.995	25.02	24.868	24.875	625880.0
2022-01-19 19:00:00	NVDA	Stock	24.893	25.13	24.893	25.077	624510.0
2022-01-19 07:00:00	AMZN	Stock	158.806	159.1995	158.806	159.05	10700.0
2022-01-19 08:00:00	AMZN	Stock	159.2279	159.831	159.2274	159.45	41660.0

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

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