PREVIEW / stock_1hour / 2023-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-27.parquet
  size:    1.3 MB
  rows:    59,566
  symbols: 1,336

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
2023-11-27 04:00:00	AAPL	Stock	189.6	189.6	189.2	189.28	10071.0
2023-11-27 05:00:00	AAPL	Stock	189.27	189.51	189.27	189.51	2778.0
2023-11-27 06:00:00	AAPL	Stock	189.55	189.55	189.38	189.4	3778.0
2023-11-27 07:00:00	AAPL	Stock	189.4	189.7	189.39	189.63	17435.0
2023-11-27 08:00:00	AAPL	Stock	189.67	190.07	188.9	189.61	96590.0
2023-11-27 09:00:00	AAPL	Stock	189.6634	190.39	188.9	189.25	4004904.0
2023-11-27 10:00:00	AAPL	Stock	189.25	189.91	189.01	189.335	4030491.0
2023-11-27 11:00:00	AAPL	Stock	189.33	190.42	189.045	190.27	3843744.0
2023-11-27 12:00:00	AAPL	Stock	190.27	190.51	190.205	190.45	2525195.0
2023-11-27 13:00:00	AAPL	Stock	190.459	190.67	190.02	190.12	2747255.0
2023-11-27 14:00:00	AAPL	Stock	190.13	190.19	189.52	189.885	2216745.0
2023-11-27 15:00:00	AAPL	Stock	189.885	190.06	189.605	189.78	5151243.0
2023-11-27 16:00:00	AAPL	Stock	189.78	190.14	189.78	189.95	7103368.0
2023-11-27 17:00:00	AAPL	Stock	189.95	190.1	189.91	190.08	38663.0
2023-11-27 18:00:00	AAPL	Stock	190.05	190.2	190.05	190.16	27473.0
2023-11-27 19:00:00	AAPL	Stock	190.13	190.17	189.88	190.15	17493.0
2023-11-27 04:00:00	MSFT	Stock	377.0	377.85	376.8	376.8	1897.0
2023-11-27 05:00:00	MSFT	Stock	376.9	377.28	376.9	377.28	462.0
2023-11-27 06:00:00	MSFT	Stock	377.0	377.0	376.7	376.7	718.0
2023-11-27 07:00:00	MSFT	Stock	376.8	377.3	376.31	376.34	11379.0
2023-11-27 08:00:00	MSFT	Stock	376.8887	377.43	376.01	376.22	30726.0
2023-11-27 09:00:00	MSFT	Stock	376.33	378.18	376.01	377.63	1576737.0
2023-11-27 10:00:00	MSFT	Stock	377.66	378.145	376.82	377.975	1540093.0
2023-11-27 11:00:00	MSFT	Stock	377.95	379.0595	377.25	379.02	1344262.0
2023-11-27 12:00:00	MSFT	Stock	379.04	380.59	378.94	380.3505	1972887.0
2023-11-27 13:00:00	MSFT	Stock	380.36	380.64	379.39	379.725	1175929.0
2023-11-27 14:00:00	MSFT	Stock	379.73	379.8675	378.23	379.11	1078570.0
2023-11-27 15:00:00	MSFT	Stock	379.095	379.2999	378.4	378.61	2231049.0
2023-11-27 16:00:00	MSFT	Stock	378.61	378.71	378.15	378.26	4002618.0
2023-11-27 17:00:00	MSFT	Stock	378.28	378.44	378.26	378.37	5369.0
2023-11-27 18:00:00	MSFT	Stock	378.35	379.27	378.35	379.1799	15183.0
2023-11-27 19:00:00	MSFT	Stock	379.0	379.18	378.58	378.85	6559.0
2023-11-27 04:00:00	NVDA	Stock	47.402	47.7	47.402	47.58	261160.0
2023-11-27 05:00:00	NVDA	Stock	47.581	47.662	47.581	47.662	49290.0
2023-11-27 06:00:00	NVDA	Stock	47.623	47.68	47.585	47.605	134900.0
2023-11-27 07:00:00	NVDA	Stock	47.6	47.874	47.577	47.81	627310.0
2023-11-27 08:00:00	NVDA	Stock	47.64	47.96	47.35	47.743	1932230.0
2023-11-27 09:00:00	NVDA	Stock	47.764	48.27	47.6	48.135	61572320.0
2023-11-27 10:00:00	NVDA	Stock	48.138	48.321	48.052	48.12	51677810.0
2023-11-27 11:00:00	NVDA	Stock	48.111	48.151	47.867	48.101	34414440.0
2023-11-27 12:00:00	NVDA	Stock	48.095	48.37	48.056	48.3685	30364880.0
2023-11-27 13:00:00	NVDA	Stock	48.3681	48.53	48.322	48.337	36170460.0
2023-11-27 14:00:00	NVDA	Stock	48.336	48.446	48.173	48.2805	28173240.0
2023-11-27 15:00:00	NVDA	Stock	48.28	48.4265	48.164	48.233	38524800.0
2023-11-27 16:00:00	NVDA	Stock	48.247	48.279	48.13	48.19	23937510.0
2023-11-27 17:00:00	NVDA	Stock	48.198	48.239	48.175	48.205	130150.0
2023-11-27 18:00:00	NVDA	Stock	48.21	48.223	48.187	48.187	178110.0
2023-11-27 19:00:00	NVDA	Stock	48.198	48.198	48.136	48.155	396230.0
2023-11-27 04:00:00	AMZN	Stock	146.9	147.1	146.65	146.65	10043.0
2023-11-27 05:00:00	AMZN	Stock	146.75	147.45	146.75	147.45	11610.0

> showing 50 of 59,566 rows — these rows as CSV

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