PREVIEW / stock_1hour / 2022-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-28.parquet
  size:    1.4 MB
  rows:    61,417
  symbols: 1,961

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-12-28 04:00:00	AAPL	Stock	130.52	130.52	129.52	129.84	27034.0
2022-12-28 05:00:00	AAPL	Stock	129.89	130.0	129.73	130.0	25957.0
2022-12-28 06:00:00	AAPL	Stock	129.97	130.24	129.81	130.1	16162.0
2022-12-28 07:00:00	AAPL	Stock	130.1	130.48	129.96	130.25	25086.0
2022-12-28 08:00:00	AAPL	Stock	130.15	130.43	129.54	129.87	165017.0
2022-12-28 09:00:00	AAPL	Stock	129.84	131.0275	129.13	129.99	8077116.0
2022-12-28 10:00:00	AAPL	Stock	129.975	130.51	128.06	128.06	10181053.0
2022-12-28 11:00:00	AAPL	Stock	128.07	128.22	126.46	126.6245	14237942.0
2022-12-28 12:00:00	AAPL	Stock	126.6153	127.735	126.41	127.635	9056707.0
2022-12-28 13:00:00	AAPL	Stock	127.64	128.39	126.84	127.085	7394322.0
2022-12-28 14:00:00	AAPL	Stock	127.09	127.5	126.81	126.84	6146109.0
2022-12-28 15:00:00	AAPL	Stock	126.83	126.84	125.87	126.05	13649271.0
2022-12-28 16:00:00	AAPL	Stock	126.05	126.3159	126.0	126.26	5963814.0
2022-12-28 17:00:00	AAPL	Stock	126.22	126.2753	126.04	126.1	211936.0
2022-12-28 18:00:00	AAPL	Stock	126.14	126.28	126.14	126.26	48626.0
2022-12-28 19:00:00	AAPL	Stock	126.26	126.32	126.16	126.32	47281.0
2022-12-28 04:00:00	MSFT	Stock	236.4	237.33	236.33	237.33	9021.0
2022-12-28 05:00:00	MSFT	Stock	237.28	237.31	237.05	237.31	1522.0
2022-12-28 06:00:00	MSFT	Stock	237.33	237.4	237.0	237.35	2841.0
2022-12-28 07:00:00	MSFT	Stock	237.34	237.54	237.32	237.32	3927.0
2022-12-28 08:00:00	MSFT	Stock	237.18	237.82	236.368	236.89	12864.0
2022-12-28 09:00:00	MSFT	Stock	237.09	239.25	236.55	238.5235	1482035.0
2022-12-28 10:00:00	MSFT	Stock	238.53	239.72	236.9	236.99	1870144.0
2022-12-28 11:00:00	MSFT	Stock	236.95	237.18	235.56	235.77	1749762.0
2022-12-28 12:00:00	MSFT	Stock	235.76	236.98	235.2513	236.86	1220850.0
2022-12-28 13:00:00	MSFT	Stock	236.88	237.73	236.03	236.188	1309851.0
2022-12-28 14:00:00	MSFT	Stock	236.2	236.49	235.5	235.72	1129668.0
2022-12-28 15:00:00	MSFT	Stock	235.715	235.735	234.17	234.5	2320744.0
2022-12-28 16:00:00	MSFT	Stock	234.49	234.8	234.43	234.53	2641335.0
2022-12-28 17:00:00	MSFT	Stock	234.6	234.68	234.42	234.5411	20793.0
2022-12-28 18:00:00	MSFT	Stock	234.68	234.87	234.62	234.75	7116.0
2022-12-28 19:00:00	MSFT	Stock	234.8	234.9	234.37	234.61	3910.0
2022-12-28 04:00:00	NVDA	Stock	14.121	14.121	13.875	13.9	223250.0
2022-12-28 05:00:00	NVDA	Stock	13.908	14.121	13.847	14.1	312430.0
2022-12-28 06:00:00	NVDA	Stock	14.071	14.138	14.002	14.102	137530.0
2022-12-28 07:00:00	NVDA	Stock	14.093	14.14	14.035	14.125	621290.0
2022-12-28 08:00:00	NVDA	Stock	14.05	14.143	13.971	14.016	1379960.0
2022-12-28 09:00:00	NVDA	Stock	14.016	14.262	13.884	14.0946	59575210.0
2022-12-28 10:00:00	NVDA	Stock	14.0935	14.212	13.942	13.9451	54922080.0
2022-12-28 11:00:00	NVDA	Stock	13.945	14.061	13.886	14.007	39423410.0
2022-12-28 12:00:00	NVDA	Stock	14.003	14.167	13.9662	14.154	29025930.0
2022-12-28 13:00:00	NVDA	Stock	14.155	14.183	14.086	14.133	26148550.0
2022-12-28 14:00:00	NVDA	Stock	14.135	14.159	13.9905	14.043	25321210.0
2022-12-28 15:00:00	NVDA	Stock	14.047	14.073	13.959	14.036	44392210.0
2022-12-28 16:00:00	NVDA	Stock	14.036	14.058	14.016	14.036	14703180.0
2022-12-28 17:00:00	NVDA	Stock	14.04	14.045	14.016	14.027	159430.0
2022-12-28 18:00:00	NVDA	Stock	14.03	14.049	14.028	14.047	196040.0
2022-12-28 19:00:00	NVDA	Stock	14.049	14.058	14.02	14.055	192400.0
2022-12-28 04:00:00	AMZN	Stock	83.1	83.33	82.94	83.12	24394.0
2022-12-28 05:00:00	AMZN	Stock	83.1	83.18	82.96	83.18	8698.0

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

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