PREVIEW / stock_1hour / 2022-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-16.parquet
  size:    1.4 MB
  rows:    63,711
  symbols: 2,232

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-16 04:00:00	AAPL	Stock	172.86	173.0	172.7	172.88	22000.0
2022-08-16 05:00:00	AAPL	Stock	172.89	172.91	172.68	172.75	10654.0
2022-08-16 06:00:00	AAPL	Stock	172.8	172.88	172.71	172.81	9678.0
2022-08-16 07:00:00	AAPL	Stock	172.86	173.19	172.8	173.08	70341.0
2022-08-16 08:00:00	AAPL	Stock	172.87	173.19	172.0	172.7446	566681.0
2022-08-16 09:00:00	AAPL	Stock	172.78	172.98	172.14	172.3299	6458693.0
2022-08-16 10:00:00	AAPL	Stock	172.33	172.605	171.6618	172.38	8286674.0
2022-08-16 11:00:00	AAPL	Stock	172.37	173.49	172.35	173.34	6264166.0
2022-08-16 12:00:00	AAPL	Stock	173.34	173.38	172.58	172.825	3375158.0
2022-08-16 13:00:00	AAPL	Stock	172.83	173.3	172.715	173.09	3100967.0
2022-08-16 14:00:00	AAPL	Stock	173.099	173.71	171.83	172.4	5687033.0
2022-08-16 15:00:00	AAPL	Stock	172.3907	173.27	172.04	173.03	6971194.0
2022-08-16 16:00:00	AAPL	Stock	173.02	173.9	172.94	173.8967	4817078.0
2022-08-16 17:00:00	AAPL	Stock	173.89	174.09	173.81	173.84	137384.0
2022-08-16 18:00:00	AAPL	Stock	173.85	173.85	173.63	173.67	50918.0
2022-08-16 19:00:00	AAPL	Stock	173.69	173.82	173.48	173.7	124286.0
2022-08-16 04:00:00	MSFT	Stock	292.28	293.0	292.28	293.0	1773.0
2022-08-16 05:00:00	MSFT	Stock	292.75	292.75	292.75	292.75	744.0
2022-08-16 06:00:00	MSFT	Stock	292.75	292.75	292.75	292.75	432.0
2022-08-16 07:00:00	MSFT	Stock	292.86	293.28	292.7	292.87	8582.0
2022-08-16 08:00:00	MSFT	Stock	292.7523	293.49	292.22	292.5	47234.0
2022-08-16 09:00:00	MSFT	Stock	292.69	292.88	291.43	292.47	1810667.0
2022-08-16 10:00:00	MSFT	Stock	292.49	292.5	290.42	291.08	2007595.0
2022-08-16 11:00:00	MSFT	Stock	291.06	293.49	290.9803	293.1588	1116015.0
2022-08-16 12:00:00	MSFT	Stock	293.15	293.23	292.03	292.33	684090.0
2022-08-16 13:00:00	MSFT	Stock	292.36	293.47	292.2335	293.205	665755.0
2022-08-16 14:00:00	MSFT	Stock	293.22	294.04	291.17	292.01	1175208.0
2022-08-16 15:00:00	MSFT	Stock	292.0	293.69	291.5991	292.7	1779641.0
2022-08-16 16:00:00	MSFT	Stock	292.75	293.3	292.6	292.96	2718132.0
2022-08-16 17:00:00	MSFT	Stock	293.11	293.11	292.8225	292.8225	2300.0
2022-08-16 18:00:00	MSFT	Stock	292.9	292.99	292.69	292.95	10781.0
2022-08-16 19:00:00	MSFT	Stock	292.76	293.0	292.56	293.0	18282.0
2022-08-16 04:00:00	NVDA	Stock	18.942	19.0	18.91	19.0	29670.0
2022-08-16 05:00:00	NVDA	Stock	18.967	18.967	18.948	18.959	19920.0
2022-08-16 06:00:00	NVDA	Stock	18.948	18.967	18.933	18.966	44070.0
2022-08-16 07:00:00	NVDA	Stock	18.962	19.09	18.962	19.04	155210.0
2022-08-16 08:00:00	NVDA	Stock	18.99	19.1	18.921	18.9606	1197630.0
2022-08-16 09:00:00	NVDA	Stock	18.966	19.01	18.625	18.8295	58377210.0
2022-08-16 10:00:00	NVDA	Stock	18.828	18.83	18.501	18.6545	70430560.0
2022-08-16 11:00:00	NVDA	Stock	18.6535	18.929	18.6158	18.915	44385100.0
2022-08-16 12:00:00	NVDA	Stock	18.9165	18.975	18.832	18.919	31170240.0
2022-08-16 13:00:00	NVDA	Stock	18.92	19.112	18.892	19.0388	38433980.0
2022-08-16 14:00:00	NVDA	Stock	19.038	19.142	18.719	18.848	46312620.0
2022-08-16 15:00:00	NVDA	Stock	18.846	18.949	18.78	18.8755	46898450.0
2022-08-16 16:00:00	NVDA	Stock	18.878	18.9	18.851	18.881	13994380.0
2022-08-16 17:00:00	NVDA	Stock	18.9	18.9	18.882	18.886	107250.0
2022-08-16 18:00:00	NVDA	Stock	18.882	18.886	18.852	18.863	87480.0
2022-08-16 19:00:00	NVDA	Stock	18.863	18.87	18.854	18.855	92310.0
2022-08-16 04:00:00	AMZN	Stock	142.64	143.0	142.43	142.7	11660.0
2022-08-16 05:00:00	AMZN	Stock	142.56	142.56	142.41	142.45	4293.0

> showing 50 of 63,711 rows — these rows as CSV

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