PREVIEW / stock_1hour / 2022-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-26.parquet
  size:    1.4 MB
  rows:    61,736
  symbols: 2,236

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
2022-08-26 04:00:00	AAPL	Stock	170.0	170.0	169.4	169.57	17665.0
2022-08-26 05:00:00	AAPL	Stock	169.51	169.51	169.24	169.24	11760.0
2022-08-26 06:00:00	AAPL	Stock	169.36	169.53	169.36	169.47	5420.0
2022-08-26 07:00:00	AAPL	Stock	169.54	169.99	169.33	169.86	59297.0
2022-08-26 08:00:00	AAPL	Stock	169.51	170.47	169.35	170.4532	287122.0
2022-08-26 09:00:00	AAPL	Stock	170.39	171.13	169.745	170.2924	5363004.0
2022-08-26 10:00:00	AAPL	Stock	170.3	171.05	167.31	167.6	10380095.0
2022-08-26 11:00:00	AAPL	Stock	167.58	167.6635	166.3718	166.8427	6625845.0
2022-08-26 12:00:00	AAPL	Stock	166.85	166.86	165.78	166.31	4898657.0
2022-08-26 13:00:00	AAPL	Stock	166.3	166.55	164.73	164.915	7777559.0
2022-08-26 14:00:00	AAPL	Stock	164.91	165.0599	164.51	164.68	4848194.0
2022-08-26 15:00:00	AAPL	Stock	164.68	164.96	163.56	163.66	13066055.0
2022-08-26 16:00:00	AAPL	Stock	163.65	163.71	162.65	162.73	13211164.0
2022-08-26 17:00:00	AAPL	Stock	162.74	163.62	162.56	162.59	185253.0
2022-08-26 18:00:00	AAPL	Stock	162.59	162.66	162.45	162.45	43648.0
2022-08-26 19:00:00	AAPL	Stock	162.45	162.52	162.3	162.47	68064.0
2022-08-26 04:00:00	MSFT	Stock	278.23	278.23	277.4	277.7	1053.0
2022-08-26 05:00:00	MSFT	Stock	277.7	277.7	277.2	277.26	1323.0
2022-08-26 06:00:00	MSFT	Stock	277.0	277.5	277.0	277.38	2551.0
2022-08-26 07:00:00	MSFT	Stock	277.75	277.78	277.23	277.78	14990.0
2022-08-26 08:00:00	MSFT	Stock	277.5505	279.2	277.2	279.2	32861.0
2022-08-26 09:00:00	MSFT	Stock	279.3	280.7	278.37	279.61	962012.0
2022-08-26 10:00:00	MSFT	Stock	279.61	280.34	273.72	274.13	2588878.0
2022-08-26 11:00:00	MSFT	Stock	274.07	274.26	271.52	272.33	1659793.0
2022-08-26 12:00:00	MSFT	Stock	272.35	272.77	271.15	272.71	911284.0
2022-08-26 13:00:00	MSFT	Stock	272.7	273.11	271.53	271.64	858598.0
2022-08-26 14:00:00	MSFT	Stock	271.65	271.78	270.28	270.42	995340.0
2022-08-26 15:00:00	MSFT	Stock	270.41	270.62	267.98	268.17	4015500.0
2022-08-26 16:00:00	MSFT	Stock	268.19	268.19	267.25	267.35	7174650.0
2022-08-26 17:00:00	MSFT	Stock	267.35	267.76	267.21	267.29	9249.0
2022-08-26 18:00:00	MSFT	Stock	267.2	267.3	267.15	267.18	1716.0
2022-08-26 19:00:00	MSFT	Stock	267.18	267.2	267.05	267.17	4488.0
2022-08-26 04:00:00	NVDA	Stock	17.884	17.884	17.72	17.8	244040.0
2022-08-26 05:00:00	NVDA	Stock	17.765	17.775	17.751	17.761	210080.0
2022-08-26 06:00:00	NVDA	Stock	17.771	17.78	17.768	17.78	11880.0
2022-08-26 07:00:00	NVDA	Stock	17.78	17.889	17.78	17.87	421640.0
2022-08-26 08:00:00	NVDA	Stock	17.78	17.951	17.753	17.941	1847660.0
2022-08-26 09:00:00	NVDA	Stock	17.935	18.0488	17.501	17.6995	70961250.0
2022-08-26 10:00:00	NVDA	Stock	17.695	17.924	17.012	17.063	144439890.0
2022-08-26 11:00:00	NVDA	Stock	17.057	17.07	16.792	16.8172	89472920.0
2022-08-26 12:00:00	NVDA	Stock	16.816	16.819	16.604	16.6712	68103430.0
2022-08-26 13:00:00	NVDA	Stock	16.669	16.697	16.486	16.522	55348800.0
2022-08-26 14:00:00	NVDA	Stock	16.522	16.549	16.402	16.4691	53481720.0
2022-08-26 15:00:00	NVDA	Stock	16.469	16.531	16.237	16.2515	98257300.0
2022-08-26 16:00:00	NVDA	Stock	16.252	16.27	16.214	16.235	40910420.0
2022-08-26 17:00:00	NVDA	Stock	16.235	16.26	16.225	16.239	551680.0
2022-08-26 18:00:00	NVDA	Stock	16.239	16.239	16.209	16.211	226590.0
2022-08-26 19:00:00	NVDA	Stock	16.205	16.234	16.191	16.2	325810.0
2022-08-26 04:00:00	AMZN	Stock	137.2	137.2	136.61	136.61	5808.0
2022-08-26 05:00:00	AMZN	Stock	136.62	136.66	136.44	136.44	4535.0

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

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