PREVIEW / stock_1hour / 2021-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-02.parquet
  size:    1.4 MB
  rows:    64,649
  symbols: 2,892

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-07-02 04:00:00	AAPL	Stock	137.27	137.5	136.86	137.1	18041.0
2021-07-02 05:00:00	AAPL	Stock	137.09	137.32	137.09	137.28	6557.0
2021-07-02 06:00:00	AAPL	Stock	137.21	137.32	137.17	137.3	5555.0
2021-07-02 07:00:00	AAPL	Stock	137.29	137.8	137.28	137.76	103336.0
2021-07-02 08:00:00	AAPL	Stock	137.35	138.275	136.927	138.06	532931.0
2021-07-02 09:00:00	AAPL	Stock	138.0799	139.07	137.56	139.015	11890826.0
2021-07-02 10:00:00	AAPL	Stock	139.015	139.13	138.39	138.5926	10806313.0
2021-07-02 11:00:00	AAPL	Stock	138.5903	139.12	138.56	138.9608	6708673.0
2021-07-02 12:00:00	AAPL	Stock	138.97	139.62	138.97	139.5991	7871026.0
2021-07-02 13:00:00	AAPL	Stock	139.6	139.705	139.35	139.6729	5350834.0
2021-07-02 14:00:00	AAPL	Stock	139.67	139.81	139.37	139.515	5375656.0
2021-07-02 15:00:00	AAPL	Stock	139.515	140.0	139.46	139.96	14196148.0
2021-07-02 16:00:00	AAPL	Stock	139.96	139.98	139.8	139.82	7288311.0
2021-07-02 17:00:00	AAPL	Stock	139.82	139.93	139.81	139.93	50033.0
2021-07-02 18:00:00	AAPL	Stock	139.95	139.96	139.8	139.89	39396.0
2021-07-02 19:00:00	AAPL	Stock	139.89	139.96	139.85	139.85	48612.0
2021-07-02 04:00:00	MSFT	Stock	272.05	272.09	271.9	271.9	971.0
2021-07-02 05:00:00	MSFT	Stock	271.77	271.98	271.55	271.98	2084.0
2021-07-02 06:00:00	MSFT	Stock	271.97	272.25	271.97	272.25	1228.0
2021-07-02 07:00:00	MSFT	Stock	272.25	272.69	272.15	272.69	6854.0
2021-07-02 08:00:00	MSFT	Stock	272.7399	273.0	272.05	272.79	53178.0
2021-07-02 09:00:00	MSFT	Stock	272.8	275.18	272.35	274.75	2984495.0
2021-07-02 10:00:00	MSFT	Stock	274.74	275.295	274.435	275.08	2171991.0
2021-07-02 11:00:00	MSFT	Stock	275.08	276.57	275.0	276.1561	1662071.0
2021-07-02 12:00:00	MSFT	Stock	276.16	276.845	276.11	276.82	2163933.0
2021-07-02 13:00:00	MSFT	Stock	276.81	277.15	276.5	277.0984	2021495.0
2021-07-02 14:00:00	MSFT	Stock	277.1	277.13	276.8	277.065	1414750.0
2021-07-02 15:00:00	MSFT	Stock	277.06	278.0	277.05	277.66	3997718.0
2021-07-02 16:00:00	MSFT	Stock	277.66	277.75	277.25	277.49	4337439.0
2021-07-02 17:00:00	MSFT	Stock	277.45	277.75	277.45	277.65	14397.0
2021-07-02 18:00:00	MSFT	Stock	277.7	277.8	277.5001	277.5001	4789.0
2021-07-02 19:00:00	MSFT	Stock	277.65	277.85	277.53	277.85	8902.0
2021-07-02 04:00:00	NVDA	Stock	20.3	20.3258	20.3	20.3052	34320.0
2021-07-02 05:00:00	NVDA	Stock	20.3153	20.3153	20.31	20.31	19480.0
2021-07-02 07:00:00	NVDA	Stock	20.31	20.325	20.2812	20.3125	502480.0
2021-07-02 08:00:00	NVDA	Stock	20.2956	20.4595	20.2818	20.427	1983480.0
2021-07-02 09:00:00	NVDA	Stock	20.4275	20.5125	20.2878	20.3495	47671960.0
2021-07-02 10:00:00	NVDA	Stock	20.3465	20.4665	20.3128	20.3448	46538880.0
2021-07-02 11:00:00	NVDA	Stock	20.3482	20.4442	20.3448	20.4148	24348400.0
2021-07-02 12:00:00	NVDA	Stock	20.4152	20.431	20.3303	20.3503	16029880.0
2021-07-02 13:00:00	NVDA	Stock	20.3538	20.394	20.335	20.3864	10653080.0
2021-07-02 14:00:00	NVDA	Stock	20.3845	20.437	20.3613	20.4032	16145480.0
2021-07-02 15:00:00	NVDA	Stock	20.4031	20.5053	20.378	20.487	35425360.0
2021-07-02 16:00:00	NVDA	Stock	20.487	20.4912	20.4695	20.475	17855000.0
2021-07-02 17:00:00	NVDA	Stock	20.4725	20.5	20.4575	20.4875	320120.0
2021-07-02 18:00:00	NVDA	Stock	20.493	20.4942	20.4875	20.4928	72880.0
2021-07-02 19:00:00	NVDA	Stock	20.4938	20.5	20.4875	20.4988	337320.0
2021-07-02 06:00:00	AMZN	Stock	171.749	171.749	171.749	171.749	2000.0
2021-07-02 07:00:00	AMZN	Stock	171.8255	171.8255	171.8	171.825	16600.0
2021-07-02 08:00:00	AMZN	Stock	172.1	172.45	172.029	172.45	51860.0

> showing 50 of 64,649 rows — these rows as CSV

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