PREVIEW / stock_1hour / 2021-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-07.parquet
  size:    1.4 MB
  rows:    65,770
  symbols: 2,729

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-09-07 04:00:00	AAPL	Stock	154.6	154.77	154.27	154.69	41055.0
2021-09-07 05:00:00	AAPL	Stock	154.66	154.71	154.21	154.21	25751.0
2021-09-07 06:00:00	AAPL	Stock	154.41	154.58	154.19	154.31	17160.0
2021-09-07 07:00:00	AAPL	Stock	154.29	154.77	154.25	154.68	161064.0
2021-09-07 08:00:00	AAPL	Stock	154.6	155.2	153.915	154.95	632452.0
2021-09-07 09:00:00	AAPL	Stock	154.95	155.72	154.39	155.715	12492023.0
2021-09-07 10:00:00	AAPL	Stock	155.695	156.24	155.31	156.03	12973776.0
2021-09-07 11:00:00	AAPL	Stock	156.02	156.075	155.25	155.82	7557574.0
2021-09-07 12:00:00	AAPL	Stock	155.81	157.26	155.7301	157.095	12321885.0
2021-09-07 13:00:00	AAPL	Stock	157.0999	157.1299	156.75	156.8369	5381170.0
2021-09-07 14:00:00	AAPL	Stock	156.84	157.1	156.56	156.905	6749962.0
2021-09-07 15:00:00	AAPL	Stock	156.9099	157.08	156.65	156.7	9610345.0
2021-09-07 16:00:00	AAPL	Stock	156.69	156.75	156.3	156.65	5723892.0
2021-09-07 17:00:00	AAPL	Stock	156.69	156.69	156.5	156.63	144633.0
2021-09-07 18:00:00	AAPL	Stock	156.66	156.78	156.6	156.78	60834.0
2021-09-07 19:00:00	AAPL	Stock	156.78	156.91	156.74	156.76	64060.0
2021-09-07 04:00:00	MSFT	Stock	301.4	302.29	301.3	301.47	14294.0
2021-09-07 05:00:00	MSFT	Stock	301.51	301.65	300.05	300.56	6231.0
2021-09-07 06:00:00	MSFT	Stock	300.62	300.85	300.59	300.66	7725.0
2021-09-07 07:00:00	MSFT	Stock	300.67	300.81	300.35	300.65	13731.0
2021-09-07 08:00:00	MSFT	Stock	300.6545	301.0	300.35	300.51	27560.0
2021-09-07 09:00:00	MSFT	Stock	300.7	301.49	298.33	299.34	2402200.0
2021-09-07 10:00:00	MSFT	Stock	299.32	300.4	298.2	300.27	2062395.0
2021-09-07 11:00:00	MSFT	Stock	300.26	300.62	299.58	300.4	1187539.0
2021-09-07 12:00:00	MSFT	Stock	300.3741	300.69	300.215	300.435	1003239.0
2021-09-07 13:00:00	MSFT	Stock	300.43	300.9099	300.2	300.36	974010.0
2021-09-07 14:00:00	MSFT	Stock	300.356	300.38	299.83	300.1342	913272.0
2021-09-07 15:00:00	MSFT	Stock	300.135	300.35	299.66	300.1747	1708174.0
2021-09-07 16:00:00	MSFT	Stock	300.18	300.25	300.04	300.2	1980767.0
2021-09-07 17:00:00	MSFT	Stock	300.1	300.2	300.1	300.15	52309.0
2021-09-07 18:00:00	MSFT	Stock	300.2999	300.2999	300.29	300.29	457.0
2021-09-07 19:00:00	MSFT	Stock	300.17	300.28	300.15	300.15	1341.0
2021-09-07 04:00:00	NVDA	Stock	22.91	22.961	22.898	22.925	79160.0
2021-09-07 05:00:00	NVDA	Stock	22.925	22.93	22.832	22.865	139520.0
2021-09-07 06:00:00	NVDA	Stock	22.884	22.884	22.801	22.804	54590.0
2021-09-07 07:00:00	NVDA	Stock	22.841	22.876	22.793	22.805	280980.0
2021-09-07 08:00:00	NVDA	Stock	22.875	22.924	22.8	22.875	707770.0
2021-09-07 09:00:00	NVDA	Stock	22.874	22.9	22.5224	22.633	31607980.0
2021-09-07 10:00:00	NVDA	Stock	22.629	22.789	22.525	22.78	34349360.0
2021-09-07 11:00:00	NVDA	Stock	22.782	22.7893	22.561	22.654	18656670.0
2021-09-07 12:00:00	NVDA	Stock	22.65	22.69	22.598	22.651	13029280.0
2021-09-07 13:00:00	NVDA	Stock	22.652	22.737	22.6	22.69	12835760.0
2021-09-07 14:00:00	NVDA	Stock	22.689	22.744	22.6647	22.7385	9259550.0
2021-09-07 15:00:00	NVDA	Stock	22.737	22.751	22.65	22.658	15496460.0
2021-09-07 16:00:00	NVDA	Stock	22.662	22.69	22.601	22.608	8235190.0
2021-09-07 17:00:00	NVDA	Stock	22.621	22.662	22.6	22.616	276820.0
2021-09-07 18:00:00	NVDA	Stock	22.62	22.627	22.566	22.566	145360.0
2021-09-07 19:00:00	NVDA	Stock	22.575	22.59	22.526	22.571	355060.0
2021-09-07 05:00:00	AMZN	Stock	174.0	174.0	174.0	174.0	5780.0
2021-09-07 07:00:00	AMZN	Stock	173.65	173.7	173.65	173.683	12500.0

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

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