PREVIEW / stock_1hour / 2020-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-07.parquet
  size:    1.2 MB
  rows:    56,338
  symbols: 2,424

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
2020-07-07 04:00:00	AAPL	Stock	93.25	93.305	93.035	93.1125	23952.0
2020-07-07 05:00:00	AAPL	Stock	93.0125	93.15	92.925	93.0225	25932.0
2020-07-07 06:00:00	AAPL	Stock	93.0225	93.075	93.0225	93.075	7872.0
2020-07-07 07:00:00	AAPL	Stock	93.1225	93.5825	93.06	93.5475	163480.0
2020-07-07 08:00:00	AAPL	Stock	93.266	93.7125	93.075	93.645	417612.0
2020-07-07 09:00:00	AAPL	Stock	93.6375	94.225	93.5	93.9762	13581660.0
2020-07-07 10:00:00	AAPL	Stock	93.9575	94.655	93.8075	94.52	16524280.0
2020-07-07 11:00:00	AAPL	Stock	94.5188	94.625	94.25	94.4075	8317716.0
2020-07-07 12:00:00	AAPL	Stock	94.42	94.4675	93.8575	94.1525	9333340.0
2020-07-07 13:00:00	AAPL	Stock	94.145	94.215	93.7975	93.96	6685536.0
2020-07-07 14:00:00	AAPL	Stock	93.955	94.0025	93.7125	93.8675	8340928.0
2020-07-07 15:00:00	AAPL	Stock	93.865	93.9375	93.0575	93.16	15396644.0
2020-07-07 16:00:00	AAPL	Stock	93.1725	93.3625	93.1125	93.3225	10011596.0
2020-07-07 17:00:00	AAPL	Stock	93.3375	93.3625	93.2125	93.325	75460.0
2020-07-07 18:00:00	AAPL	Stock	93.3925	93.61	93.3875	93.525	51044.0
2020-07-07 19:00:00	AAPL	Stock	93.55	93.75	93.54	93.7275	91996.0
2020-07-07 04:00:00	MSFT	Stock	210.74	210.74	209.51	209.51	2874.0
2020-07-07 05:00:00	MSFT	Stock	210.0	210.0	209.57	209.65	8271.0
2020-07-07 06:00:00	MSFT	Stock	209.69	210.02	209.65	209.83	2237.0
2020-07-07 07:00:00	MSFT	Stock	210.0	210.35	209.92	210.27	35489.0
2020-07-07 08:00:00	MSFT	Stock	210.0	211.22	209.92	210.36	51911.0
2020-07-07 09:00:00	MSFT	Stock	210.4	212.33	210.2	211.9	3028252.0
2020-07-07 10:00:00	MSFT	Stock	211.9	214.67	211.61	214.17	4802690.0
2020-07-07 11:00:00	MSFT	Stock	214.17	214.395	212.85	212.98	2269697.0
2020-07-07 12:00:00	MSFT	Stock	213.0	213.23	211.83	212.975	2318203.0
2020-07-07 13:00:00	MSFT	Stock	212.961	212.98	211.53	211.932	2184664.0
2020-07-07 14:00:00	MSFT	Stock	211.92	212.2	210.88	211.371	2539191.0
2020-07-07 15:00:00	MSFT	Stock	211.38	211.39	207.99	208.24	6821863.0
2020-07-07 16:00:00	MSFT	Stock	208.23	212.184	208.23	208.58	4170360.0
2020-07-07 17:00:00	MSFT	Stock	208.66	208.7	208.5	208.55	19054.0
2020-07-07 18:00:00	MSFT	Stock	208.66	209.23	208.58	208.99	23379.0
2020-07-07 19:00:00	MSFT	Stock	209.0	209.6	208.95	209.1	47815.0
2020-07-07 04:00:00	NVDA	Stock	9.8235	9.8235	9.7748	9.7748	60600.0
2020-07-07 05:00:00	NVDA	Stock	9.775	9.79	9.775	9.775	64520.0
2020-07-07 06:00:00	NVDA	Stock	9.775	9.775	9.775	9.775	4040.0
2020-07-07 07:00:00	NVDA	Stock	9.7743	9.8623	9.7598	9.8598	714640.0
2020-07-07 08:00:00	NVDA	Stock	9.7563	9.9438	9.75	9.925	1750440.0
2020-07-07 09:00:00	NVDA	Stock	9.925	10.041	9.9062	9.9857	61783840.0
2020-07-07 10:00:00	NVDA	Stock	9.9875	10.0213	9.9125	10.0148	48707480.0
2020-07-07 11:00:00	NVDA	Stock	10.015	10.07	10.007	10.0305	33353800.0
2020-07-07 12:00:00	NVDA	Stock	10.031	10.0428	9.9505	10.0026	27768760.0
2020-07-07 13:00:00	NVDA	Stock	10.0026	10.0082	9.9505	9.9721	20517440.0
2020-07-07 14:00:00	NVDA	Stock	9.9708	9.992	9.931	9.9705	25149680.0
2020-07-07 15:00:00	NVDA	Stock	9.9705	9.975	9.8508	9.8648	44408120.0
2020-07-07 16:00:00	NVDA	Stock	9.865	9.9	9.8515	9.885	18980640.0
2020-07-07 17:00:00	NVDA	Stock	9.8912	9.895	9.868	9.8938	283560.0
2020-07-07 18:00:00	NVDA	Stock	9.8938	9.9005	9.8875	9.8988	268480.0
2020-07-07 19:00:00	NVDA	Stock	9.8985	9.9158	9.8985	9.9158	525960.0
2020-07-07 04:00:00	AMZN	Stock	152.762	152.8	152.3	152.3	14920.0
2020-07-07 05:00:00	AMZN	Stock	152.3	152.4	152.05	152.4	76820.0

> showing 50 of 56,338 rows — these rows as CSV

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