PREVIEW / stock_1hour / 2022-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-08.parquet
  size:    1.4 MB
  rows:    63,108
  symbols: 2,563

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-08 04:00:00	AAPL	Stock	172.16	172.35	171.82	171.85	6589.0
2022-02-08 05:00:00	AAPL	Stock	171.82	172.4	171.66	172.2	10164.0
2022-02-08 06:00:00	AAPL	Stock	172.1	172.2	171.44	171.69	19764.0
2022-02-08 07:00:00	AAPL	Stock	171.7	171.85	171.37	171.8	84137.0
2022-02-08 08:00:00	AAPL	Stock	171.7999	172.32	171.4	171.8	314659.0
2022-02-08 09:00:00	AAPL	Stock	171.79	172.42	171.5	172.06	6673550.0
2022-02-08 10:00:00	AAPL	Stock	172.06	172.86	171.43	172.67	7833956.0
2022-02-08 11:00:00	AAPL	Stock	172.675	174.2	172.67	173.875	8083516.0
2022-02-08 12:00:00	AAPL	Stock	173.88	175.2779	173.69	174.65	8860516.0
2022-02-08 13:00:00	AAPL	Stock	174.65	174.795	174.121	174.5852	5993000.0
2022-02-08 14:00:00	AAPL	Stock	174.585	174.81	173.73	173.94	5968805.0
2022-02-08 15:00:00	AAPL	Stock	173.9416	175.35	173.635	174.82	12299282.0
2022-02-08 16:00:00	AAPL	Stock	174.82	175.09	174.48	174.75	6853858.0
2022-02-08 17:00:00	AAPL	Stock	174.75	174.89	174.73	174.76	65606.0
2022-02-08 18:00:00	AAPL	Stock	174.8	175.35	174.78	175.22	36068.0
2022-02-08 19:00:00	AAPL	Stock	175.25	175.25	174.8	175.17	30819.0
2022-02-08 04:00:00	MSFT	Stock	302.78	302.78	301.03	301.37	9608.0
2022-02-08 05:00:00	MSFT	Stock	301.03	302.36	301.03	302.15	8326.0
2022-02-08 06:00:00	MSFT	Stock	301.92	302.09	300.74	301.01	9964.0
2022-02-08 07:00:00	MSFT	Stock	301.4	301.4	300.05	301.39	21908.0
2022-02-08 08:00:00	MSFT	Stock	300.2794	302.09	300.18	301.7	58309.0
2022-02-08 09:00:00	MSFT	Stock	301.62	303.14	300.1	300.36	2294101.0
2022-02-08 10:00:00	MSFT	Stock	300.38	303.08	299.95	302.34	2838273.0
2022-02-08 11:00:00	MSFT	Stock	302.32	305.1242	302.28	304.395	2458350.0
2022-02-08 12:00:00	MSFT	Stock	304.4	305.53	303.64	304.63	1501101.0
2022-02-08 13:00:00	MSFT	Stock	304.62	304.74	303.37	304.7	1581663.0
2022-02-08 14:00:00	MSFT	Stock	304.8	305.07	303.14	303.47	1551350.0
2022-02-08 15:00:00	MSFT	Stock	303.42	305.561	302.8004	304.54	3446674.0
2022-02-08 16:00:00	MSFT	Stock	304.54	305.0	304.17	304.82	3486489.0
2022-02-08 17:00:00	MSFT	Stock	304.9	304.97	304.32	304.78	17995.0
2022-02-08 18:00:00	MSFT	Stock	304.74	305.7	304.74	305.2601	23868.0
2022-02-08 19:00:00	MSFT	Stock	305.58	305.58	304.8401	305.29	11549.0
2022-02-08 04:00:00	NVDA	Stock	24.759	24.781	24.271	24.42	204130.0
2022-02-08 05:00:00	NVDA	Stock	24.41	24.467	24.384	24.44	76870.0
2022-02-08 06:00:00	NVDA	Stock	24.42	24.42	24.188	24.256	79920.0
2022-02-08 07:00:00	NVDA	Stock	24.281	24.368	24.223	24.325	533510.0
2022-02-08 08:00:00	NVDA	Stock	24.34	24.524	24.22	24.432	1668320.0
2022-02-08 09:00:00	NVDA	Stock	24.434	24.821	24.2934	24.3175	38978770.0
2022-02-08 10:00:00	NVDA	Stock	24.3195	24.589	23.98	24.497	53985410.0
2022-02-08 11:00:00	NVDA	Stock	24.501	25.032	24.48	24.887	55932700.0
2022-02-08 12:00:00	NVDA	Stock	24.887	25.088	24.757	24.972	29545790.0
2022-02-08 13:00:00	NVDA	Stock	24.964	24.964	24.7331	24.807	22257330.0
2022-02-08 14:00:00	NVDA	Stock	24.807	24.9398	24.6174	24.839	25536650.0
2022-02-08 15:00:00	NVDA	Stock	24.8406	25.23	24.736	25.108	48699870.0
2022-02-08 16:00:00	NVDA	Stock	25.106	25.246	25.078	25.183	19915380.0
2022-02-08 17:00:00	NVDA	Stock	25.185	25.22	25.134	25.153	348110.0
2022-02-08 18:00:00	NVDA	Stock	25.166	25.324	25.155	25.324	358010.0
2022-02-08 19:00:00	NVDA	Stock	25.3	25.4	25.298	25.39	684130.0
2022-02-08 05:00:00	AMZN	Stock	157.9355	157.9355	157.9355	157.9355	2800.0
2022-02-08 06:00:00	AMZN	Stock	157.5185	157.5185	157.5185	157.5185	3600.0

> showing 50 of 63,108 rows — these rows as CSV

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