PREVIEW / stock_1hour / 2021-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-10.parquet
  size:    1.4 MB
  rows:    64,870
  symbols: 2,668

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-10 04:00:00	AAPL	Stock	174.73	175.15	174.56	175.0	34549.0
2021-12-10 05:00:00	AAPL	Stock	174.96	174.97	174.48	174.68	8409.0
2021-12-10 06:00:00	AAPL	Stock	174.66	175.19	174.66	175.05	50813.0
2021-12-10 07:00:00	AAPL	Stock	175.01	175.15	174.63	174.74	111488.0
2021-12-10 08:00:00	AAPL	Stock	174.85	175.88	174.124	175.45	846275.0
2021-12-10 09:00:00	AAPL	Stock	175.46	176.556	174.69	175.18	13728812.0
2021-12-10 10:00:00	AAPL	Stock	175.18	176.99	175.09	176.14	16705131.0
2021-12-10 11:00:00	AAPL	Stock	176.12	176.74	175.4	176.7	10478488.0
2021-12-10 12:00:00	AAPL	Stock	176.71	177.32	176.6	177.29	9950830.0
2021-12-10 13:00:00	AAPL	Stock	177.3	177.8199	177.045	177.6839	9359678.0
2021-12-10 14:00:00	AAPL	Stock	177.6773	177.91	177.58	177.84	8397369.0
2021-12-10 15:00:00	AAPL	Stock	177.831	179.63	177.67	179.5	20498887.0
2021-12-10 16:00:00	AAPL	Stock	179.49	179.75	179.22	179.58	9190687.0
2021-12-10 17:00:00	AAPL	Stock	179.58	179.67	179.42	179.6	1382360.0
2021-12-10 18:00:00	AAPL	Stock	179.66	179.71	179.5	179.65	66594.0
2021-12-10 19:00:00	AAPL	Stock	179.65	179.94	179.63	179.84	99453.0
2021-12-10 04:00:00	MSFT	Stock	332.89	333.81	332.89	333.8	2993.0
2021-12-10 05:00:00	MSFT	Stock	333.75	333.76	333.75	333.76	1500.0
2021-12-10 06:00:00	MSFT	Stock	333.97	334.0	333.91	333.91	841.0
2021-12-10 07:00:00	MSFT	Stock	333.91	333.91	333.01	333.1	4942.0
2021-12-10 08:00:00	MSFT	Stock	333.865	336.29	332.7	335.69	87469.0
2021-12-10 09:00:00	MSFT	Stock	335.6	339.0	334.35	338.2999	3226473.0
2021-12-10 10:00:00	MSFT	Stock	338.3	342.7	338.11	340.98	7187126.0
2021-12-10 11:00:00	MSFT	Stock	340.93	340.96	338.36	339.95	3400911.0
2021-12-10 12:00:00	MSFT	Stock	339.9697	340.29	338.25	340.26	1765697.0
2021-12-10 13:00:00	MSFT	Stock	340.26	340.95	339.95	340.525	1888927.0
2021-12-10 14:00:00	MSFT	Stock	340.525	341.1	339.6	339.9401	2061134.0
2021-12-10 15:00:00	MSFT	Stock	339.94	343.0	339.8	342.23	4594213.0
2021-12-10 16:00:00	MSFT	Stock	342.34	342.71	341.92	342.5	5095159.0
2021-12-10 17:00:00	MSFT	Stock	342.5	342.6	342.31	342.3101	600147.0
2021-12-10 18:00:00	MSFT	Stock	342.31	342.49	342.26	342.4	3900.0
2021-12-10 19:00:00	MSFT	Stock	342.4	342.58	342.4	342.5	8750.0
2021-12-10 04:00:00	NVDA	Stock	30.57	30.704	30.55	30.647	95520.0
2021-12-10 05:00:00	NVDA	Stock	30.681	30.682	30.647	30.672	21820.0
2021-12-10 06:00:00	NVDA	Stock	30.686	30.767	30.679	30.68	28640.0
2021-12-10 07:00:00	NVDA	Stock	30.752	30.875	30.7	30.875	774280.0
2021-12-10 08:00:00	NVDA	Stock	30.75	31.29	30.5662	31.152	3771510.0
2021-12-10 09:00:00	NVDA	Stock	31.156	31.325	30.25	30.42	65376160.0
2021-12-10 10:00:00	NVDA	Stock	30.4035	30.8628	30.1782	30.411	68831010.0
2021-12-10 11:00:00	NVDA	Stock	30.402	30.425	29.933	30.277	57882870.0
2021-12-10 12:00:00	NVDA	Stock	30.2622	30.394	30.065	30.161	37210120.0
2021-12-10 13:00:00	NVDA	Stock	30.165	30.291	29.861	30.008	39690400.0
2021-12-10 14:00:00	NVDA	Stock	29.9942	30.1	29.911	29.9885	30378780.0
2021-12-10 15:00:00	NVDA	Stock	29.991	30.232	29.936	30.191	53483690.0
2021-12-10 16:00:00	NVDA	Stock	30.198	30.23	30.15	30.167	20867910.0
2021-12-10 17:00:00	NVDA	Stock	30.166	30.198	30.101	30.172	3098690.0
2021-12-10 18:00:00	NVDA	Stock	30.16	30.169	30.135	30.15	86380.0
2021-12-10 19:00:00	NVDA	Stock	30.155	30.193	30.151	30.19	124140.0
2021-12-10 05:00:00	AMZN	Stock	174.75	174.75	174.75	174.75	2000.0
2021-12-10 07:00:00	AMZN	Stock	174.856	174.856	174.856	174.856	2140.0

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

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