PREVIEW / stock_1hour / 2022-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-28.parquet
  size:    1.4 MB
  rows:    61,259
  symbols: 2,104

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-11-28 04:00:00	AAPL	Stock	147.05	147.64	145.03	145.3	92315.0
2022-11-28 05:00:00	AAPL	Stock	145.26	145.5	145.15	145.37	16107.0
2022-11-28 06:00:00	AAPL	Stock	145.31	145.58	145.07	145.43	38833.0
2022-11-28 07:00:00	AAPL	Stock	145.48	145.86	145.3	145.5	171948.0
2022-11-28 08:00:00	AAPL	Stock	145.48	147.74	144.78	145.32	536159.0
2022-11-28 09:00:00	AAPL	Stock	145.29	146.64	144.82	145.96	8590940.0
2022-11-28 10:00:00	AAPL	Stock	145.97	146.19	144.8299	145.01	8742764.0
2022-11-28 11:00:00	AAPL	Stock	145.005	145.48	144.77	145.1599	6110358.0
2022-11-28 12:00:00	AAPL	Stock	145.16	145.7556	144.74	144.8292	5335483.0
2022-11-28 13:00:00	AAPL	Stock	144.82	145.0801	143.93	143.967	5550548.0
2022-11-28 14:00:00	AAPL	Stock	143.965	144.0823	143.38	143.94	6286374.0
2022-11-28 15:00:00	AAPL	Stock	143.94	144.46	143.64	144.22	9857218.0
2022-11-28 16:00:00	AAPL	Stock	144.23	144.68	144.17	144.5	9342095.0
2022-11-28 17:00:00	AAPL	Stock	144.48	144.48	144.22	144.3699	227600.0
2022-11-28 18:00:00	AAPL	Stock	144.36	144.42	144.25	144.25	36512.0
2022-11-28 19:00:00	AAPL	Stock	144.23	144.5	144.23	144.48	49886.0
2022-11-28 04:00:00	MSFT	Stock	246.98	246.98	245.43	245.43	5634.0
2022-11-28 05:00:00	MSFT	Stock	245.21	245.8	245.21	245.75	2652.0
2022-11-28 06:00:00	MSFT	Stock	245.88	245.95	245.78	245.94	3171.0
2022-11-28 07:00:00	MSFT	Stock	246.14	246.31	245.92	245.95	5946.0
2022-11-28 08:00:00	MSFT	Stock	246.0001	246.6	245.52	246.4	47969.0
2022-11-28 09:00:00	MSFT	Stock	246.29	246.65	244.65	244.91	1865262.0
2022-11-28 10:00:00	MSFT	Stock	244.9	245.205	242.64	242.99	2206414.0
2022-11-28 11:00:00	MSFT	Stock	242.99	243.34	242.33	243.11	1677288.0
2022-11-28 12:00:00	MSFT	Stock	243.11	243.7	241.98	242.035	1971794.0
2022-11-28 13:00:00	MSFT	Stock	242.045	242.56	241.46	241.615	1086994.0
2022-11-28 14:00:00	MSFT	Stock	241.6	241.75	240.82	241.62	1307545.0
2022-11-28 15:00:00	MSFT	Stock	241.62	242.21	240.8	241.77	3351919.0
2022-11-28 16:00:00	MSFT	Stock	241.74	242.3	240.9	241.25	3912552.0
2022-11-28 17:00:00	MSFT	Stock	241.24	241.24	241.01	241.03	6869.0
2022-11-28 18:00:00	MSFT	Stock	241.15	241.76	241.0	241.0001	27721.0
2022-11-28 19:00:00	MSFT	Stock	241.04	241.38	241.0	241.1	24469.0
2022-11-28 04:00:00	NVDA	Stock	16.193	16.193	16.005	16.007	211870.0
2022-11-28 05:00:00	NVDA	Stock	16.01	16.078	16.01	16.051	31850.0
2022-11-28 06:00:00	NVDA	Stock	16.064	16.09	16.032	16.09	42940.0
2022-11-28 07:00:00	NVDA	Stock	16.099	16.135	16.07	16.099	135730.0
2022-11-28 08:00:00	NVDA	Stock	16.08	16.125	15.968	16.09	548740.0
2022-11-28 09:00:00	NVDA	Stock	16.075	16.357	16.005	16.3045	38251920.0
2022-11-28 10:00:00	NVDA	Stock	16.298	16.342	16.0355	16.0449	40987870.0
2022-11-28 11:00:00	NVDA	Stock	16.043	16.123	16.039	16.1056	24715390.0
2022-11-28 12:00:00	NVDA	Stock	16.1065	16.152	16.008	16.0198	28507430.0
2022-11-28 13:00:00	NVDA	Stock	16.02	16.071	15.952	15.962	19143190.0
2022-11-28 14:00:00	NVDA	Stock	15.96	15.9779	15.882	15.904	21369500.0
2022-11-28 15:00:00	NVDA	Stock	15.905	15.9186	15.725	15.831	46054720.0
2022-11-28 16:00:00	NVDA	Stock	15.827	15.859	15.8	15.845	26211230.0
2022-11-28 17:00:00	NVDA	Stock	15.84	15.84	15.813	15.813	42700.0
2022-11-28 18:00:00	NVDA	Stock	15.828	15.83	15.8	15.824	181550.0
2022-11-28 19:00:00	NVDA	Stock	15.801	15.824	15.778	15.809	195470.0
2022-11-28 04:00:00	AMZN	Stock	93.12	93.48	92.34	92.34	72276.0
2022-11-28 05:00:00	AMZN	Stock	92.28	92.58	92.15	92.46	14021.0

> showing 50 of 61,259 rows — these rows as CSV

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