PREVIEW / stock_1hour / 2022-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-02.parquet
  size:    1.4 MB
  rows:    63,034
  symbols: 2,271

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-08-02 04:00:00	AAPL	Stock	161.28	161.28	160.04	160.1	46117.0
2022-08-02 05:00:00	AAPL	Stock	160.14	160.23	159.8	159.8	20598.0
2022-08-02 06:00:00	AAPL	Stock	159.8	159.96	159.55	159.8	36006.0
2022-08-02 07:00:00	AAPL	Stock	159.85	160.36	159.74	160.2	69893.0
2022-08-02 08:00:00	AAPL	Stock	160.05	161.107	159.84	160.15	282156.0
2022-08-02 09:00:00	AAPL	Stock	160.16	161.08	159.75	160.545	6492134.0
2022-08-02 10:00:00	AAPL	Stock	160.5508	161.725	159.63	161.25	8412809.0
2022-08-02 11:00:00	AAPL	Stock	161.25	161.48	160.55	161.16	4031552.0
2022-08-02 12:00:00	AAPL	Stock	161.17	162.41	161.1	162.205	4312051.0
2022-08-02 13:00:00	AAPL	Stock	162.205	162.28	160.075	160.4	5940945.0
2022-08-02 14:00:00	AAPL	Stock	160.4	161.3	160.245	160.645	5483509.0
2022-08-02 15:00:00	AAPL	Stock	160.64	160.87	159.93	159.99	8234379.0
2022-08-02 16:00:00	AAPL	Stock	159.99	160.16	159.8	160.08	5040840.0
2022-08-02 17:00:00	AAPL	Stock	160.14	160.35	160.1	160.17	47160.0
2022-08-02 18:00:00	AAPL	Stock	160.17	160.22	159.93	159.93	31127.0
2022-08-02 19:00:00	AAPL	Stock	159.93	160.24	159.9	160.0	32188.0
2022-08-02 04:00:00	MSFT	Stock	276.19	276.19	275.76	275.76	2104.0
2022-08-02 05:00:00	MSFT	Stock	276.08	276.08	275.0	275.2	2831.0
2022-08-02 06:00:00	MSFT	Stock	275.2	275.61	274.9	275.61	5990.0
2022-08-02 07:00:00	MSFT	Stock	275.99	276.87	275.8	276.0	11348.0
2022-08-02 08:00:00	MSFT	Stock	275.7	277.315	275.5	275.98	27902.0
2022-08-02 09:00:00	MSFT	Stock	276.07	276.7685	272.96	273.855	2348489.0
2022-08-02 10:00:00	MSFT	Stock	273.855	275.76	272.38	274.95	2653319.0
2022-08-02 11:00:00	MSFT	Stock	274.93	275.57	274.17	274.84	1348390.0
2022-08-02 12:00:00	MSFT	Stock	274.84	277.89	274.8096	277.26	1389636.0
2022-08-02 13:00:00	MSFT	Stock	277.25	277.3	273.45	274.05	1848736.0
2022-08-02 14:00:00	MSFT	Stock	274.04	275.35	273.8903	274.99	1490960.0
2022-08-02 15:00:00	MSFT	Stock	275.05	275.64	274.17	274.84	2372520.0
2022-08-02 16:00:00	MSFT	Stock	274.78	274.96	274.01	274.74	3117507.0
2022-08-02 17:00:00	MSFT	Stock	274.85	274.94	274.52	274.7	7634.0
2022-08-02 18:00:00	MSFT	Stock	274.7	274.89	274.32	274.51	4038.0
2022-08-02 19:00:00	MSFT	Stock	274.61	274.79	274.53	274.78	4859.0
2022-08-02 04:00:00	NVDA	Stock	18.305	18.349	18.131	18.166	96140.0
2022-08-02 05:00:00	NVDA	Stock	18.169	18.18	18.111	18.111	70350.0
2022-08-02 06:00:00	NVDA	Stock	18.13	18.13	18.071	18.118	134080.0
2022-08-02 07:00:00	NVDA	Stock	18.103	18.221	18.103	18.188	288040.0
2022-08-02 08:00:00	NVDA	Stock	18.37	18.37	18.119	18.1757	892230.0
2022-08-02 09:00:00	NVDA	Stock	18.195	18.498	18.092	18.357	47644380.0
2022-08-02 10:00:00	NVDA	Stock	18.355	18.578	18.125	18.51	64506520.0
2022-08-02 11:00:00	NVDA	Stock	18.503	18.583	18.355	18.543	46897220.0
2022-08-02 12:00:00	NVDA	Stock	18.543	18.9375	18.533	18.845	62394630.0
2022-08-02 13:00:00	NVDA	Stock	18.845	18.8692	18.4725	18.5425	52438790.0
2022-08-02 14:00:00	NVDA	Stock	18.5475	18.744	18.477	18.5985	48026800.0
2022-08-02 15:00:00	NVDA	Stock	18.5905	18.663	18.515	18.526	47744630.0
2022-08-02 16:00:00	NVDA	Stock	18.525	18.625	18.107	18.185	13474910.0
2022-08-02 17:00:00	NVDA	Stock	18.185	18.19	18.107	18.142	1625600.0
2022-08-02 18:00:00	NVDA	Stock	18.15	18.2	18.121	18.132	543580.0
2022-08-02 19:00:00	NVDA	Stock	18.145	18.145	18.121	18.137	339280.0
2022-08-02 04:00:00	AMZN	Stock	134.92	134.99	134.11	134.13	16559.0
2022-08-02 05:00:00	AMZN	Stock	134.3	134.38	133.52	133.53	18132.0

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

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