PREVIEW / stock_1hour / 2021-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-26.parquet
  size:    1.4 MB
  rows:    65,626
  symbols: 2,845

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-07-26 04:00:00	AAPL	Stock	148.35	148.35	147.4	147.6	65797.0
2021-07-26 05:00:00	AAPL	Stock	147.56	148.05	147.56	147.95	35909.0
2021-07-26 06:00:00	AAPL	Stock	147.94	148.0	147.64	147.64	8090.0
2021-07-26 07:00:00	AAPL	Stock	147.7	148.51	147.7	148.35	151545.0
2021-07-26 08:00:00	AAPL	Stock	148.4	148.55	147.77	148.16	425206.0
2021-07-26 09:00:00	AAPL	Stock	148.14	149.74	147.7	149.49	11441288.0
2021-07-26 10:00:00	AAPL	Stock	149.49	149.83	148.92	149.34	10827459.0
2021-07-26 11:00:00	AAPL	Stock	149.35	149.81	149.21	149.5	6571472.0
2021-07-26 12:00:00	AAPL	Stock	149.52	149.6299	149.04	149.08	4884984.0
2021-07-26 13:00:00	AAPL	Stock	149.085	149.51	149.06	149.35	3991039.0
2021-07-26 14:00:00	AAPL	Stock	149.34	149.5	149.0421	149.48	4577830.0
2021-07-26 15:00:00	AAPL	Stock	149.475	149.5	148.7717	148.99	9080654.0
2021-07-26 16:00:00	AAPL	Stock	148.99	149.27	148.91	149.21	7013123.0
2021-07-26 17:00:00	AAPL	Stock	149.24	149.34	149.13	149.3	123486.0
2021-07-26 18:00:00	AAPL	Stock	149.3	149.32	149.21	149.29	95373.0
2021-07-26 19:00:00	AAPL	Stock	149.295	149.35	149.26	149.26	76977.0
2021-07-26 04:00:00	MSFT	Stock	289.74	289.88	289.0	289.8	10902.0
2021-07-26 05:00:00	MSFT	Stock	289.89	290.44	289.8	290.38	3013.0
2021-07-26 06:00:00	MSFT	Stock	290.13	290.3	289.6	289.6	4456.0
2021-07-26 07:00:00	MSFT	Stock	289.69	290.39	289.6	289.9	25048.0
2021-07-26 08:00:00	MSFT	Stock	289.95	290.394	288.66	289.0	116521.0
2021-07-26 09:00:00	MSFT	Stock	288.97	289.39	286.642	288.025	2339005.0
2021-07-26 10:00:00	MSFT	Stock	288.035	288.2	286.66	286.97	2356197.0
2021-07-26 11:00:00	MSFT	Stock	286.94	288.5499	286.815	288.51	1657872.0
2021-07-26 12:00:00	MSFT	Stock	288.5285	289.36	288.13	288.43	1940411.0
2021-07-26 13:00:00	MSFT	Stock	288.415	289.08	288.415	288.8335	1165226.0
2021-07-26 14:00:00	MSFT	Stock	288.83	289.62	288.61	289.515	1834181.0
2021-07-26 15:00:00	MSFT	Stock	289.5	289.69	288.56	289.05	2952930.0
2021-07-26 16:00:00	MSFT	Stock	289.05	289.3	289.0	289.24	3628841.0
2021-07-26 17:00:00	MSFT	Stock	289.22	289.63	289.2	289.6	20913.0
2021-07-26 18:00:00	MSFT	Stock	289.51	289.59	289.42	289.49	10137.0
2021-07-26 19:00:00	MSFT	Stock	289.5	289.87	289.45	289.62	10214.0
2021-07-26 04:00:00	NVDA	Stock	19.5	19.5	19.1	19.3	129650.0
2021-07-26 05:00:00	NVDA	Stock	19.3	19.383	19.3	19.383	82830.0
2021-07-26 06:00:00	NVDA	Stock	19.37	19.473	19.367	19.415	44570.0
2021-07-26 07:00:00	NVDA	Stock	19.45	19.45	19.333	19.4	441050.0
2021-07-26 08:00:00	NVDA	Stock	19.3997	19.6068	19.25	19.288	3084920.0
2021-07-26 09:00:00	NVDA	Stock	19.277	19.437	18.914	19.34	31627080.0
2021-07-26 10:00:00	NVDA	Stock	19.3435	19.442	19.21	19.278	23870460.0
2021-07-26 11:00:00	NVDA	Stock	19.275	19.325	19.2194	19.303	10905400.0
2021-07-26 12:00:00	NVDA	Stock	19.306	19.309	19.111	19.168	18668810.0
2021-07-26 13:00:00	NVDA	Stock	19.172	19.229	19.15	19.18	11032510.0
2021-07-26 14:00:00	NVDA	Stock	19.184	19.192	19.073	19.16	14986830.0
2021-07-26 15:00:00	NVDA	Stock	19.1632	19.313	19.152	19.287	21275100.0
2021-07-26 16:00:00	NVDA	Stock	19.294	19.294	19.195	19.215	19318040.0
2021-07-26 17:00:00	NVDA	Stock	19.229	19.23	19.2	19.201	286190.0
2021-07-26 18:00:00	NVDA	Stock	19.21	19.225	19.21	19.22	87810.0
2021-07-26 19:00:00	NVDA	Stock	19.228	19.23	19.215	19.22	104070.0
2021-07-26 04:00:00	AMZN	Stock	182.515	182.515	182.515	182.515	2000.0
2021-07-26 05:00:00	AMZN	Stock	182.65	183.25	182.65	183.25	10700.0

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

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