PREVIEW / stock_1hour / 2023-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-13.parquet
  size:    1.4 MB
  rows:    61,741
  symbols: 1,924

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
2023-01-13 04:00:00	AAPL	Stock	133.43	133.6	133.06	133.37	20870.0
2023-01-13 05:00:00	AAPL	Stock	133.3	133.34	133.14	133.16	4451.0
2023-01-13 06:00:00	AAPL	Stock	133.06	133.12	132.6	132.78	15626.0
2023-01-13 07:00:00	AAPL	Stock	132.89	132.89	132.13	132.15	51330.0
2023-01-13 08:00:00	AAPL	Stock	132.8	133.41	131.82	132.02	460044.0
2023-01-13 09:00:00	AAPL	Stock	132.02	132.9328	131.66	132.565	7048803.0
2023-01-13 10:00:00	AAPL	Stock	132.54	133.97	132.4	133.75	8836239.0
2023-01-13 11:00:00	AAPL	Stock	133.75	133.96	132.755	133.2131	6097883.0
2023-01-13 12:00:00	AAPL	Stock	133.21	133.6	133.1301	133.539	3785505.0
2023-01-13 13:00:00	AAPL	Stock	133.54	134.38	133.3	134.1365	4895734.0
2023-01-13 14:00:00	AAPL	Stock	134.14	134.42	133.89	134.1309	4696623.0
2023-01-13 15:00:00	AAPL	Stock	134.14	134.92	134.07	134.7	8571162.0
2023-01-13 16:00:00	AAPL	Stock	134.7	134.78	134.42	134.52	6468996.0
2023-01-13 17:00:00	AAPL	Stock	134.59	134.63	134.52	134.59	19943.0
2023-01-13 18:00:00	AAPL	Stock	134.58	134.59	134.52	134.56	9663.0
2023-01-13 19:00:00	AAPL	Stock	134.53	134.6	134.5	134.55	31345.0
2023-01-13 04:00:00	MSFT	Stock	238.65	238.65	237.98	238.44	5179.0
2023-01-13 05:00:00	MSFT	Stock	238.89	239.0	238.76	238.76	1899.0
2023-01-13 06:00:00	MSFT	Stock	238.74	238.76	237.8	237.82	9951.0
2023-01-13 07:00:00	MSFT	Stock	237.95	238.1	236.95	236.95	21228.0
2023-01-13 08:00:00	MSFT	Stock	237.9	238.1	236.5401	236.5401	43685.0
2023-01-13 09:00:00	MSFT	Stock	236.65	237.5	234.92	236.56	1997420.0
2023-01-13 10:00:00	MSFT	Stock	236.53	237.57	236.18	236.65	2092006.0
2023-01-13 11:00:00	MSFT	Stock	236.61	236.75	234.98	235.595	1933907.0
2023-01-13 12:00:00	MSFT	Stock	235.5401	236.48	235.47	236.42	1083506.0
2023-01-13 13:00:00	MSFT	Stock	236.42	237.63	236.2001	237.59	1422787.0
2023-01-13 14:00:00	MSFT	Stock	237.6	238.47	237.34	238.13	1501263.0
2023-01-13 15:00:00	MSFT	Stock	238.15	239.37	238.02	239.11	3035439.0
2023-01-13 16:00:00	MSFT	Stock	239.13	239.54	238.82	239.3	3609194.0
2023-01-13 17:00:00	MSFT	Stock	239.26	239.28	239.0	239.24	6322.0
2023-01-13 18:00:00	MSFT	Stock	239.02	239.08	239.01	239.07	818.0
2023-01-13 19:00:00	MSFT	Stock	239.0	239.25	239.0	239.25	8867.0
2023-01-13 04:00:00	NVDA	Stock	16.4	16.443	16.38	16.443	51470.0
2023-01-13 05:00:00	NVDA	Stock	16.42	16.45	16.42	16.439	31370.0
2023-01-13 06:00:00	NVDA	Stock	16.43	16.43	16.335	16.335	33540.0
2023-01-13 07:00:00	NVDA	Stock	16.378	16.438	16.225	16.226	369070.0
2023-01-13 08:00:00	NVDA	Stock	16.35	16.512	16.17	16.185	1299650.0
2023-01-13 09:00:00	NVDA	Stock	16.199	16.602	16.161	16.472	59061120.0
2023-01-13 10:00:00	NVDA	Stock	16.465	16.817	16.44	16.767	71699610.0
2023-01-13 11:00:00	NVDA	Stock	16.766	16.785	16.493	16.566	52241830.0
2023-01-13 12:00:00	NVDA	Stock	16.565	16.714	16.551	16.662	35450560.0
2023-01-13 13:00:00	NVDA	Stock	16.6625	16.781	16.582	16.765	35652070.0
2023-01-13 14:00:00	NVDA	Stock	16.767	16.8677	16.7225	16.7845	41748790.0
2023-01-13 15:00:00	NVDA	Stock	16.785	16.922	16.7811	16.898	56657690.0
2023-01-13 16:00:00	NVDA	Stock	16.899	16.9187	16.885	16.91	24219170.0
2023-01-13 17:00:00	NVDA	Stock	16.898	16.9099	16.898	16.9	127030.0
2023-01-13 18:00:00	NVDA	Stock	16.9	16.908	16.899	16.904	69700.0
2023-01-13 19:00:00	NVDA	Stock	16.901	16.95	16.897	16.949	200120.0
2023-01-13 04:00:00	AMZN	Stock	95.27	95.48	95.07	95.26	14177.0
2023-01-13 05:00:00	AMZN	Stock	95.28	95.38	95.27	95.33	3672.0

> showing 50 of 61,741 rows — these rows as CSV

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