PREVIEW / stock_1hour / 2022-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-28.parquet
  size:    1.4 MB
  rows:    65,700
  symbols: 2,561

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-02-28 04:00:00	AAPL	Stock	163.18	163.28	161.36	162.42	46978.0
2022-02-28 05:00:00	AAPL	Stock	162.41	162.68	161.99	162.59	6671.0
2022-02-28 06:00:00	AAPL	Stock	162.6	162.86	162.3	162.7	24585.0
2022-02-28 07:00:00	AAPL	Stock	162.7	163.8	162.52	162.98	176370.0
2022-02-28 08:00:00	AAPL	Stock	162.9	163.8	161.1	163.03	588810.0
2022-02-28 09:00:00	AAPL	Stock	163.01	164.81	162.78	164.74	9203917.0
2022-02-28 10:00:00	AAPL	Stock	164.74	165.14	163.19	164.84	10550000.0
2022-02-28 11:00:00	AAPL	Stock	164.86	165.42	164.6	164.96	7530301.0
2022-02-28 12:00:00	AAPL	Stock	164.96	165.23	163.71	164.1052	6695649.0
2022-02-28 13:00:00	AAPL	Stock	164.1	164.9488	163.77	164.26	5914893.0
2022-02-28 14:00:00	AAPL	Stock	164.26	164.26	162.43	163.43	7427292.0
2022-02-28 15:00:00	AAPL	Stock	163.42	165.4	162.64	165.13	14839730.0
2022-02-28 16:00:00	AAPL	Stock	164.97	165.2	164.6	164.95	15253593.0
2022-02-28 17:00:00	AAPL	Stock	165.0	165.18	164.74	164.76	25466.0
2022-02-28 18:00:00	AAPL	Stock	164.76	165.37	164.73	165.31	79660.0
2022-02-28 19:00:00	AAPL	Stock	165.26	165.3	164.75	164.8	45982.0
2022-02-28 04:00:00	MSFT	Stock	295.47	295.47	292.09	292.68	7363.0
2022-02-28 05:00:00	MSFT	Stock	292.6	292.6	292.0	292.0	382.0
2022-02-28 06:00:00	MSFT	Stock	293.01	293.01	292.6	292.8	2719.0
2022-02-28 07:00:00	MSFT	Stock	292.8	294.58	292.51	292.51	24037.0
2022-02-28 08:00:00	MSFT	Stock	293.8	294.75	292.0	292.696	66019.0
2022-02-28 09:00:00	MSFT	Stock	292.4	296.92	292.4	296.49	2187275.0
2022-02-28 10:00:00	MSFT	Stock	296.46	297.69	293.73	296.83	2839898.0
2022-02-28 11:00:00	MSFT	Stock	296.86	298.54	296.31	297.8656	2332718.0
2022-02-28 12:00:00	MSFT	Stock	297.86	298.115	294.38	294.99	2460822.0
2022-02-28 13:00:00	MSFT	Stock	294.97	296.7399	294.82	295.815	1559552.0
2022-02-28 14:00:00	MSFT	Stock	295.8	295.8	293.0	294.53	2203782.0
2022-02-28 15:00:00	MSFT	Stock	294.5899	299.14	293.2	299.13	4762667.0
2022-02-28 16:00:00	MSFT	Stock	298.79	299.0	298.23	298.87	6919874.0
2022-02-28 17:00:00	MSFT	Stock	298.92	298.96	298.6	298.6	9923.0
2022-02-28 18:00:00	MSFT	Stock	298.79	299.77	298.65	299.76	13879.0
2022-02-28 19:00:00	MSFT	Stock	299.34	299.5	298.51	299.0	9089.0
2022-02-28 04:00:00	NVDA	Stock	23.597	23.85	23.565	23.62	206440.0
2022-02-28 05:00:00	NVDA	Stock	23.64	23.663	23.521	23.63	36340.0
2022-02-28 06:00:00	NVDA	Stock	23.67	23.73	23.6	23.636	37810.0
2022-02-28 07:00:00	NVDA	Stock	23.633	23.921	23.61	23.734	908540.0
2022-02-28 08:00:00	NVDA	Stock	23.8	23.92	22.985	23.725	1304370.0
2022-02-28 09:00:00	NVDA	Stock	23.725	24.263	23.72	24.236	44926420.0
2022-02-28 10:00:00	NVDA	Stock	24.237	24.575	23.967	24.491	58096340.0
2022-02-28 11:00:00	NVDA	Stock	24.496	24.643	24.355	24.602	39917560.0
2022-02-28 12:00:00	NVDA	Stock	24.604	24.665	23.87	24.016	42764620.0
2022-02-28 13:00:00	NVDA	Stock	24.01	24.223	23.933	24.1255	35081700.0
2022-02-28 14:00:00	NVDA	Stock	24.1258	24.1258	23.707	23.963	31827290.0
2022-02-28 15:00:00	NVDA	Stock	23.959	24.389	23.865	24.389	46239000.0
2022-02-28 16:00:00	NVDA	Stock	24.388	24.5	24.301	24.335	46901310.0
2022-02-28 17:00:00	NVDA	Stock	24.336	24.35	24.302	24.32	243980.0
2022-02-28 18:00:00	NVDA	Stock	24.32	24.474	24.32	24.474	448640.0
2022-02-28 19:00:00	NVDA	Stock	24.41	24.47	24.306	24.306	364840.0
2022-02-28 04:00:00	AMZN	Stock	151.44	151.44	151.2495	151.2495	4000.0
2022-02-28 05:00:00	AMZN	Stock	151.4	151.5	151.4	151.5	8000.0

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

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