PREVIEW / stock_1hour / 2022-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-19.parquet
  size:    1.4 MB
  rows:    62,823
  symbols: 2,205

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-19 04:00:00	AAPL	Stock	173.6	173.6	172.4	172.69	54521.0
2022-08-19 05:00:00	AAPL	Stock	172.66	172.85	172.57	172.6	25987.0
2022-08-19 06:00:00	AAPL	Stock	172.59	172.68	172.2	172.45	20905.0
2022-08-19 07:00:00	AAPL	Stock	172.55	172.78	172.35	172.59	132567.0
2022-08-19 08:00:00	AAPL	Stock	172.6	173.85	172.35	172.63	510390.0
2022-08-19 09:00:00	AAPL	Stock	172.63	173.74	172.55	172.77	12339717.0
2022-08-19 10:00:00	AAPL	Stock	172.77	173.09	171.73	171.83	9968220.0
2022-08-19 11:00:00	AAPL	Stock	171.835	172.448	171.64	172.17	6536800.0
2022-08-19 12:00:00	AAPL	Stock	172.16	172.94	171.86	172.74	5035587.0
2022-08-19 13:00:00	AAPL	Stock	172.74	173.03	171.74	172.18	4835993.0
2022-08-19 14:00:00	AAPL	Stock	172.18	172.27	171.76	171.8401	3891398.0
2022-08-19 15:00:00	AAPL	Stock	171.85	171.95	171.3101	171.52	9808302.0
2022-08-19 16:00:00	AAPL	Stock	171.52	171.7	171.23	171.28	8048678.0
2022-08-19 17:00:00	AAPL	Stock	171.27	171.28	171.04	171.05	61352.0
2022-08-19 18:00:00	AAPL	Stock	171.08	171.08	170.75	170.76	80489.0
2022-08-19 19:00:00	AAPL	Stock	170.76	170.8	170.7	170.75	47244.0
2022-08-19 04:00:00	MSFT	Stock	289.09	289.09	287.31	287.54	14028.0
2022-08-19 05:00:00	MSFT	Stock	287.81	288.16	287.71	288.16	1267.0
2022-08-19 06:00:00	MSFT	Stock	287.5	287.5	286.62	286.62	2156.0
2022-08-19 07:00:00	MSFT	Stock	287.3	288.56	286.76	287.25	20575.0
2022-08-19 08:00:00	MSFT	Stock	287.559	289.445	286.8	287.0	35217.0
2022-08-19 09:00:00	MSFT	Stock	287.1	289.32	286.32	286.56	3034062.0
2022-08-19 10:00:00	MSFT	Stock	286.585	287.65	286.27	286.27	1610144.0
2022-08-19 11:00:00	MSFT	Stock	286.275	287.21	285.92	286.4777	1184260.0
2022-08-19 12:00:00	MSFT	Stock	286.445	287.12	286.26	286.73	1000147.0
2022-08-19 13:00:00	MSFT	Stock	286.73	286.92	285.6371	286.405	643050.0
2022-08-19 14:00:00	MSFT	Stock	286.38	286.58	285.78	286.065	712422.0
2022-08-19 15:00:00	MSFT	Stock	286.065	286.88	285.56	286.16	2214964.0
2022-08-19 16:00:00	MSFT	Stock	286.15	286.34	285.76	285.77	4198176.0
2022-08-19 17:00:00	MSFT	Stock	285.77	285.77	285.5	285.55	4979.0
2022-08-19 18:00:00	MSFT	Stock	285.55	285.61	285.15	285.22	7683.0
2022-08-19 19:00:00	MSFT	Stock	285.1	285.2	285.03	285.03	2129.0
2022-08-19 04:00:00	NVDA	Stock	18.558	18.566	18.352	18.405	444040.0
2022-08-19 05:00:00	NVDA	Stock	18.41	18.446	18.41	18.421	41270.0
2022-08-19 06:00:00	NVDA	Stock	18.413	18.413	18.361	18.398	96090.0
2022-08-19 07:00:00	NVDA	Stock	18.398	18.45	18.371	18.446	431320.0
2022-08-19 08:00:00	NVDA	Stock	18.408	18.767	18.3762	18.408	1410010.0
2022-08-19 09:00:00	NVDA	Stock	18.427	18.52	18.093	18.105	65076420.0
2022-08-19 10:00:00	NVDA	Stock	18.105	18.175	17.92	17.926	72055650.0
2022-08-19 11:00:00	NVDA	Stock	17.9243	18.02	17.881	17.936	48383670.0
2022-08-19 12:00:00	NVDA	Stock	17.936	17.9912	17.894	17.945	28408820.0
2022-08-19 13:00:00	NVDA	Stock	17.945	17.984	17.77	17.8823	34857180.0
2022-08-19 14:00:00	NVDA	Stock	17.8815	17.916	17.837	17.8505	28896910.0
2022-08-19 15:00:00	NVDA	Stock	17.85	17.943	17.82	17.848	50394030.0
2022-08-19 16:00:00	NVDA	Stock	17.848	17.853	17.8126	17.831	24373260.0
2022-08-19 17:00:00	NVDA	Stock	17.822	17.829	17.811	17.822	172380.0
2022-08-19 18:00:00	NVDA	Stock	17.818	17.822	17.71	17.71	258660.0
2022-08-19 19:00:00	NVDA	Stock	17.712	17.746	17.7	17.7	329990.0
2022-08-19 04:00:00	AMZN	Stock	141.8	141.8	140.36	140.45	11123.0
2022-08-19 05:00:00	AMZN	Stock	140.55	140.95	140.55	140.78	28986.0

> showing 50 of 62,823 rows — these rows as CSV

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