PREVIEW / stock_1hour / 2022-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-23.parquet
  size:    1.4 MB
  rows:    62,010
  symbols: 2,187

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-23 04:00:00	AAPL	Stock	167.35	168.38	167.35	167.93	31750.0
2022-08-23 05:00:00	AAPL	Stock	167.87	168.09	167.73	168.09	10330.0
2022-08-23 06:00:00	AAPL	Stock	168.02	168.17	167.78	167.95	57330.0
2022-08-23 07:00:00	AAPL	Stock	167.89	168.07	167.65	168.0	56466.0
2022-08-23 08:00:00	AAPL	Stock	167.9001	168.0988	166.47	167.35	376213.0
2022-08-23 09:00:00	AAPL	Stock	167.34	168.41	166.94	168.01	7131558.0
2022-08-23 10:00:00	AAPL	Stock	168.02	168.71	167.02	167.0804	7266754.0
2022-08-23 11:00:00	AAPL	Stock	167.08	167.83	166.65	167.82	5983126.0
2022-08-23 12:00:00	AAPL	Stock	167.81	168.0495	167.21	167.885	4505151.0
2022-08-23 13:00:00	AAPL	Stock	167.89	168.175	167.31	167.581	4105928.0
2022-08-23 14:00:00	AAPL	Stock	167.585	168.05	167.425	167.79	3658190.0
2022-08-23 15:00:00	AAPL	Stock	167.8	168.03	166.84	167.23	7693804.0
2022-08-23 16:00:00	AAPL	Stock	167.23	167.23	166.95	166.98	4041231.0
2022-08-23 17:00:00	AAPL	Stock	166.95	166.98	166.85	166.96	25986.0
2022-08-23 18:00:00	AAPL	Stock	166.96	167.1	166.95	167.08	20531.0
2022-08-23 19:00:00	AAPL	Stock	167.1	167.2	167.06	167.12	14799.0
2022-08-23 04:00:00	MSFT	Stock	278.32	278.56	277.74	277.85	2082.0
2022-08-23 05:00:00	MSFT	Stock	277.58	277.86	277.41	277.86	2287.0
2022-08-23 06:00:00	MSFT	Stock	277.85	278.0	277.4	277.87	9944.0
2022-08-23 07:00:00	MSFT	Stock	277.75	277.9	277.4	277.8	4204.0
2022-08-23 08:00:00	MSFT	Stock	277.9326	278.2153	276.7949	276.85	24859.0
2022-08-23 09:00:00	MSFT	Stock	276.9	278.4	276.22	277.345	1526866.0
2022-08-23 10:00:00	MSFT	Stock	277.35	278.86	276.13	276.23	1895736.0
2022-08-23 11:00:00	MSFT	Stock	276.225	276.9	275.9	276.55	1178779.0
2022-08-23 12:00:00	MSFT	Stock	276.57	276.71	275.4	276.57	1047302.0
2022-08-23 13:00:00	MSFT	Stock	276.59	277.33	276.17	276.77	1180129.0
2022-08-23 14:00:00	MSFT	Stock	276.76	277.515	276.58	277.04	893976.0
2022-08-23 15:00:00	MSFT	Stock	277.04	277.49	276.02	276.43	1976012.0
2022-08-23 16:00:00	MSFT	Stock	276.44	276.44	275.91	275.91	2062799.0
2022-08-23 17:00:00	MSFT	Stock	275.93	275.95	275.67	275.89	7277.0
2022-08-23 18:00:00	MSFT	Stock	275.89	276.25	275.89	276.25	5068.0
2022-08-23 19:00:00	MSFT	Stock	276.1	276.19	276.0	276.19	2917.0
2022-08-23 04:00:00	NVDA	Stock	17.07	17.159	17.07	17.114	96330.0
2022-08-23 05:00:00	NVDA	Stock	17.11	17.112	17.06	17.099	67460.0
2022-08-23 06:00:00	NVDA	Stock	17.12	17.129	17.031	17.065	45460.0
2022-08-23 07:00:00	NVDA	Stock	17.085	17.085	17.034	17.075	178850.0
2022-08-23 08:00:00	NVDA	Stock	17.085	17.096	16.84	16.985	859280.0
2022-08-23 09:00:00	NVDA	Stock	16.988	17.351	16.9281	17.273	56995480.0
2022-08-23 10:00:00	NVDA	Stock	17.2762	17.465	17.174	17.192	60220730.0
2022-08-23 11:00:00	NVDA	Stock	17.191	17.333	17.148	17.228	39187800.0
2022-08-23 12:00:00	NVDA	Stock	17.228	17.2888	17.159	17.273	26118750.0
2022-08-23 13:00:00	NVDA	Stock	17.274	17.29	17.168	17.2235	26095730.0
2022-08-23 14:00:00	NVDA	Stock	17.223	17.308	17.196	17.241	29093900.0
2022-08-23 15:00:00	NVDA	Stock	17.245	17.285	17.152	17.182	39379860.0
2022-08-23 16:00:00	NVDA	Stock	17.181	17.191	17.147	17.16	13863400.0
2022-08-23 17:00:00	NVDA	Stock	17.167	17.169	17.15	17.167	186410.0
2022-08-23 18:00:00	NVDA	Stock	17.163	17.199	17.155	17.185	166180.0
2022-08-23 19:00:00	NVDA	Stock	17.195	17.2	17.181	17.182	110960.0
2022-08-23 04:00:00	AMZN	Stock	134.2	134.2	133.5	133.7	19559.0
2022-08-23 05:00:00	AMZN	Stock	133.8	133.93	133.6	133.93	6286.0

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

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