PREVIEW / stock_1hour / 2021-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-09.parquet
  size:    1.4 MB
  rows:    65,108
  symbols: 2,949

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
2021-04-09 04:00:00	AAPL	Stock	130.29	130.34	129.86	130.19	23527.0
2021-04-09 05:00:00	AAPL	Stock	130.2	130.2	129.81	129.9	12111.0
2021-04-09 06:00:00	AAPL	Stock	129.9	130.05	129.59	130.02	29551.0
2021-04-09 07:00:00	AAPL	Stock	130.03	130.27	129.91	130.02	168975.0
2021-04-09 08:00:00	AAPL	Stock	130.0	130.685	129.3	129.44	751557.0
2021-04-09 09:00:00	AAPL	Stock	129.42	131.055	129.3	130.851	12983643.0
2021-04-09 10:00:00	AAPL	Stock	130.84	131.43	130.67	130.7701	14493856.0
2021-04-09 11:00:00	AAPL	Stock	130.78	131.55	130.54	131.4317	10852828.0
2021-04-09 12:00:00	AAPL	Stock	131.433	131.81	131.2701	131.775	7414916.0
2021-04-09 13:00:00	AAPL	Stock	131.775	132.62	131.7317	132.4	12222660.0
2021-04-09 14:00:00	AAPL	Stock	132.41	132.495	132.01	132.2612	8772762.0
2021-04-09 15:00:00	AAPL	Stock	132.263	133.04	131.9	132.99	18332360.0
2021-04-09 16:00:00	AAPL	Stock	132.995	133.03	130.9746	132.92	7601855.0
2021-04-09 17:00:00	AAPL	Stock	132.92	133.03	132.84	132.96	183140.0
2021-04-09 18:00:00	AAPL	Stock	132.98	133.03	132.82	132.88	90451.0
2021-04-09 19:00:00	AAPL	Stock	132.86	132.95	132.83	132.91	87976.0
2021-04-09 04:00:00	MSFT	Stock	253.0	253.0	252.79	253.0	1490.0
2021-04-09 05:00:00	MSFT	Stock	252.87	252.87	252.67	252.67	2707.0
2021-04-09 06:00:00	MSFT	Stock	252.7	252.99	252.67	252.99	2532.0
2021-04-09 07:00:00	MSFT	Stock	253.08	253.27	252.96	253.0	13470.0
2021-04-09 08:00:00	MSFT	Stock	253.4	253.4	252.0	252.16	60636.0
2021-04-09 09:00:00	MSFT	Stock	252.1	254.25	252.0	254.14	2487680.0
2021-04-09 10:00:00	MSFT	Stock	254.17	254.84	253.9271	254.13	2656549.0
2021-04-09 11:00:00	MSFT	Stock	254.145	254.87	253.71	254.805	1777132.0
2021-04-09 12:00:00	MSFT	Stock	254.8	255.07	254.25	254.42	1629448.0
2021-04-09 13:00:00	MSFT	Stock	254.4344	254.92	254.23	254.6533	1077818.0
2021-04-09 14:00:00	MSFT	Stock	254.67	254.82	254.09	254.305	1297438.0
2021-04-09 15:00:00	MSFT	Stock	254.3	255.99	254.06	255.84	4318436.0
2021-04-09 16:00:00	MSFT	Stock	255.85	256.0	253.9796	255.61	3177132.0
2021-04-09 17:00:00	MSFT	Stock	255.66	255.85	255.58	255.8	6190.0
2021-04-09 18:00:00	MSFT	Stock	255.75	255.78	255.58	255.6	5077.0
2021-04-09 19:00:00	MSFT	Stock	255.69	255.83	255.6	255.75	4860.0
2021-04-09 05:00:00	NVDA	Stock	14.265	14.265	14.2628	14.2628	11800.0
2021-04-09 06:00:00	NVDA	Stock	14.2678	14.2678	14.2678	14.2678	15600.0
2021-04-09 07:00:00	NVDA	Stock	14.2875	14.328	14.275	14.275	51520.0
2021-04-09 08:00:00	NVDA	Stock	14.35	14.35	14.1568	14.175	308440.0
2021-04-09 09:00:00	NVDA	Stock	14.1972	14.3065	14.1648	14.3022	15978200.0
2021-04-09 10:00:00	NVDA	Stock	14.298	14.3775	14.2875	14.309	18714440.0
2021-04-09 11:00:00	NVDA	Stock	14.3112	14.348	14.277	14.3439	11765840.0
2021-04-09 12:00:00	NVDA	Stock	14.3468	14.3692	14.2722	14.317	8132880.0
2021-04-09 13:00:00	NVDA	Stock	14.3205	14.3363	14.2898	14.3038	6691880.0
2021-04-09 14:00:00	NVDA	Stock	14.3052	14.3088	14.2505	14.2822	8358480.0
2021-04-09 15:00:00	NVDA	Stock	14.2826	14.408	14.2453	14.4	28621160.0
2021-04-09 16:00:00	NVDA	Stock	14.4	14.4	14.3738	14.375	25008960.0
2021-04-09 17:00:00	NVDA	Stock	14.3755	14.4	14.375	14.4	80200.0
2021-04-09 18:00:00	NVDA	Stock	14.3775	14.3775	14.3763	14.3773	38920.0
2021-04-09 19:00:00	NVDA	Stock	14.3825	14.3938	14.3825	14.3875	89840.0
2021-04-09 05:00:00	AMZN	Stock	164.75	164.9	164.75	164.9	5220.0
2021-04-09 07:00:00	AMZN	Stock	164.9875	165.6	164.9875	165.5	86160.0
2021-04-09 08:00:00	AMZN	Stock	164.9	165.645	164.3525	164.4515	184540.0

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

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