PREVIEW / stock_1hour / 2021-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-11.parquet
  size:    1.4 MB
  rows:    64,706
  symbols: 2,819

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-08-11 04:00:00	AAPL	Stock	145.41	145.41	145.2	145.25	7414.0
2021-08-11 05:00:00	AAPL	Stock	145.22	145.24	144.8	145.17	10378.0
2021-08-11 06:00:00	AAPL	Stock	145.13	145.34	145.12	145.32	11373.0
2021-08-11 07:00:00	AAPL	Stock	145.36	145.48	145.23	145.27	44416.0
2021-08-11 08:00:00	AAPL	Stock	145.349	146.22	145.236	146.02	410877.0
2021-08-11 09:00:00	AAPL	Stock	146.05	146.72	145.92	146.08	7506816.0
2021-08-11 10:00:00	AAPL	Stock	146.07	146.43	145.57	145.62	8038733.0
2021-08-11 11:00:00	AAPL	Stock	145.62	146.07	145.53	145.89	6157650.0
2021-08-11 12:00:00	AAPL	Stock	145.89	146.46	145.86	146.3088	4809735.0
2021-08-11 13:00:00	AAPL	Stock	146.305	146.59	145.82	146.05	4884184.0
2021-08-11 14:00:00	AAPL	Stock	146.04	146.12	145.8	145.96	3000287.0
2021-08-11 15:00:00	AAPL	Stock	145.97	146.09	145.7799	145.91	5736604.0
2021-08-11 16:00:00	AAPL	Stock	145.86	145.92	145.66	145.7	3046307.0
2021-08-11 17:00:00	AAPL	Stock	145.71	145.73	145.66	145.72	18117.0
2021-08-11 18:00:00	AAPL	Stock	145.7199	145.7199	145.66	145.68	26286.0
2021-08-11 19:00:00	AAPL	Stock	145.7	145.71	145.6	145.67	24447.0
2021-08-11 04:00:00	MSFT	Stock	286.11	286.11	285.73	285.75	900.0
2021-08-11 05:00:00	MSFT	Stock	285.71	285.71	285.29	285.29	1728.0
2021-08-11 06:00:00	MSFT	Stock	285.3	286.53	285.3	286.53	2569.0
2021-08-11 07:00:00	MSFT	Stock	286.2	286.2	285.95	285.95	4003.0
2021-08-11 08:00:00	MSFT	Stock	286.04	287.85	285.96	287.28	31135.0
2021-08-11 09:00:00	MSFT	Stock	287.29	288.66	286.44	287.4599	1609470.0
2021-08-11 10:00:00	MSFT	Stock	287.47	288.05	286.35	286.35	1700739.0
2021-08-11 11:00:00	MSFT	Stock	286.36	286.47	285.86	286.31	1234444.0
2021-08-11 12:00:00	MSFT	Stock	286.3	287.17	286.27	286.86	829323.0
2021-08-11 13:00:00	MSFT	Stock	286.87	287.22	286.47	286.69	816712.0
2021-08-11 14:00:00	MSFT	Stock	286.69	286.9535	286.44	286.88	641353.0
2021-08-11 15:00:00	MSFT	Stock	286.89	287.13	286.6	286.98	1450042.0
2021-08-11 16:00:00	MSFT	Stock	286.97	287.0	286.88	286.88	2151644.0
2021-08-11 17:00:00	MSFT	Stock	286.8	286.8	286.8	286.8	2793.0
2021-08-11 18:00:00	MSFT	Stock	286.81	286.88	286.7	286.88	2052.0
2021-08-11 19:00:00	MSFT	Stock	286.62	286.66	286.43	286.6	1721.0
2021-08-11 04:00:00	NVDA	Stock	20.0	20.0	19.855	19.855	45140.0
2021-08-11 05:00:00	NVDA	Stock	19.854	19.862	19.76	19.76	26070.0
2021-08-11 06:00:00	NVDA	Stock	19.775	19.841	19.775	19.841	31550.0
2021-08-11 07:00:00	NVDA	Stock	19.859	19.878	19.8	19.823	123920.0
2021-08-11 08:00:00	NVDA	Stock	19.834	20.074	19.8	19.986	982610.0
2021-08-11 09:00:00	NVDA	Stock	19.985	20.1144	19.726	19.8935	21031800.0
2021-08-11 10:00:00	NVDA	Stock	19.898	19.976	19.581	19.581	26121460.0
2021-08-11 11:00:00	NVDA	Stock	19.585	19.61	19.43	19.5137	23388790.0
2021-08-11 12:00:00	NVDA	Stock	19.513	19.65	19.4975	19.5925	12805260.0
2021-08-11 13:00:00	NVDA	Stock	19.598	19.724	19.544	19.604	10004300.0
2021-08-11 14:00:00	NVDA	Stock	19.6046	19.694	19.5945	19.675	9083520.0
2021-08-11 15:00:00	NVDA	Stock	19.679	19.733	19.646	19.699	15477410.0
2021-08-11 16:00:00	NVDA	Stock	19.699	19.71	19.68	19.691	16220530.0
2021-08-11 17:00:00	NVDA	Stock	19.695	19.695	19.661	19.661	137200.0
2021-08-11 18:00:00	NVDA	Stock	19.679	19.679	19.621	19.632	45560.0
2021-08-11 19:00:00	NVDA	Stock	19.632	19.66	19.612	19.63	55580.0
2021-08-11 06:00:00	AMZN	Stock	165.699	165.699	165.699	165.699	2000.0
2021-08-11 07:00:00	AMZN	Stock	165.9	165.905	165.9	165.9	10360.0

> showing 50 of 64,706 rows — these rows as CSV

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