PREVIEW / stock_1hour / 2022-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-07.parquet
  size:    1.4 MB
  rows:    63,374
  symbols: 2,596

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-07 04:00:00	AAPL	Stock	172.39	172.68	171.8	172.44	16210.0
2022-02-07 05:00:00	AAPL	Stock	172.43	172.91	172.2	172.2	10605.0
2022-02-07 06:00:00	AAPL	Stock	172.2	172.81	172.16	172.74	3815.0
2022-02-07 07:00:00	AAPL	Stock	172.69	173.34	172.59	173.3	79204.0
2022-02-07 08:00:00	AAPL	Stock	172.9	173.7	172.35	173.22	230461.0
2022-02-07 09:00:00	AAPL	Stock	173.25	173.94	172.39	173.43	7586435.0
2022-02-07 10:00:00	AAPL	Stock	173.45	173.9458	172.82	172.995	7681716.0
2022-02-07 11:00:00	AAPL	Stock	173.0	173.19	171.73	172.065	6904158.0
2022-02-07 12:00:00	AAPL	Stock	172.06	172.44	171.53	171.87	4837757.0
2022-02-07 13:00:00	AAPL	Stock	171.86	172.72	171.74	172.6099	4071699.0
2022-02-07 14:00:00	AAPL	Stock	172.6186	172.83	171.97	172.605	4389027.0
2022-02-07 15:00:00	AAPL	Stock	172.6016	173.04	170.95	171.71	9548225.0
2022-02-07 16:00:00	AAPL	Stock	171.66	172.16	171.66	172.01	8266904.0
2022-02-07 17:00:00	AAPL	Stock	172.0	172.57	171.66	172.31	118225.0
2022-02-07 18:00:00	AAPL	Stock	172.42	172.58	172.2	172.43	37126.0
2022-02-07 19:00:00	AAPL	Stock	172.4	172.5	172.1	172.4	50750.0
2022-02-07 04:00:00	MSFT	Stock	305.7	305.7	304.77	305.5	3182.0
2022-02-07 05:00:00	MSFT	Stock	305.62	305.87	305.27	305.85	2441.0
2022-02-07 06:00:00	MSFT	Stock	305.81	305.81	305.81	305.81	243.0
2022-02-07 07:00:00	MSFT	Stock	305.75	306.9	305.75	306.9	8979.0
2022-02-07 08:00:00	MSFT	Stock	306.4584	311.01	305.85	307.09	30755.0
2022-02-07 09:00:00	MSFT	Stock	307.21	307.84	305.03	305.372	2179996.0
2022-02-07 10:00:00	MSFT	Stock	305.4	306.7552	304.72	305.32	2259710.0
2022-02-07 11:00:00	MSFT	Stock	305.31	305.53	302.3275	303.13	2154216.0
2022-02-07 12:00:00	MSFT	Stock	303.13	303.43	301.82	302.08	1795781.0
2022-02-07 13:00:00	MSFT	Stock	302.055	303.78	301.95	303.505	1594197.0
2022-02-07 14:00:00	MSFT	Stock	303.52	304.4	302.86	303.81	1404841.0
2022-02-07 15:00:00	MSFT	Stock	303.79	304.9	299.9	300.85	3856863.0
2022-02-07 16:00:00	MSFT	Stock	301.06	301.73	300.95	301.6	4053900.0
2022-02-07 17:00:00	MSFT	Stock	301.3	301.5	301.16	301.5	11881.0
2022-02-07 18:00:00	MSFT	Stock	301.45	301.73	301.3	301.73	17667.0
2022-02-07 19:00:00	MSFT	Stock	301.72	302.19	301.32	301.6001	17091.0
2022-02-07 04:00:00	NVDA	Stock	24.262	24.351	24.16	24.226	55470.0
2022-02-07 05:00:00	NVDA	Stock	24.225	24.317	24.22	24.317	26760.0
2022-02-07 06:00:00	NVDA	Stock	24.269	24.32	24.23	24.294	27270.0
2022-02-07 07:00:00	NVDA	Stock	24.296	24.549	24.28	24.5	538260.0
2022-02-07 08:00:00	NVDA	Stock	24.3632	24.642	24.3	24.51	593760.0
2022-02-07 09:00:00	NVDA	Stock	24.512	24.861	24.202	24.7979	34964750.0
2022-02-07 10:00:00	NVDA	Stock	24.799	24.888	24.4415	24.827	45171250.0
2022-02-07 11:00:00	NVDA	Stock	24.819	24.93	24.445	24.6355	31643380.0
2022-02-07 12:00:00	NVDA	Stock	24.633	24.795	24.555	24.737	25947040.0
2022-02-07 13:00:00	NVDA	Stock	24.737	25.06	24.701	24.935	34964080.0
2022-02-07 14:00:00	NVDA	Stock	24.9335	25.131	24.837	25.0287	30241340.0
2022-02-07 15:00:00	NVDA	Stock	25.0255	25.182	24.485	24.729	50274160.0
2022-02-07 16:00:00	NVDA	Stock	24.743	24.919	24.728	24.87	19750160.0
2022-02-07 17:00:00	NVDA	Stock	24.872	24.88	24.8	24.859	227660.0
2022-02-07 18:00:00	NVDA	Stock	24.864	24.987	24.82	24.973	478070.0
2022-02-07 19:00:00	NVDA	Stock	24.98	25.025	24.8	24.87	629170.0
2022-02-07 04:00:00	AMZN	Stock	157.883	157.883	157.6	157.6	5680.0
2022-02-07 05:00:00	AMZN	Stock	157.565	158.0495	157.565	158.0495	6000.0

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

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