PREVIEW / stock_1hour / 2022-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-02.parquet
  size:    1.4 MB
  rows:    65,138
  symbols: 2,561

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-02-02 04:00:00	AAPL	Stock	174.19	175.32	174.11	175.32	41994.0
2022-02-02 05:00:00	AAPL	Stock	175.31	175.31	174.61	174.71	13116.0
2022-02-02 06:00:00	AAPL	Stock	174.66	175.1	174.41	174.94	22808.0
2022-02-02 07:00:00	AAPL	Stock	174.96	175.23	174.75	175.11	172962.0
2022-02-02 08:00:00	AAPL	Stock	174.9033	175.24	174.53	174.67	1873679.0
2022-02-02 09:00:00	AAPL	Stock	174.61	175.47	173.94	174.7	8948440.0
2022-02-02 10:00:00	AAPL	Stock	174.71	175.56	174.33	174.69	10261558.0
2022-02-02 11:00:00	AAPL	Stock	174.69	174.88	173.33	174.365	7527809.0
2022-02-02 12:00:00	AAPL	Stock	174.3638	175.05	174.06	175.0202	5148529.0
2022-02-02 13:00:00	AAPL	Stock	175.02	175.05	174.3	174.77	4477547.0
2022-02-02 14:00:00	AAPL	Stock	174.7791	175.37	174.29	175.0626	6351518.0
2022-02-02 15:00:00	AAPL	Stock	175.06	175.88	174.86	175.83	11450984.0
2022-02-02 16:00:00	AAPL	Stock	175.83	175.84	174.0	174.81	9028333.0
2022-02-02 17:00:00	AAPL	Stock	174.76	174.76	174.1	174.35	2849681.0
2022-02-02 18:00:00	AAPL	Stock	174.48	174.81	173.45	173.54	166055.0
2022-02-02 19:00:00	AAPL	Stock	173.51	174.25	173.5	173.75	90712.0
2022-02-02 04:00:00	MSFT	Stock	309.14	310.7	308.26	310.64	21932.0
2022-02-02 05:00:00	MSFT	Stock	310.44	310.45	309.8	309.8	5545.0
2022-02-02 06:00:00	MSFT	Stock	310.0	310.5	309.44	310.47	6763.0
2022-02-02 07:00:00	MSFT	Stock	310.5	310.93	309.85	310.89	74812.0
2022-02-02 08:00:00	MSFT	Stock	310.5999	310.9	308.76	309.6	784350.0
2022-02-02 09:00:00	MSFT	Stock	309.5	313.8414	308.76	313.65	3899122.0
2022-02-02 10:00:00	MSFT	Stock	313.74	315.12	311.68	312.35	4419526.0
2022-02-02 11:00:00	MSFT	Stock	312.37	312.6599	309.55	311.11	2551440.0
2022-02-02 12:00:00	MSFT	Stock	311.11	312.71	310.53	312.645	1943435.0
2022-02-02 13:00:00	MSFT	Stock	312.64	312.67	310.85	311.69	1601754.0
2022-02-02 14:00:00	MSFT	Stock	311.68	313.26	311.29	312.7026	2019719.0
2022-02-02 15:00:00	MSFT	Stock	312.65	314.08	312.26	313.39	3833921.0
2022-02-02 16:00:00	MSFT	Stock	313.46	313.46	309.8	311.52	4253288.0
2022-02-02 17:00:00	MSFT	Stock	311.23	311.39	310.56	310.94	53684.0
2022-02-02 18:00:00	MSFT	Stock	310.94	311.85	309.25	309.34	45653.0
2022-02-02 19:00:00	MSFT	Stock	309.57	311.0	309.4	310.11	22817.0
2022-02-02 04:00:00	NVDA	Stock	25.8	26.02	25.724	26.02	357630.0
2022-02-02 05:00:00	NVDA	Stock	26.001	26.06	25.892	25.892	246390.0
2022-02-02 06:00:00	NVDA	Stock	25.9	25.95	25.8	25.925	163370.0
2022-02-02 07:00:00	NVDA	Stock	25.93	26.044	25.871	26.03	1182850.0
2022-02-02 08:00:00	NVDA	Stock	25.98	26.08	24.638	25.922	5608260.0
2022-02-02 09:00:00	NVDA	Stock	25.931	25.975	24.638	25.301	78157690.0
2022-02-02 10:00:00	NVDA	Stock	25.302	25.817	25.114	25.198	70612990.0
2022-02-02 11:00:00	NVDA	Stock	25.187	25.245	24.553	24.797	57111670.0
2022-02-02 12:00:00	NVDA	Stock	24.791	25.128	24.68	25.1188	37221230.0
2022-02-02 13:00:00	NVDA	Stock	25.116	25.159	24.886	24.929	30779770.0
2022-02-02 14:00:00	NVDA	Stock	24.929	25.242	24.818	25.135	34977480.0
2022-02-02 15:00:00	NVDA	Stock	25.134	25.328	25.047	25.246	51294330.0
2022-02-02 16:00:00	NVDA	Stock	25.246	25.3	24.319	24.646	25288650.0
2022-02-02 17:00:00	NVDA	Stock	24.636	24.69	24.377	24.4	818270.0
2022-02-02 18:00:00	NVDA	Stock	24.4	24.58	24.177	24.177	922860.0
2022-02-02 19:00:00	NVDA	Stock	24.2	24.279	24.111	24.25	1136120.0
2022-02-02 04:00:00	AMZN	Stock	155.2	155.5	155.2	155.5	14900.0
2022-02-02 06:00:00	AMZN	Stock	154.75	154.75	154.75	154.75	2000.0

> showing 50 of 65,138 rows — these rows as CSV

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