PREVIEW / stock_1hour / 2020-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-24.parquet
  size:    1.3 MB
  rows:    57,452
  symbols: 2,447

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-06-24 04:00:00	AAPL	Stock	91.425	91.55	90.875	91.1825	48636.0
2020-06-24 05:00:00	AAPL	Stock	91.1725	91.3	90.65	91.0	50472.0
2020-06-24 06:00:00	AAPL	Stock	91.115	91.1425	90.9525	91.125	37004.0
2020-06-24 07:00:00	AAPL	Stock	91.0525	91.3	91.0325	91.1375	339612.0
2020-06-24 08:00:00	AAPL	Stock	91.1725	91.75	91.04	91.715	739704.0
2020-06-24 09:00:00	AAPL	Stock	91.7125	92.1975	90.775	90.8675	25057072.0
2020-06-24 10:00:00	AAPL	Stock	90.8725	91.3725	90.57	90.7512	25499008.0
2020-06-24 11:00:00	AAPL	Stock	90.74	91.02	89.63	89.995	25292236.0
2020-06-24 12:00:00	AAPL	Stock	89.98	90.8123	89.7925	90.724	17377912.0
2020-06-24 13:00:00	AAPL	Stock	90.72	90.9555	90.0375	90.2625	16600876.0
2020-06-24 14:00:00	AAPL	Stock	90.255	90.525	89.8225	89.9562	16638252.0
2020-06-24 15:00:00	AAPL	Stock	89.965	90.5925	89.875	90.015	21142484.0
2020-06-24 16:00:00	AAPL	Stock	90.015	90.1725	89.9875	90.135	8213984.0
2020-06-24 17:00:00	AAPL	Stock	90.1375	90.17	90.0425	90.1125	52928.0
2020-06-24 18:00:00	AAPL	Stock	90.0625	90.2	90.0	90.0	101896.0
2020-06-24 19:00:00	AAPL	Stock	89.975	90.0	89.65	89.7375	148132.0
2020-06-24 04:00:00	MSFT	Stock	201.49	201.78	200.86	201.2	4229.0
2020-06-24 05:00:00	MSFT	Stock	201.21	201.21	200.2	200.92	5413.0
2020-06-24 06:00:00	MSFT	Stock	200.92	201.2	200.92	201.2	1996.0
2020-06-24 07:00:00	MSFT	Stock	201.0	201.5	200.74	201.22	34352.0
2020-06-24 08:00:00	MSFT	Stock	201.029	202.0	200.74	201.6	49522.0
2020-06-24 09:00:00	MSFT	Stock	201.6	203.25	199.78	200.14	3988202.0
2020-06-24 10:00:00	MSFT	Stock	200.08	200.76	198.74	199.345	4973186.0
2020-06-24 11:00:00	MSFT	Stock	199.33	199.67	196.73	197.46	4384287.0
2020-06-24 12:00:00	MSFT	Stock	197.46	198.75	196.62	198.66	2998993.0
2020-06-24 13:00:00	MSFT	Stock	198.65	199.0	197.05	197.67	2338539.0
2020-06-24 14:00:00	MSFT	Stock	197.63	198.03	196.56	197.19	2403974.0
2020-06-24 15:00:00	MSFT	Stock	197.21	198.68	197.21	197.84	4159884.0
2020-06-24 16:00:00	MSFT	Stock	197.84	198.26	197.33	198.2	4596052.0
2020-06-24 17:00:00	MSFT	Stock	198.3	198.45	198.2	198.39	16981.0
2020-06-24 18:00:00	MSFT	Stock	198.41	198.41	198.0	198.0	13499.0
2020-06-24 19:00:00	MSFT	Stock	198.0	198.15	197.63	197.65	15153.0
2020-06-24 04:00:00	NVDA	Stock	9.425	9.425	9.425	9.425	20640.0
2020-06-24 06:00:00	NVDA	Stock	9.4	9.4125	9.4	9.4088	15840.0
2020-06-24 07:00:00	NVDA	Stock	9.4138	9.5455	9.4065	9.5118	1187000.0
2020-06-24 08:00:00	NVDA	Stock	9.4919	9.5323	9.4065	9.5051	1386400.0
2020-06-24 09:00:00	NVDA	Stock	9.51	9.5564	9.3632	9.385	81665440.0
2020-06-24 10:00:00	NVDA	Stock	9.386	9.4222	9.3192	9.36	58811480.0
2020-06-24 11:00:00	NVDA	Stock	9.3578	9.3595	9.1445	9.2118	70741440.0
2020-06-24 12:00:00	NVDA	Stock	9.2108	9.3006	9.1805	9.2938	36121560.0
2020-06-24 13:00:00	NVDA	Stock	9.296	9.3225	9.2202	9.2532	36549240.0
2020-06-24 14:00:00	NVDA	Stock	9.2519	9.2868	9.1848	9.2327	30871040.0
2020-06-24 15:00:00	NVDA	Stock	9.2355	9.3132	9.2238	9.2355	59962160.0
2020-06-24 16:00:00	NVDA	Stock	9.2355	9.27	9.2238	9.2625	22312800.0
2020-06-24 17:00:00	NVDA	Stock	9.265	9.265	9.2608	9.2608	124640.0
2020-06-24 18:00:00	NVDA	Stock	9.2622	9.2622	9.239	9.2562	227640.0
2020-06-24 19:00:00	NVDA	Stock	9.2438	9.246	9.2088	9.21	384080.0
2020-06-24 04:00:00	AMZN	Stock	138.2205	138.25	137.937	138.25	8000.0
2020-06-24 05:00:00	AMZN	Stock	138.25	138.25	138.1105	138.228	22240.0
2020-06-24 06:00:00	AMZN	Stock	138.2	138.2565	138.2	138.2565	8580.0

> showing 50 of 57,452 rows — these rows as CSV

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