PREVIEW / stock_1hour / 2021-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-03.parquet
  size:    1.5 MB
  rows:    66,016
  symbols: 2,676

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-12-03 04:00:00	AAPL	Stock	162.53	163.06	162.51	162.73	15705.0
2021-12-03 05:00:00	AAPL	Stock	162.79	162.94	162.0	162.6	20581.0
2021-12-03 06:00:00	AAPL	Stock	162.75	163.18	162.75	163.15	22092.0
2021-12-03 07:00:00	AAPL	Stock	163.17	163.79	163.06	163.76	124342.0
2021-12-03 08:00:00	AAPL	Stock	163.17	165.4	163.12	163.9	739173.0
2021-12-03 09:00:00	AAPL	Stock	163.86	164.96	162.77	163.3	12270312.0
2021-12-03 10:00:00	AAPL	Stock	163.32	163.88	161.8	162.803	16956128.0
2021-12-03 11:00:00	AAPL	Stock	162.81	163.27	160.795	161.025	14634188.0
2021-12-03 12:00:00	AAPL	Stock	161.01	162.41	160.51	161.59	10628682.0
2021-12-03 13:00:00	AAPL	Stock	161.57	161.58	159.77	159.92	10231339.0
2021-12-03 14:00:00	AAPL	Stock	159.92	160.72	159.75	160.075	8825992.0
2021-12-03 15:00:00	AAPL	Stock	160.07	162.18	159.72	161.84	15589034.0
2021-12-03 16:00:00	AAPL	Stock	161.84	162.21	161.2	161.3	13213319.0
2021-12-03 17:00:00	AAPL	Stock	161.3	161.84	161.2	161.43	95084.0
2021-12-03 18:00:00	AAPL	Stock	161.55	161.56	161.37	161.37	36600.0
2021-12-03 19:00:00	AAPL	Stock	161.38	161.56	161.2	161.25	45265.0
2021-12-03 04:00:00	MSFT	Stock	328.75	329.24	328.2	328.33	5160.0
2021-12-03 05:00:00	MSFT	Stock	328.71	328.75	327.07	327.96	8164.0
2021-12-03 06:00:00	MSFT	Stock	328.21	329.0	328.15	329.0	4517.0
2021-12-03 07:00:00	MSFT	Stock	329.48	330.49	329.48	330.49	17477.0
2021-12-03 08:00:00	MSFT	Stock	329.5162	333.56	329.5	331.8	81246.0
2021-12-03 09:00:00	MSFT	Stock	331.31	332.7	327.1	327.4	2595069.0
2021-12-03 10:00:00	MSFT	Stock	327.46	327.68	321.23	321.95	4601187.0
2021-12-03 11:00:00	MSFT	Stock	321.93	323.36	319.51	319.96	3468376.0
2021-12-03 12:00:00	MSFT	Stock	320.0	321.36	319.43	320.2362	2374626.0
2021-12-03 13:00:00	MSFT	Stock	320.23	320.61	318.34	318.72	2546415.0
2021-12-03 14:00:00	MSFT	Stock	318.7	320.76	318.03	319.9	2362522.0
2021-12-03 15:00:00	MSFT	Stock	319.9	323.45	319.35	323.18	4907919.0
2021-12-03 16:00:00	MSFT	Stock	323.01	323.93	322.23	322.5	6407589.0
2021-12-03 17:00:00	MSFT	Stock	322.6	322.95	322.5	322.85	15811.0
2021-12-03 18:00:00	MSFT	Stock	322.87	323.0	322.7	322.75	8871.0
2021-12-03 19:00:00	MSFT	Stock	322.85	322.88	322.7	322.7	8549.0
2021-12-03 04:00:00	NVDA	Stock	31.855	32.095	31.815	31.942	86060.0
2021-12-03 05:00:00	NVDA	Stock	31.969	31.969	31.81	31.81	33940.0
2021-12-03 06:00:00	NVDA	Stock	31.86	31.997	31.86	31.997	37840.0
2021-12-03 07:00:00	NVDA	Stock	31.975	32.029	31.85	31.887	670390.0
2021-12-03 08:00:00	NVDA	Stock	32.0	32.45	31.844	32.125	2271950.0
2021-12-03 09:00:00	NVDA	Stock	32.125	32.165	31.138	31.1665	45319650.0
2021-12-03 10:00:00	NVDA	Stock	31.171	31.2899	30.2	30.632	86760930.0
2021-12-03 11:00:00	NVDA	Stock	30.6315	30.718	30.174	30.242	53200390.0
2021-12-03 12:00:00	NVDA	Stock	30.249	30.69	30.13	30.442	46008430.0
2021-12-03 13:00:00	NVDA	Stock	30.435	30.622	30.23	30.269	36916600.0
2021-12-03 14:00:00	NVDA	Stock	30.27	30.531	30.206	30.249	38755000.0
2021-12-03 15:00:00	NVDA	Stock	30.2542	30.771	30.15	30.706	60155680.0
2021-12-03 16:00:00	NVDA	Stock	30.693	30.805	30.615	30.7	25375620.0
2021-12-03 17:00:00	NVDA	Stock	30.69	30.71	30.64	30.677	268700.0
2021-12-03 18:00:00	NVDA	Stock	30.676	30.695	30.576	30.65	210330.0
2021-12-03 19:00:00	NVDA	Stock	30.601	30.641	30.56	30.57	162140.0
2021-12-03 04:00:00	AMZN	Stock	172.0275	172.0275	172.0	172.0	6000.0
2021-12-03 07:00:00	AMZN	Stock	171.989	172.348	171.989	172.0	68160.0

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

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