PREVIEW / stock_1hour / 2022-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-02.parquet
  size:    1.4 MB
  rows:    63,016
  symbols: 2,512

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-02 04:00:00	AAPL	Stock	165.0	165.0	162.56	163.8	14724.0
2022-03-02 05:00:00	AAPL	Stock	163.87	164.74	163.6	164.1	14502.0
2022-03-02 06:00:00	AAPL	Stock	164.05	164.72	164.05	164.49	13750.0
2022-03-02 07:00:00	AAPL	Stock	164.43	164.6	163.65	163.9	87690.0
2022-03-02 08:00:00	AAPL	Stock	164.5199	164.9	163.23	163.65	387846.0
2022-03-02 09:00:00	AAPL	Stock	163.66	164.69	163.05	164.0432	7169347.0
2022-03-02 10:00:00	AAPL	Stock	164.05	165.18	162.95	164.595	11586570.0
2022-03-02 11:00:00	AAPL	Stock	164.61	166.47	164.17	165.89	10826184.0
2022-03-02 12:00:00	AAPL	Stock	165.88	166.725	165.71	166.1972	7388861.0
2022-03-02 13:00:00	AAPL	Stock	166.2	167.0	166.2	166.7029	5326871.0
2022-03-02 14:00:00	AAPL	Stock	166.72	167.25	166.6	166.755	5845676.0
2022-03-02 15:00:00	AAPL	Stock	166.75	167.36	166.4	166.54	10814480.0
2022-03-02 16:00:00	AAPL	Stock	166.52	166.56	165.95	166.19	9210120.0
2022-03-02 17:00:00	AAPL	Stock	166.16	166.25	165.99	166.05	17236.0
2022-03-02 18:00:00	AAPL	Stock	166.1	166.33	166.07	166.3	20880.0
2022-03-02 19:00:00	AAPL	Stock	166.32	166.54	166.21	166.36	35685.0
2022-03-02 04:00:00	MSFT	Stock	294.74	296.81	293.74	296.42	4638.0
2022-03-02 05:00:00	MSFT	Stock	296.68	297.59	296.01	296.12	1997.0
2022-03-02 06:00:00	MSFT	Stock	296.81	297.3	296.45	296.45	484.0
2022-03-02 07:00:00	MSFT	Stock	297.1	297.32	296.0	297.28	14506.0
2022-03-02 08:00:00	MSFT	Stock	297.0	297.79	295.13	295.3	32423.0
2022-03-02 09:00:00	MSFT	Stock	295.69	298.37	294.5	296.34	2542426.0
2022-03-02 10:00:00	MSFT	Stock	296.39	297.95	293.698	296.31	2708400.0
2022-03-02 11:00:00	MSFT	Stock	296.29	299.57	295.34	298.2795	2397958.0
2022-03-02 12:00:00	MSFT	Stock	298.33	299.73	298.0248	299.05	1733349.0
2022-03-02 13:00:00	MSFT	Stock	299.06	300.68	298.94	299.6743	2083901.0
2022-03-02 14:00:00	MSFT	Stock	299.71	301.07	299.45	300.62	1659365.0
2022-03-02 15:00:00	MSFT	Stock	300.61	301.47	299.75	300.33	4455436.0
2022-03-02 16:00:00	MSFT	Stock	300.19	300.37	297.25	297.76	3560680.0
2022-03-02 17:00:00	MSFT	Stock	298.0	298.75	298.0	298.1	9761.0
2022-03-02 18:00:00	MSFT	Stock	298.26	298.67	298.26	298.43	8632.0
2022-03-02 19:00:00	MSFT	Stock	298.7	299.0	298.5001	298.98	6009.0
2022-03-02 04:00:00	NVDA	Stock	23.367	23.801	23.336	23.801	76810.0
2022-03-02 05:00:00	NVDA	Stock	23.731	23.885	23.663	23.748	81630.0
2022-03-02 06:00:00	NVDA	Stock	23.721	23.804	23.72	23.804	19480.0
2022-03-02 07:00:00	NVDA	Stock	23.792	23.82	23.68	23.711	285910.0
2022-03-02 08:00:00	NVDA	Stock	23.79	23.8	23.568	23.623	725400.0
2022-03-02 09:00:00	NVDA	Stock	23.623	24.018	23.548	23.814	37170960.0
2022-03-02 10:00:00	NVDA	Stock	23.819	23.95	23.415	23.697	62475630.0
2022-03-02 11:00:00	NVDA	Stock	23.698	24.151	23.627	24.002	43702390.0
2022-03-02 12:00:00	NVDA	Stock	24.0128	24.19	23.951	24.0993	29435520.0
2022-03-02 13:00:00	NVDA	Stock	24.1	24.32	24.097	24.221	26303100.0
2022-03-02 14:00:00	NVDA	Stock	24.222	24.388	24.17	24.27	31488210.0
2022-03-02 15:00:00	NVDA	Stock	24.263	24.409	24.203	24.214	41768280.0
2022-03-02 16:00:00	NVDA	Stock	24.22	24.236	23.903	24.032	18750520.0
2022-03-02 17:00:00	NVDA	Stock	24.007	24.05	23.97	24.008	314860.0
2022-03-02 18:00:00	NVDA	Stock	24.025	24.06	23.95	23.996	175140.0
2022-03-02 19:00:00	NVDA	Stock	24.014	24.04	23.98	24.04	151120.0
2022-03-02 04:00:00	AMZN	Stock	150.5	150.5	150.5	150.5	2000.0
2022-03-02 05:00:00	AMZN	Stock	151.808	152.006	151.808	151.999	8940.0

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

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