PREVIEW / stock_1hour / 2022-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-24.parquet
  size:    1.4 MB
  rows:    62,323
  symbols: 2,399

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-05-24 04:00:00	AAPL	Stock	140.69	141.0	139.9	140.43	59156.0
2022-05-24 05:00:00	AAPL	Stock	140.5	141.0	140.4	141.0	16802.0
2022-05-24 06:00:00	AAPL	Stock	140.96	141.24	140.85	141.0	33506.0
2022-05-24 07:00:00	AAPL	Stock	141.05	141.5	140.91	141.0	140748.0
2022-05-24 08:00:00	AAPL	Stock	141.25	141.5	140.72	141.19	894124.0
2022-05-24 09:00:00	AAPL	Stock	141.21	141.97	139.23	139.33	12951206.0
2022-05-24 10:00:00	AAPL	Stock	139.33	139.34	137.33	138.17	16818387.0
2022-05-24 11:00:00	AAPL	Stock	138.17	139.555	137.86	139.17	9942451.0
2022-05-24 12:00:00	AAPL	Stock	139.175	140.27	138.52	139.11	8928298.0
2022-05-24 13:00:00	AAPL	Stock	139.11	139.7	138.15	139.3209	8185262.0
2022-05-24 14:00:00	AAPL	Stock	139.34	140.22	138.69	139.11	10530574.0
2022-05-24 15:00:00	AAPL	Stock	139.105	140.9405	138.95	140.42	17701821.0
2022-05-24 16:00:00	AAPL	Stock	140.52	140.87	140.29	140.69	5640782.0
2022-05-24 17:00:00	AAPL	Stock	140.66	140.77	140.61	140.75	37625.0
2022-05-24 18:00:00	AAPL	Stock	140.74	141.32	140.69	141.24	79332.0
2022-05-24 19:00:00	AAPL	Stock	141.27	141.6	141.22	141.6	93314.0
2022-05-24 04:00:00	MSFT	Stock	256.89	257.79	256.75	256.75	11981.0
2022-05-24 05:00:00	MSFT	Stock	257.01	258.0	256.7	257.62	4153.0
2022-05-24 06:00:00	MSFT	Stock	257.59	257.91	257.59	257.59	3504.0
2022-05-24 07:00:00	MSFT	Stock	257.74	258.5	257.61	257.61	11990.0
2022-05-24 08:00:00	MSFT	Stock	257.851	259.999	257.39	258.16	27885.0
2022-05-24 09:00:00	MSFT	Stock	258.21	259.523	256.319	256.465	2714699.0
2022-05-24 10:00:00	MSFT	Stock	256.44	256.92	253.5	255.14	4044118.0
2022-05-24 11:00:00	MSFT	Stock	255.15	257.91	254.72	257.38	1812770.0
2022-05-24 12:00:00	MSFT	Stock	257.36	259.57	256.98	257.9	1806149.0
2022-05-24 13:00:00	MSFT	Stock	257.83	259.39	256.52	258.61	1547390.0
2022-05-24 14:00:00	MSFT	Stock	258.66	259.71	257.03	257.675	1990303.0
2022-05-24 15:00:00	MSFT	Stock	257.63	261.33	257.49	260.0	4883411.0
2022-05-24 16:00:00	MSFT	Stock	259.78	260.9	257.4065	260.9	3114322.0
2022-05-24 17:00:00	MSFT	Stock	260.9007	261.25	260.9	260.98	14857.0
2022-05-24 18:00:00	MSFT	Stock	260.98	261.89	260.98	261.5001	11928.0
2022-05-24 19:00:00	MSFT	Stock	261.62	262.0	261.54	261.9	22447.0
2022-05-24 04:00:00	NVDA	Stock	16.3	16.64	16.3	16.58	209870.0
2022-05-24 05:00:00	NVDA	Stock	16.615	16.65	16.58	16.65	38540.0
2022-05-24 06:00:00	NVDA	Stock	16.632	16.678	16.601	16.672	94680.0
2022-05-24 07:00:00	NVDA	Stock	16.641	16.807	16.638	16.7	437220.0
2022-05-24 08:00:00	NVDA	Stock	16.674	16.8	16.6151	16.68	1145700.0
2022-05-24 09:00:00	NVDA	Stock	16.6702	16.68	15.916	15.9237	64445300.0
2022-05-24 10:00:00	NVDA	Stock	15.933	16.186	15.78	16.0335	95816840.0
2022-05-24 11:00:00	NVDA	Stock	16.031	16.244	15.956	16.172	56793880.0
2022-05-24 12:00:00	NVDA	Stock	16.17	16.449	16.12	16.2005	53397910.0
2022-05-24 13:00:00	NVDA	Stock	16.196	16.295	16.066	16.2236	48330650.0
2022-05-24 14:00:00	NVDA	Stock	16.231	16.3309	15.97	16.04	50738730.0
2022-05-24 15:00:00	NVDA	Stock	16.036	16.306	15.975	16.167	75937110.0
2022-05-24 16:00:00	NVDA	Stock	16.166	16.225	16.111	16.181	20716090.0
2022-05-24 17:00:00	NVDA	Stock	16.174	16.217	16.174	16.21	440840.0
2022-05-24 18:00:00	NVDA	Stock	16.215	16.326	16.211	16.28	601270.0
2022-05-24 19:00:00	NVDA	Stock	16.28	16.32	16.27	16.32	774840.0
2022-05-24 04:00:00	AMZN	Stock	105.2145	105.2145	105.2145	105.2145	2000.0
2022-05-24 06:00:00	AMZN	Stock	105.35	105.35	105.2445	105.2445	10620.0

> showing 50 of 62,323 rows — these rows as CSV

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