PREVIEW / stock_1hour / 2021-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-23.parquet
  size:    1.5 MB
  rows:    66,756
  symbols: 2,704

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-11-23 04:00:00	AAPL	Stock	159.99	160.68	159.51	160.66	73827.0
2021-11-23 05:00:00	AAPL	Stock	160.79	160.79	160.45	160.6	16896.0
2021-11-23 06:00:00	AAPL	Stock	160.52	161.12	160.2	160.85	37886.0
2021-11-23 07:00:00	AAPL	Stock	160.86	161.36	160.66	160.7	177149.0
2021-11-23 08:00:00	AAPL	Stock	161.273	161.7099	160.65	161.3	600082.0
2021-11-23 09:00:00	AAPL	Stock	161.26	161.8	159.62	160.735	10963107.0
2021-11-23 10:00:00	AAPL	Stock	160.74	160.86	159.0601	159.96	14469613.0
2021-11-23 11:00:00	AAPL	Stock	159.9544	160.49	159.23	159.82	9856278.0
2021-11-23 12:00:00	AAPL	Stock	159.82	160.61	159.43	159.781	8431425.0
2021-11-23 13:00:00	AAPL	Stock	159.78	160.11	159.08	160.015	7630957.0
2021-11-23 14:00:00	AAPL	Stock	160.02	160.9	159.82	160.88	7504979.0
2021-11-23 15:00:00	AAPL	Stock	160.89	161.69	160.535	161.41	12512892.0
2021-11-23 16:00:00	AAPL	Stock	161.42	161.76	161.27	161.36	6884116.0
2021-11-23 17:00:00	AAPL	Stock	161.36	161.45	161.22	161.31	67135.0
2021-11-23 18:00:00	AAPL	Stock	161.3	161.47	161.3	161.31	43103.0
2021-11-23 19:00:00	AAPL	Stock	161.32	161.44	161.0	161.25	68767.0
2021-11-23 04:00:00	MSFT	Stock	338.48	338.6	337.46	338.6	10080.0
2021-11-23 05:00:00	MSFT	Stock	338.95	339.01	338.61	338.61	7525.0
2021-11-23 06:00:00	MSFT	Stock	338.02	338.65	338.0	338.46	2744.0
2021-11-23 07:00:00	MSFT	Stock	338.57	339.29	337.98	338.41	22855.0
2021-11-23 08:00:00	MSFT	Stock	338.5	339.0927	337.9626	338.0	36993.0
2021-11-23 09:00:00	MSFT	Stock	338.01	339.45	334.31	339.06	3203791.0
2021-11-23 10:00:00	MSFT	Stock	339.07	339.11	333.56	334.44	3637078.0
2021-11-23 11:00:00	MSFT	Stock	334.43	336.4	333.93	335.55	2081675.0
2021-11-23 12:00:00	MSFT	Stock	335.55	335.68	334.2	334.54	1280370.0
2021-11-23 13:00:00	MSFT	Stock	334.54	336.28	334.27	335.6718	1159944.0
2021-11-23 14:00:00	MSFT	Stock	335.68	336.68	334.61	336.3	1240881.0
2021-11-23 15:00:00	MSFT	Stock	336.27	337.93	335.89	337.75	2559802.0
2021-11-23 16:00:00	MSFT	Stock	337.68	337.84	336.73	337.1	3490542.0
2021-11-23 17:00:00	MSFT	Stock	337.16	337.45	337.15	337.3	2677.0
2021-11-23 18:00:00	MSFT	Stock	337.4	337.58	337.22	337.35	3639.0
2021-11-23 19:00:00	MSFT	Stock	337.4	337.89	337.4	337.7	7290.0
2021-11-23 04:00:00	NVDA	Stock	31.568	31.568	31.081	31.439	573480.0
2021-11-23 05:00:00	NVDA	Stock	31.422	31.593	31.39	31.424	220300.0
2021-11-23 06:00:00	NVDA	Stock	31.45	31.687	31.325	31.65	200660.0
2021-11-23 07:00:00	NVDA	Stock	31.668	31.95	31.615	31.759	1168190.0
2021-11-23 08:00:00	NVDA	Stock	31.7145	32.199	31.7	32.0	2889710.0
2021-11-23 09:00:00	NVDA	Stock	32.025	32.36	31.099	32.1961	73942590.0
2021-11-23 10:00:00	NVDA	Stock	32.203	32.247	31.013	31.059	83696590.0
2021-11-23 11:00:00	NVDA	Stock	31.059	31.637	30.904	31.228	59245420.0
2021-11-23 12:00:00	NVDA	Stock	31.2282	31.472	31.066	31.2288	36703810.0
2021-11-23 13:00:00	NVDA	Stock	31.223	31.325	30.88	31.0984	37976110.0
2021-11-23 14:00:00	NVDA	Stock	31.107	31.586	30.946	31.543	39926780.0
2021-11-23 15:00:00	NVDA	Stock	31.5405	31.815	31.434	31.732	59684870.0
2021-11-23 16:00:00	NVDA	Stock	31.725	31.84	31.665	31.772	21390720.0
2021-11-23 17:00:00	NVDA	Stock	31.774	31.965	31.77	31.796	401750.0
2021-11-23 18:00:00	NVDA	Stock	31.802	31.85	31.734	31.746	234560.0
2021-11-23 19:00:00	NVDA	Stock	31.75	31.79	31.64	31.7	297910.0
2021-11-23 04:00:00	AMZN	Stock	177.75	177.75	177.75	177.75	7660.0
2021-11-23 05:00:00	AMZN	Stock	177.7995	177.9	177.7995	177.825	20700.0

> showing 50 of 66,756 rows — these rows as CSV

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