PREVIEW / stock_1hour / 2021-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-15.parquet
  size:    1.5 MB
  rows:    68,327
  symbols: 2,697

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-15 04:00:00	AAPL	Stock	150.0	150.37	149.76	150.1	17779.0
2021-11-15 05:00:00	AAPL	Stock	150.15	150.24	150.1	150.11	5198.0
2021-11-15 06:00:00	AAPL	Stock	150.11	150.16	150.06	150.16	22053.0
2021-11-15 07:00:00	AAPL	Stock	150.2	150.5	150.14	150.42	60434.0
2021-11-15 08:00:00	AAPL	Stock	150.1801	151.13	149.616	150.81	301237.0
2021-11-15 09:00:00	AAPL	Stock	150.81	151.88	150.15	150.955	8566705.0
2021-11-15 10:00:00	AAPL	Stock	150.96	151.01	150.25	150.33	6771771.0
2021-11-15 11:00:00	AAPL	Stock	150.32	150.53	149.43	149.7799	5546666.0
2021-11-15 12:00:00	AAPL	Stock	149.77	150.2361	149.54	150.04	3547273.0
2021-11-15 13:00:00	AAPL	Stock	150.04	150.14	149.89	149.915	2710543.0
2021-11-15 14:00:00	AAPL	Stock	149.92	150.205	149.76	149.995	2813504.0
2021-11-15 15:00:00	AAPL	Stock	149.99	150.26	149.75	150.0	6845560.0
2021-11-15 16:00:00	AAPL	Stock	150.0	150.1	149.89	149.96	8732023.0
2021-11-15 17:00:00	AAPL	Stock	149.98	149.99	149.95	149.97	17910.0
2021-11-15 18:00:00	AAPL	Stock	149.99	150.0	149.97	149.99	49825.0
2021-11-15 19:00:00	AAPL	Stock	149.99	150.01	149.9	150.01	89462.0
2021-11-15 04:00:00	MSFT	Stock	337.7	338.95	337.7	338.85	10958.0
2021-11-15 05:00:00	MSFT	Stock	338.86	339.6	338.86	339.21	7346.0
2021-11-15 06:00:00	MSFT	Stock	339.08	339.2	338.78	338.78	1680.0
2021-11-15 07:00:00	MSFT	Stock	338.75	339.05	338.57	338.8	15863.0
2021-11-15 08:00:00	MSFT	Stock	339.01	339.736	337.561	339.2	48783.0
2021-11-15 09:00:00	MSFT	Stock	339.1203	339.2	335.56	336.335	2236441.0
2021-11-15 10:00:00	MSFT	Stock	336.39	336.39	334.62	335.3	1965832.0
2021-11-15 11:00:00	MSFT	Stock	335.31	335.82	334.225	334.98	1261783.0
2021-11-15 12:00:00	MSFT	Stock	335.0	335.31	334.034	334.84	908204.0
2021-11-15 13:00:00	MSFT	Stock	334.8299	335.69	334.57	335.015	847516.0
2021-11-15 14:00:00	MSFT	Stock	335.01	335.52	334.48	335.4577	735229.0
2021-11-15 15:00:00	MSFT	Stock	335.42	336.32	335.3	336.08	1542657.0
2021-11-15 16:00:00	MSFT	Stock	336.07	336.37	335.82	336.3	2548793.0
2021-11-15 17:00:00	MSFT	Stock	336.31	336.39	336.3	336.3	5995.0
2021-11-15 18:00:00	MSFT	Stock	336.31	336.39	336.16	336.2	2921.0
2021-11-15 19:00:00	MSFT	Stock	336.36	336.56	336.16	336.55	10023.0
2021-11-15 04:00:00	NVDA	Stock	30.29	30.389	30.201	30.35	179390.0
2021-11-15 05:00:00	NVDA	Stock	30.36	30.48	30.354	30.464	185600.0
2021-11-15 06:00:00	NVDA	Stock	30.49	30.638	30.481	30.565	209880.0
2021-11-15 07:00:00	NVDA	Stock	30.568	30.583	30.178	30.433	870490.0
2021-11-15 08:00:00	NVDA	Stock	30.433	30.637	30.15	30.585	1205980.0
2021-11-15 09:00:00	NVDA	Stock	30.585	30.694	29.986	30.0866	44972180.0
2021-11-15 10:00:00	NVDA	Stock	30.1	30.236	29.8024	29.901	42786550.0
2021-11-15 11:00:00	NVDA	Stock	29.904	29.98	29.52	29.6066	33808030.0
2021-11-15 12:00:00	NVDA	Stock	29.6045	29.666	29.247	29.5309	42907110.0
2021-11-15 13:00:00	NVDA	Stock	29.528	29.773	29.49	29.616	33066040.0
2021-11-15 14:00:00	NVDA	Stock	29.616	29.986	29.598	29.924	29449100.0
2021-11-15 15:00:00	NVDA	Stock	29.922	30.045	29.88	30.024	28747940.0
2021-11-15 16:00:00	NVDA	Stock	30.025	30.047	29.97	29.985	16667780.0
2021-11-15 17:00:00	NVDA	Stock	29.985	29.989	29.97	29.985	115740.0
2021-11-15 18:00:00	NVDA	Stock	29.985	30.065	29.81	29.81	356670.0
2021-11-15 19:00:00	NVDA	Stock	29.839	29.87	29.786	29.83	389980.0
2021-11-15 05:00:00	AMZN	Stock	176.55	176.55	176.55	176.55	2000.0
2021-11-15 07:00:00	AMZN	Stock	176.725	176.725	176.65	176.725	16180.0

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

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