PREVIEW / stock_1hour / 2021-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-05.parquet
  size:    1.5 MB
  rows:    69,290
  symbols: 2,880

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
2021-03-05 04:00:00	AAPL	Stock	119.6	119.75	119.21	119.39	36711.0
2021-03-05 05:00:00	AAPL	Stock	119.39	119.7	119.0	119.57	20252.0
2021-03-05 06:00:00	AAPL	Stock	119.53	120.49	119.53	119.82	69093.0
2021-03-05 07:00:00	AAPL	Stock	119.81	120.4	119.62	120.29	346753.0
2021-03-05 08:00:00	AAPL	Stock	120.27	120.51	119.3	120.23	1454844.0
2021-03-05 09:00:00	AAPL	Stock	120.23	121.67	118.62	119.15	16863494.0
2021-03-05 10:00:00	AAPL	Stock	119.15	120.02	118.38	118.94	21748643.0
2021-03-05 11:00:00	AAPL	Stock	118.95	119.3199	117.57	119.0	19782601.0
2021-03-05 12:00:00	AAPL	Stock	119.01	119.72	118.5599	119.21	14316121.0
2021-03-05 13:00:00	AAPL	Stock	119.2	120.7	118.46	120.28	14361271.0
2021-03-05 14:00:00	AAPL	Stock	120.281	121.4699	119.635	121.34	12180533.0
2021-03-05 15:00:00	AAPL	Stock	121.34	121.935	120.86	121.39	19309932.0
2021-03-05 16:00:00	AAPL	Stock	121.42	121.42	120.415	121.3	8821596.0
2021-03-05 17:00:00	AAPL	Stock	121.26	121.48	121.25	121.41	66521.0
2021-03-05 18:00:00	AAPL	Stock	121.4	121.49	121.36	121.46	79071.0
2021-03-05 19:00:00	AAPL	Stock	121.48	121.49	121.36	121.49	93753.0
2021-03-05 04:00:00	MSFT	Stock	226.32	226.32	225.27	225.27	1152.0
2021-03-05 05:00:00	MSFT	Stock	225.3	225.8	225.3	225.8	1654.0
2021-03-05 06:00:00	MSFT	Stock	226.36	227.02	226.02	226.02	5081.0
2021-03-05 07:00:00	MSFT	Stock	226.13	227.67	226.13	227.53	15637.0
2021-03-05 08:00:00	MSFT	Stock	227.68	227.91	225.01	227.25	91491.0
2021-03-05 09:00:00	MSFT	Stock	227.414	229.88	227.35	228.12	3237622.0
2021-03-05 10:00:00	MSFT	Stock	228.105	229.6	226.66	226.78	3913319.0
2021-03-05 11:00:00	MSFT	Stock	226.79	228.74	226.46	228.615	3207695.0
2021-03-05 12:00:00	MSFT	Stock	228.59	232.42	228.2012	232.28	4405415.0
2021-03-05 13:00:00	MSFT	Stock	232.28	232.91	230.74	232.248	3169344.0
2021-03-05 14:00:00	MSFT	Stock	232.28	233.165	230.79	233.02	2752903.0
2021-03-05 15:00:00	MSFT	Stock	233.02	233.27	231.51	231.58	4321411.0
2021-03-05 16:00:00	MSFT	Stock	231.6	231.91	231.25	231.4	3938740.0
2021-03-05 17:00:00	MSFT	Stock	231.5	232.49	231.36	232.25	58316.0
2021-03-05 18:00:00	MSFT	Stock	232.26	232.4	232.02	232.22	19943.0
2021-03-05 19:00:00	MSFT	Stock	232.23	232.23	232.04	232.23	9841.0
2021-03-05 04:00:00	NVDA	Stock	12.1695	12.331	12.1695	12.3025	20960.0
2021-03-05 05:00:00	NVDA	Stock	12.2785	12.2785	12.2785	12.2785	4000.0
2021-03-05 06:00:00	NVDA	Stock	12.3055	12.375	12.3055	12.3552	23720.0
2021-03-05 07:00:00	NVDA	Stock	12.35	12.375	12.2305	12.375	289400.0
2021-03-05 08:00:00	NVDA	Stock	12.3002	12.475	12.15	12.425	1859560.0
2021-03-05 09:00:00	NVDA	Stock	12.425	12.5735	12.0528	12.1408	47228160.0
2021-03-05 10:00:00	NVDA	Stock	12.142	12.262	11.896	11.962	46489080.0
2021-03-05 11:00:00	NVDA	Stock	11.9582	11.9864	11.6793	11.9761	58188560.0
2021-03-05 12:00:00	NVDA	Stock	11.9735	12.3125	11.9218	12.2835	38952320.0
2021-03-05 13:00:00	NVDA	Stock	12.2803	12.459	12.1798	12.3928	33694160.0
2021-03-05 14:00:00	NVDA	Stock	12.4	12.4968	12.2942	12.4708	32733520.0
2021-03-05 15:00:00	NVDA	Stock	12.4775	12.5059	12.405	12.462	33064440.0
2021-03-05 16:00:00	NVDA	Stock	12.4615	12.4865	12.45	12.485	25654600.0
2021-03-05 17:00:00	NVDA	Stock	12.485	12.4998	12.4672	12.4998	242560.0
2021-03-05 18:00:00	NVDA	Stock	12.5	12.6	12.485	12.5972	414640.0
2021-03-05 19:00:00	NVDA	Stock	12.55	12.5975	12.55	12.5625	130840.0
2021-03-05 04:00:00	AMZN	Stock	148.8445	148.8445	148.8445	148.8445	2000.0
2021-03-05 06:00:00	AMZN	Stock	149.0	150.0	149.0	149.9635	41140.0

> showing 50 of 69,290 rows — these rows as CSV

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