PREVIEW / stock_1hour / 2021-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-27.parquet
  size:    1.5 MB
  rows:    66,194
  symbols: 2,705

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-10-27 04:00:00	AAPL	Stock	149.47	149.72	149.33	149.33	11304.0
2021-10-27 05:00:00	AAPL	Stock	149.3	149.44	148.98	149.12	12830.0
2021-10-27 06:00:00	AAPL	Stock	149.11	149.18	148.82	149.07	11989.0
2021-10-27 07:00:00	AAPL	Stock	149.08	149.28	148.8	148.85	119637.0
2021-10-27 08:00:00	AAPL	Stock	149.12	149.42	148.8	149.4	250569.0
2021-10-27 09:00:00	AAPL	Stock	149.4	149.69	148.49	149.39	7551921.0
2021-10-27 10:00:00	AAPL	Stock	149.39	149.41	148.49	148.795	7210413.0
2021-10-27 11:00:00	AAPL	Stock	148.8	149.5116	148.7	149.18	5036563.0
2021-10-27 12:00:00	AAPL	Stock	149.1801	149.51	149.15	149.43	3537404.0
2021-10-27 13:00:00	AAPL	Stock	149.43	149.72	149.395	149.585	3904436.0
2021-10-27 14:00:00	AAPL	Stock	149.5875	149.73	149.45	149.47	3936685.0
2021-10-27 15:00:00	AAPL	Stock	149.47	149.55	148.8	148.85	7581288.0
2021-10-27 16:00:00	AAPL	Stock	148.85	149.1295	148.8	148.92	9397052.0
2021-10-27 17:00:00	AAPL	Stock	148.97	149.11	148.89	149.08	47576.0
2021-10-27 18:00:00	AAPL	Stock	149.09	149.17	149.07	149.14	58348.0
2021-10-27 19:00:00	AAPL	Stock	149.17	149.17	149.0	149.07	94650.0
2021-10-27 04:00:00	MSFT	Stock	316.0	319.06	316.0	317.3	19536.0
2021-10-27 05:00:00	MSFT	Stock	317.3	317.49	316.5	317.05	10879.0
2021-10-27 06:00:00	MSFT	Stock	316.9	316.9	315.64	315.85	8690.0
2021-10-27 07:00:00	MSFT	Stock	316.1	316.28	314.1	314.11	48517.0
2021-10-27 08:00:00	MSFT	Stock	315.5299	316.21	314.1	315.58	162786.0
2021-10-27 09:00:00	MSFT	Stock	315.58	319.905	315.31	319.67	6513546.0
2021-10-27 10:00:00	MSFT	Stock	319.7	324.8	318.91	323.3935	8797114.0
2021-10-27 11:00:00	MSFT	Stock	323.3821	324.23	321.92	322.38	4463282.0
2021-10-27 12:00:00	MSFT	Stock	322.4	325.4	322.19	324.16	4460211.0
2021-10-27 13:00:00	MSFT	Stock	324.18	326.0973	324.16	325.5601	2815843.0
2021-10-27 14:00:00	MSFT	Stock	325.565	325.83	324.82	324.87	2847623.0
2021-10-27 15:00:00	MSFT	Stock	324.85	325.22	323.14	323.26	5769294.0
2021-10-27 16:00:00	MSFT	Stock	323.18	324.39	323.01	323.15	6021834.0
2021-10-27 17:00:00	MSFT	Stock	323.2	323.48	323.15	323.4701	16367.0
2021-10-27 18:00:00	MSFT	Stock	323.46	323.87	323.3	323.56	14934.0
2021-10-27 19:00:00	MSFT	Stock	323.53	324.0	323.35	323.78	19044.0
2021-10-27 04:00:00	NVDA	Stock	24.591	24.639	24.506	24.506	71830.0
2021-10-27 05:00:00	NVDA	Stock	24.5	24.501	24.416	24.461	53460.0
2021-10-27 06:00:00	NVDA	Stock	24.47	24.536	24.465	24.465	22810.0
2021-10-27 07:00:00	NVDA	Stock	24.493	24.59	24.462	24.51	278940.0
2021-10-27 08:00:00	NVDA	Stock	24.5792	24.717	24.46	24.6101	754820.0
2021-10-27 09:00:00	NVDA	Stock	24.629	24.962	24.282	24.616	37863910.0
2021-10-27 10:00:00	NVDA	Stock	24.621	24.934	24.412	24.8705	35442320.0
2021-10-27 11:00:00	NVDA	Stock	24.871	25.09	24.702	24.885	37893830.0
2021-10-27 12:00:00	NVDA	Stock	24.887	24.949	24.742	24.7685	15807260.0
2021-10-27 13:00:00	NVDA	Stock	24.769	24.918	24.76	24.8383	10022910.0
2021-10-27 14:00:00	NVDA	Stock	24.837	24.841	24.668	24.677	8929430.0
2021-10-27 15:00:00	NVDA	Stock	24.675	24.7019	24.429	24.451	28630510.0
2021-10-27 16:00:00	NVDA	Stock	24.44	24.56	24.425	24.465	11984970.0
2021-10-27 17:00:00	NVDA	Stock	24.465	24.465	24.4	24.418	96950.0
2021-10-27 18:00:00	NVDA	Stock	24.405	24.508	24.4	24.502	155570.0
2021-10-27 19:00:00	NVDA	Stock	24.51	24.54	24.5	24.5	214260.0
2021-10-27 04:00:00	AMZN	Stock	169.4	169.4	169.4	169.4	2000.0
2021-10-27 07:00:00	AMZN	Stock	168.61	168.85	168.444	168.444	55780.0

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

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