PREVIEW / stock_1hour / 2021-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-23.parquet
  size:    1.4 MB
  rows:    65,925
  symbols: 2,835

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-08-23 04:00:00	AAPL	Stock	148.56	148.85	148.2	148.83	14523.0
2021-08-23 05:00:00	AAPL	Stock	148.85	148.85	148.44	148.52	11442.0
2021-08-23 06:00:00	AAPL	Stock	148.52	148.54	148.35	148.54	11649.0
2021-08-23 07:00:00	AAPL	Stock	148.53	148.79	148.44	148.65	136926.0
2021-08-23 08:00:00	AAPL	Stock	148.69	148.79	147.82	148.47	240060.0
2021-08-23 09:00:00	AAPL	Stock	148.52	148.82	147.89	148.6357	8284948.0
2021-08-23 10:00:00	AAPL	Stock	148.65	149.77	148.49	149.47	9363199.0
2021-08-23 11:00:00	AAPL	Stock	149.48	149.94	149.411	149.8895	5833728.0
2021-08-23 12:00:00	AAPL	Stock	149.885	149.97	149.592	149.8266	4991844.0
2021-08-23 13:00:00	AAPL	Stock	149.83	150.15	149.6345	149.905	5834887.0
2021-08-23 14:00:00	AAPL	Stock	149.91	150.19	149.86	150.0291	4063111.0
2021-08-23 15:00:00	AAPL	Stock	150.03	150.1	149.5788	149.7	6956637.0
2021-08-23 16:00:00	AAPL	Stock	149.71	149.75	149.6	149.66	5777276.0
2021-08-23 17:00:00	AAPL	Stock	149.7	149.72	149.66	149.71	32745.0
2021-08-23 18:00:00	AAPL	Stock	149.71	149.75	149.7	149.75	33005.0
2021-08-23 19:00:00	AAPL	Stock	149.73	149.77	149.5	149.73	57040.0
2021-08-23 04:00:00	MSFT	Stock	304.6	306.09	304.6	305.75	6943.0
2021-08-23 05:00:00	MSFT	Stock	305.75	305.75	305.21	305.25	4735.0
2021-08-23 06:00:00	MSFT	Stock	305.2	305.2	304.69	305.0	11503.0
2021-08-23 07:00:00	MSFT	Stock	304.76	305.4	303.9	304.16	61806.0
2021-08-23 08:00:00	MSFT	Stock	305.0	305.41	303.62	303.8	61577.0
2021-08-23 09:00:00	MSFT	Stock	303.7	305.4	301.85	304.01	3147476.0
2021-08-23 10:00:00	MSFT	Stock	303.99	305.14	303.35	304.25	3264970.0
2021-08-23 11:00:00	MSFT	Stock	304.25	304.4675	303.98	304.185	1666926.0
2021-08-23 12:00:00	MSFT	Stock	304.18	304.29	303.55	304.0958	1387256.0
2021-08-23 13:00:00	MSFT	Stock	304.11	304.485	303.62	304.28	1241644.0
2021-08-23 14:00:00	MSFT	Stock	304.285	304.99	304.1	304.88	1457882.0
2021-08-23 15:00:00	MSFT	Stock	304.88	305.16	304.34	304.58	2195664.0
2021-08-23 16:00:00	MSFT	Stock	304.65	304.78	304.5	304.64	2665408.0
2021-08-23 17:00:00	MSFT	Stock	304.65	304.6999	304.61	304.69	1719.0
2021-08-23 18:00:00	MSFT	Stock	304.67	304.7	304.52	304.66	5407.0
2021-08-23 19:00:00	MSFT	Stock	304.66	304.74	304.58	304.7	10720.0
2021-08-23 04:00:00	NVDA	Stock	20.94	20.98	20.757	20.98	348520.0
2021-08-23 05:00:00	NVDA	Stock	20.985	21.031	20.955	21.0	224050.0
2021-08-23 06:00:00	NVDA	Stock	21.001	21.001	20.93	20.949	76510.0
2021-08-23 07:00:00	NVDA	Stock	20.935	21.17	20.933	21.12	1633210.0
2021-08-23 08:00:00	NVDA	Stock	21.0292	21.167	20.949	21.072	1528010.0
2021-08-23 09:00:00	NVDA	Stock	21.085	21.541	20.94	21.467	92425230.0
2021-08-23 10:00:00	NVDA	Stock	21.469	21.698	21.402	21.687	84189080.0
2021-08-23 11:00:00	NVDA	Stock	21.684	21.78	21.5751	21.734	60849560.0
2021-08-23 12:00:00	NVDA	Stock	21.736	21.888	21.715	21.821	46631740.0
2021-08-23 13:00:00	NVDA	Stock	21.8205	21.864	21.747	21.767	27356000.0
2021-08-23 14:00:00	NVDA	Stock	21.768	21.97	21.755	21.9579	44144250.0
2021-08-23 15:00:00	NVDA	Stock	21.958	21.997	21.847	21.9567	72296920.0
2021-08-23 16:00:00	NVDA	Stock	21.948	21.969	21.925	21.959	23976580.0
2021-08-23 17:00:00	NVDA	Stock	21.96	21.965	21.94	21.944	308600.0
2021-08-23 18:00:00	NVDA	Stock	21.944	21.96	21.943	21.95	1033020.0
2021-08-23 19:00:00	NVDA	Stock	21.947	21.95	21.9	21.925	467370.0
2021-08-23 04:00:00	AMZN	Stock	160.414	160.414	160.414	160.414	2040.0
2021-08-23 05:00:00	AMZN	Stock	160.875	160.875	160.875	160.875	2000.0

> showing 50 of 65,925 rows — these rows as CSV

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