PREVIEW / stock_1hour / 2021-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-26.parquet
  size:    1.4 MB
  rows:    63,831
  symbols: 2,756

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-26 04:00:00	AAPL	Stock	148.0	148.13	147.92	148.11	2598.0
2021-08-26 05:00:00	AAPL	Stock	148.04	148.08	148.0	148.05	2614.0
2021-08-26 06:00:00	AAPL	Stock	148.07	148.15	148.05	148.1	3035.0
2021-08-26 07:00:00	AAPL	Stock	148.14	148.35	148.11	148.27	44235.0
2021-08-26 08:00:00	AAPL	Stock	148.3201	148.59	147.99	148.33	429730.0
2021-08-26 09:00:00	AAPL	Stock	148.33	149.12	148.2	148.31	7012604.0
2021-08-26 10:00:00	AAPL	Stock	148.3	148.73	147.72	148.03	8253598.0
2021-08-26 11:00:00	AAPL	Stock	148.02	148.35	147.595	148.14	5450646.0
2021-08-26 12:00:00	AAPL	Stock	148.135	148.65	148.13	148.33	4325108.0
2021-08-26 13:00:00	AAPL	Stock	148.335	148.35	147.9799	148.085	3068599.0
2021-08-26 14:00:00	AAPL	Stock	148.09	148.09	147.71	147.74	3776385.0
2021-08-26 15:00:00	AAPL	Stock	147.74	147.9579	147.51	147.55	7300223.0
2021-08-26 16:00:00	AAPL	Stock	147.54	147.72	147.51	147.58	3325100.0
2021-08-26 17:00:00	AAPL	Stock	147.58	147.6499	147.56	147.6	23659.0
2021-08-26 18:00:00	AAPL	Stock	147.59	147.66	147.54	147.55	26378.0
2021-08-26 19:00:00	AAPL	Stock	147.55	147.58	147.52	147.58	21851.0
2021-08-26 04:00:00	MSFT	Stock	301.52	301.54	301.52	301.54	499.0
2021-08-26 05:00:00	MSFT	Stock	301.68	301.7	301.54	301.54	481.0
2021-08-26 07:00:00	MSFT	Stock	301.67	302.15	301.65	301.8	7854.0
2021-08-26 08:00:00	MSFT	Stock	301.7	302.3194	300.65	301.0	30997.0
2021-08-26 09:00:00	MSFT	Stock	301.08	302.429	300.68	301.12	1511563.0
2021-08-26 10:00:00	MSFT	Stock	301.09	301.93	299.63	300.24	2995013.0
2021-08-26 11:00:00	MSFT	Stock	300.15	301.05	299.63	300.425	1645162.0
2021-08-26 12:00:00	MSFT	Stock	300.48	301.03	300.44	300.8211	852407.0
2021-08-26 13:00:00	MSFT	Stock	300.8	301.11	300.6	300.65	762932.0
2021-08-26 14:00:00	MSFT	Stock	300.64	300.71	300.24	300.3655	1021408.0
2021-08-26 15:00:00	MSFT	Stock	300.35	300.35	298.95	299.06	2468597.0
2021-08-26 16:00:00	MSFT	Stock	299.09	299.27	298.9	299.24	1888576.0
2021-08-26 17:00:00	MSFT	Stock	299.25	299.29	299.0	299.29	11041.0
2021-08-26 18:00:00	MSFT	Stock	299.18	299.36	299.11	299.35	4643.0
2021-08-26 19:00:00	MSFT	Stock	299.35	299.35	298.55	298.55	21802.0
2021-08-26 04:00:00	NVDA	Stock	22.1	22.11	22.056	22.089	26260.0
2021-08-26 05:00:00	NVDA	Stock	22.077	22.135	22.062	22.12	15120.0
2021-08-26 06:00:00	NVDA	Stock	22.148	22.16	22.12	22.139	23550.0
2021-08-26 07:00:00	NVDA	Stock	22.131	22.2	22.13	22.18	116900.0
2021-08-26 08:00:00	NVDA	Stock	22.185	22.266	22.1266	22.19	779470.0
2021-08-26 09:00:00	NVDA	Stock	22.215	22.34	22.061	22.212	30775270.0
2021-08-26 10:00:00	NVDA	Stock	22.204	22.31	21.907	21.969	39330340.0
2021-08-26 11:00:00	NVDA	Stock	21.972	22.13	21.79	22.1137	38157210.0
2021-08-26 12:00:00	NVDA	Stock	22.119	22.195	22.082	22.099	17563420.0
2021-08-26 13:00:00	NVDA	Stock	22.105	22.131	22.033	22.078	11611450.0
2021-08-26 14:00:00	NVDA	Stock	22.078	22.177	22.0225	22.058	17818330.0
2021-08-26 15:00:00	NVDA	Stock	22.057	22.141	22.01	22.068	20976850.0
2021-08-26 16:00:00	NVDA	Stock	22.068	22.128	21.91	21.944	15800800.0
2021-08-26 17:00:00	NVDA	Stock	21.955	21.974	21.935	21.974	132580.0
2021-08-26 18:00:00	NVDA	Stock	21.96	21.999	21.94	21.95	130920.0
2021-08-26 19:00:00	NVDA	Stock	21.94	21.968	21.925	21.955	370650.0
2021-08-26 07:00:00	AMZN	Stock	164.85	164.85	164.85	164.85	3460.0
2021-08-26 08:00:00	AMZN	Stock	164.65	165.3714	164.65	164.85	32100.0
2021-08-26 09:00:00	AMZN	Stock	164.75	165.6	164.75	165.1425	2848800.0

> showing 50 of 63,831 rows — these rows as CSV

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