PREVIEW / stock_1hour / 2021-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-07.parquet
  size:    1.4 MB
  rows:    64,437
  symbols: 2,721

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-10-07 04:00:00	AAPL	Stock	143.25	143.68	143.14	143.48	45140.0
2021-10-07 05:00:00	AAPL	Stock	143.38	143.5	143.3	143.41	6058.0
2021-10-07 06:00:00	AAPL	Stock	143.42	143.5	142.92	143.37	44393.0
2021-10-07 07:00:00	AAPL	Stock	143.38	143.85	143.26	143.7	195425.0
2021-10-07 08:00:00	AAPL	Stock	143.71	143.85	143.25	143.4	570641.0
2021-10-07 09:00:00	AAPL	Stock	143.4	143.85	142.72	143.845	10177555.0
2021-10-07 10:00:00	AAPL	Stock	143.845	144.215	143.78	144.0	9924525.0
2021-10-07 11:00:00	AAPL	Stock	144.01	144.15	143.545	144.12	6129164.0
2021-10-07 12:00:00	AAPL	Stock	144.13	144.14	143.625	144.045	4813165.0
2021-10-07 13:00:00	AAPL	Stock	144.04	144.17	143.91	143.9433	4471410.0
2021-10-07 14:00:00	AAPL	Stock	143.945	144.0	143.425	143.54	4956555.0
2021-10-07 15:00:00	AAPL	Stock	143.545	143.84	143.0	143.28	8736723.0
2021-10-07 16:00:00	AAPL	Stock	143.28	143.3072	142.98	143.2	4526779.0
2021-10-07 17:00:00	AAPL	Stock	143.25	143.27	143.16	143.19	15905.0
2021-10-07 18:00:00	AAPL	Stock	143.25	143.39	143.2	143.38	36432.0
2021-10-07 19:00:00	AAPL	Stock	143.38	143.59	143.3	143.55	63018.0
2021-10-07 04:00:00	MSFT	Stock	295.26	296.34	295.26	296.3	9117.0
2021-10-07 05:00:00	MSFT	Stock	296.15	296.25	295.85	295.85	1520.0
2021-10-07 06:00:00	MSFT	Stock	296.03	296.03	295.52	295.95	5794.0
2021-10-07 07:00:00	MSFT	Stock	295.86	296.48	295.85	296.15	55922.0
2021-10-07 08:00:00	MSFT	Stock	296.15	296.48	295.56	295.56	75196.0
2021-10-07 09:00:00	MSFT	Stock	295.66	296.3	293.92	295.39	2642458.0
2021-10-07 10:00:00	MSFT	Stock	295.41	296.53	295.13	296.38	2326502.0
2021-10-07 11:00:00	MSFT	Stock	296.38	296.64	295.41	296.37	1585196.0
2021-10-07 12:00:00	MSFT	Stock	296.37	296.56	295.76	296.51	1217130.0
2021-10-07 13:00:00	MSFT	Stock	296.5	296.53	295.35	295.53	1058015.0
2021-10-07 14:00:00	MSFT	Stock	295.51	295.62	294.62	294.97	1260822.0
2021-10-07 15:00:00	MSFT	Stock	294.96	295.93	294.51	294.94	2262378.0
2021-10-07 16:00:00	MSFT	Stock	294.85	295.07	294.51	294.88	3050611.0
2021-10-07 17:00:00	MSFT	Stock	294.93	294.93	294.76	294.88	2313.0
2021-10-07 18:00:00	MSFT	Stock	294.79	294.98	294.79	294.98	2632.0
2021-10-07 19:00:00	MSFT	Stock	294.98	295.85	294.97	295.85	6736.0
2021-10-07 04:00:00	NVDA	Stock	21.0	21.245	20.962	21.198	358630.0
2021-10-07 05:00:00	NVDA	Stock	21.187	21.19	21.125	21.125	47770.0
2021-10-07 06:00:00	NVDA	Stock	21.135	21.161	21.066	21.1	75840.0
2021-10-07 07:00:00	NVDA	Stock	21.105	21.233	21.061	21.192	931710.0
2021-10-07 08:00:00	NVDA	Stock	21.192	21.234	21.05	21.168	1290920.0
2021-10-07 09:00:00	NVDA	Stock	21.18	21.188	20.972	21.064	37608320.0
2021-10-07 10:00:00	NVDA	Stock	21.0643	21.241	21.023	21.15	40863700.0
2021-10-07 11:00:00	NVDA	Stock	21.151	21.322	21.11	21.3022	24754590.0
2021-10-07 12:00:00	NVDA	Stock	21.303	21.304	21.202	21.229	17383120.0
2021-10-07 13:00:00	NVDA	Stock	21.227	21.227	21.162	21.1865	15887030.0
2021-10-07 14:00:00	NVDA	Stock	21.185	21.201	21.112	21.1675	16792960.0
2021-10-07 15:00:00	NVDA	Stock	21.166	21.246	21.0421	21.075	30768720.0
2021-10-07 16:00:00	NVDA	Stock	21.075	21.099	21.005	21.024	19699220.0
2021-10-07 17:00:00	NVDA	Stock	21.024	21.047	21.005	21.045	67720.0
2021-10-07 18:00:00	NVDA	Stock	21.04	21.05	21.027	21.047	34320.0
2021-10-07 19:00:00	NVDA	Stock	21.075	21.14	21.05	21.122	407410.0
2021-10-07 04:00:00	AMZN	Stock	164.75	164.9	164.6	164.9	14680.0
2021-10-07 05:00:00	AMZN	Stock	164.85	164.85	164.8	164.8	5900.0

> showing 50 of 64,437 rows — these rows as CSV

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