PREVIEW / stock_1hour / 2022-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-25.parquet
  size:    1.4 MB
  rows:    62,090
  symbols: 2,267

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-25 04:00:00	AAPL	Stock	169.02	169.8	168.61	169.32	27673.0
2022-08-25 05:00:00	AAPL	Stock	169.3	169.38	168.62	168.8	32966.0
2022-08-25 06:00:00	AAPL	Stock	168.8	168.87	168.63	168.86	9712.0
2022-08-25 07:00:00	AAPL	Stock	168.75	168.94	168.55	168.73	50584.0
2022-08-25 08:00:00	AAPL	Stock	168.71	169.99	167.112	168.69	283298.0
2022-08-25 09:00:00	AAPL	Stock	168.71	169.76	168.5	169.58	7559775.0
2022-08-25 10:00:00	AAPL	Stock	169.58	169.92	169.205	169.27	7030955.0
2022-08-25 11:00:00	AAPL	Stock	169.265	169.28	168.45	169.05	4477307.0
2022-08-25 12:00:00	AAPL	Stock	169.05	169.06	168.35	168.655	2996058.0
2022-08-25 13:00:00	AAPL	Stock	168.65	169.42	168.54	169.21	4109011.0
2022-08-25 14:00:00	AAPL	Stock	169.21	169.39	168.91	169.24	3313812.0
2022-08-25 15:00:00	AAPL	Stock	169.249	170.14	169.0321	170.13	8310500.0
2022-08-25 16:00:00	AAPL	Stock	170.07	170.1628	169.98	170.02	5364366.0
2022-08-25 17:00:00	AAPL	Stock	170.01	170.11	169.98	170.05	27291.0
2022-08-25 18:00:00	AAPL	Stock	170.1	170.12	169.98	170.07	25367.0
2022-08-25 19:00:00	AAPL	Stock	170.09	170.35	170.09	170.2	27820.0
2022-08-25 04:00:00	MSFT	Stock	278.37	278.37	278.18	278.22	400.0
2022-08-25 05:00:00	MSFT	Stock	278.37	278.4	276.98	276.98	3406.0
2022-08-25 06:00:00	MSFT	Stock	277.05	277.78	277.05	277.75	2567.0
2022-08-25 07:00:00	MSFT	Stock	277.9	278.16	277.5	277.59	9362.0
2022-08-25 08:00:00	MSFT	Stock	277.97	278.3473	277.1	277.3	24747.0
2022-08-25 09:00:00	MSFT	Stock	277.58	277.7	274.52	276.72	1846007.0
2022-08-25 10:00:00	MSFT	Stock	276.78	277.66	276.61	276.86	1423532.0
2022-08-25 11:00:00	MSFT	Stock	276.91	277.08	275.02	275.76	1295819.0
2022-08-25 12:00:00	MSFT	Stock	275.755	276.07	275.23	275.74	759080.0
2022-08-25 13:00:00	MSFT	Stock	275.73	276.815	275.48	276.775	779757.0
2022-08-25 14:00:00	MSFT	Stock	276.8	276.95	276.11	276.54	692280.0
2022-08-25 15:00:00	MSFT	Stock	276.52	279.02	276.42	279.0	2107644.0
2022-08-25 16:00:00	MSFT	Stock	278.85	278.9	278.6027	278.8	2498674.0
2022-08-25 17:00:00	MSFT	Stock	278.7053	278.96	278.7053	278.96	446432.0
2022-08-25 18:00:00	MSFT	Stock	278.88	278.89	278.54	278.71	9638.0
2022-08-25 19:00:00	MSFT	Stock	278.75	278.85	278.75	278.83	6490.0
2022-08-25 04:00:00	NVDA	Stock	16.438	16.764	16.438	16.693	945180.0
2022-08-25 05:00:00	NVDA	Stock	16.69	16.697	16.5	16.531	463350.0
2022-08-25 06:00:00	NVDA	Stock	16.54	16.688	16.533	16.649	369100.0
2022-08-25 07:00:00	NVDA	Stock	16.631	16.67	16.585	16.636	859120.0
2022-08-25 08:00:00	NVDA	Stock	16.62	16.84	16.576	16.81	7192600.0
2022-08-25 09:00:00	NVDA	Stock	16.8106	17.252	16.78	17.208	112958190.0
2022-08-25 10:00:00	NVDA	Stock	17.209	17.8375	17.157	17.661	157377380.0
2022-08-25 11:00:00	NVDA	Stock	17.662	17.816	17.526	17.662	95216050.0
2022-08-25 12:00:00	NVDA	Stock	17.6602	17.737	17.521	17.725	65841440.0
2022-08-25 13:00:00	NVDA	Stock	17.722	17.862	17.663	17.771	51586500.0
2022-08-25 14:00:00	NVDA	Stock	17.773	17.775	17.631	17.7307	43461170.0
2022-08-25 15:00:00	NVDA	Stock	17.7298	17.947	17.681	17.915	78609130.0
2022-08-25 16:00:00	NVDA	Stock	17.913	17.949	17.872	17.89	18765820.0
2022-08-25 17:00:00	NVDA	Stock	17.88	17.94	17.88	17.94	568600.0
2022-08-25 18:00:00	NVDA	Stock	17.935	17.935	17.903	17.915	200120.0
2022-08-25 19:00:00	NVDA	Stock	17.921	17.947	17.912	17.935	364520.0
2022-08-25 04:00:00	AMZN	Stock	135.02	135.87	135.02	135.81	8797.0
2022-08-25 05:00:00	AMZN	Stock	135.78	136.0	135.04	135.27	16262.0

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

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