PREVIEW / stock_1hour / 2021-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-08.parquet
  size:    1.5 MB
  rows:    68,915
  symbols: 2,708

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-11-08 04:00:00	AAPL	Stock	151.08	151.35	151.08	151.12	18528.0
2021-11-08 05:00:00	AAPL	Stock	151.14	151.38	151.14	151.28	6748.0
2021-11-08 06:00:00	AAPL	Stock	151.32	151.58	151.3	151.57	15862.0
2021-11-08 07:00:00	AAPL	Stock	151.47	151.63	151.28	151.31	85208.0
2021-11-08 08:00:00	AAPL	Stock	151.44	151.61	150.902	151.23	172207.0
2021-11-08 09:00:00	AAPL	Stock	151.21	151.65	150.7	150.9542	6822544.0
2021-11-08 10:00:00	AAPL	Stock	150.96	151.45	150.72	150.7602	6120755.0
2021-11-08 11:00:00	AAPL	Stock	150.76	150.889	150.345	150.4102	4358937.0
2021-11-08 12:00:00	AAPL	Stock	150.41	150.61	150.16	150.59	3177772.0
2021-11-08 13:00:00	AAPL	Stock	150.585	151.01	150.53	150.5895	3006290.0
2021-11-08 14:00:00	AAPL	Stock	150.5819	150.8	150.51	150.665	2722246.0
2021-11-08 15:00:00	AAPL	Stock	150.665	150.665	150.31	150.45	5122863.0
2021-11-08 16:00:00	AAPL	Stock	150.45	150.46	150.33	150.4	5074933.0
2021-11-08 17:00:00	AAPL	Stock	150.38	150.44	150.32	150.33	47819.0
2021-11-08 18:00:00	AAPL	Stock	150.33	150.38	150.28	150.28	27141.0
2021-11-08 19:00:00	AAPL	Stock	150.27	150.3	149.75	149.85	121389.0
2021-11-08 04:00:00	MSFT	Stock	336.47	337.22	336.44	336.79	5415.0
2021-11-08 05:00:00	MSFT	Stock	336.95	337.29	336.95	337.29	4798.0
2021-11-08 06:00:00	MSFT	Stock	337.3	337.5	337.3	337.5	5068.0
2021-11-08 07:00:00	MSFT	Stock	337.33	337.33	336.62	337.1	18231.0
2021-11-08 08:00:00	MSFT	Stock	336.8	337.44	336.55	337.32	11146.0
2021-11-08 09:00:00	MSFT	Stock	337.16	337.65	335.3	335.85	1633660.0
2021-11-08 10:00:00	MSFT	Stock	335.84	335.99	334.68	335.34	2069203.0
2021-11-08 11:00:00	MSFT	Stock	335.34	335.52	334.69	334.91	1417495.0
2021-11-08 12:00:00	MSFT	Stock	334.91	335.35	334.44	335.23	1096777.0
2021-11-08 13:00:00	MSFT	Stock	335.25	336.52	335.1043	336.39	1220263.0
2021-11-08 14:00:00	MSFT	Stock	336.36	337.44	336.23	337.43	1120664.0
2021-11-08 15:00:00	MSFT	Stock	337.435	337.435	336.2384	336.93	1801373.0
2021-11-08 16:00:00	MSFT	Stock	336.99	337.15	336.7	336.91	4689315.0
2021-11-08 17:00:00	MSFT	Stock	336.95	337.05	336.9	336.9	5024.0
2021-11-08 18:00:00	MSFT	Stock	336.9	337.0	336.9	336.9	1337.0
2021-11-08 19:00:00	MSFT	Stock	336.9	336.9	336.36	336.36	8998.0
2021-11-08 04:00:00	NVDA	Stock	30.111	30.656	30.106	30.46	456610.0
2021-11-08 05:00:00	NVDA	Stock	30.451	30.49	30.352	30.434	118130.0
2021-11-08 06:00:00	NVDA	Stock	30.442	30.5	30.38	30.493	101480.0
2021-11-08 07:00:00	NVDA	Stock	30.485	30.486	30.172	30.2	1007240.0
2021-11-08 08:00:00	NVDA	Stock	30.3307	30.45	29.6777	30.14	2470770.0
2021-11-08 09:00:00	NVDA	Stock	30.14	30.8976	29.907	30.195	67307070.0
2021-11-08 10:00:00	NVDA	Stock	30.191	30.798	30.001	30.722	73357050.0
2021-11-08 11:00:00	NVDA	Stock	30.7255	31.1	30.55	30.786	67757960.0
2021-11-08 12:00:00	NVDA	Stock	30.7835	30.874	30.438	30.79	36989010.0
2021-11-08 13:00:00	NVDA	Stock	30.7965	31.05	30.733	30.89	33213030.0
2021-11-08 14:00:00	NVDA	Stock	30.8945	30.925	30.755	30.8415	22286840.0
2021-11-08 15:00:00	NVDA	Stock	30.841	30.852	30.566	30.804	33779960.0
2021-11-08 16:00:00	NVDA	Stock	30.804	31.01	30.786	31.005	19975110.0
2021-11-08 17:00:00	NVDA	Stock	31.01	31.01	30.901	30.98	475840.0
2021-11-08 18:00:00	NVDA	Stock	30.981	31.1	30.981	31.095	378560.0
2021-11-08 19:00:00	NVDA	Stock	31.088	31.099	30.955	31.026	544680.0
2021-11-08 07:00:00	AMZN	Stock	175.875	175.875	175.775	175.775	22240.0
2021-11-08 08:00:00	AMZN	Stock	175.9615	176.12	175.5097	176.048	77160.0

> showing 50 of 68,915 rows — these rows as CSV

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