PREVIEW / stock_1hour / 2020-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-27.parquet
  size:    963 KB
  rows:    41,206
  symbols: 2,578

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-11-27 04:00:00	AAPL	Stock	116.8	116.98	116.51	116.86	17820.0
2020-11-27 05:00:00	AAPL	Stock	116.8	116.87	116.74	116.87	4381.0
2020-11-27 06:00:00	AAPL	Stock	116.9	116.98	116.83	116.89	8892.0
2020-11-27 07:00:00	AAPL	Stock	116.86	116.96	116.6	116.7	126593.0
2020-11-27 08:00:00	AAPL	Stock	116.74	116.98	116.6	116.88	309169.0
2020-11-27 09:00:00	AAPL	Stock	116.88	117.3	116.3	116.98	10149045.0
2020-11-27 10:00:00	AAPL	Stock	116.99	117.49	116.675	117.07	11345420.0
2020-11-27 11:00:00	AAPL	Stock	117.06	117.18	116.66	116.86	7529123.0
2020-11-27 12:00:00	AAPL	Stock	116.868	116.92	116.22	116.6	9366453.0
2020-11-27 13:00:00	AAPL	Stock	116.65	116.65	116.4	116.45	2472365.0
2020-11-27 14:00:00	AAPL	Stock	116.42	116.59	116.35	116.46	70957.0
2020-11-27 15:00:00	AAPL	Stock	116.43	116.55	116.41	116.455	51515.0
2020-11-27 16:00:00	AAPL	Stock	116.46	116.53	116.44	116.44	32736.0
2020-11-27 04:00:00	MSFT	Stock	214.61	214.75	214.61	214.75	2093.0
2020-11-27 05:00:00	MSFT	Stock	214.75	214.75	214.69	214.69	710.0
2020-11-27 07:00:00	MSFT	Stock	214.77	214.92	214.4	214.65	11618.0
2020-11-27 08:00:00	MSFT	Stock	214.75	215.2	213.34	214.95	33683.0
2020-11-27 09:00:00	MSFT	Stock	214.801	215.22	214.04	214.42	1936142.0
2020-11-27 10:00:00	MSFT	Stock	214.42	216.27	214.41	215.82	2727542.0
2020-11-27 11:00:00	MSFT	Stock	215.82	216.19	214.93	215.08	2059921.0
2020-11-27 12:00:00	MSFT	Stock	215.08	215.49	214.7	215.29	2463074.0
2020-11-27 13:00:00	MSFT	Stock	215.35	215.39	214.88	215.2	2296254.0
2020-11-27 14:00:00	MSFT	Stock	215.012	215.18	215.0	215.12	4089.0
2020-11-27 15:00:00	MSFT	Stock	215.16	215.2	215.15	215.15	2260.0
2020-11-27 16:00:00	MSFT	Stock	215.12	215.24	215.01	215.24	4424.0
2020-11-27 05:00:00	NVDA	Stock	13.265	13.2678	13.265	13.2678	17200.0
2020-11-27 06:00:00	NVDA	Stock	13.258	13.2625	13.258	13.2625	15200.0
2020-11-27 07:00:00	NVDA	Stock	13.2625	13.3	13.2625	13.2938	284200.0
2020-11-27 08:00:00	NVDA	Stock	13.2709	13.3525	13.2625	13.348	1307880.0
2020-11-27 09:00:00	NVDA	Stock	13.341	13.4075	13.2697	13.2801	39222400.0
2020-11-27 10:00:00	NVDA	Stock	13.2805	13.3875	13.24	13.3411	30226120.0
2020-11-27 11:00:00	NVDA	Stock	13.3412	13.3432	13.1706	13.222	30031520.0
2020-11-27 12:00:00	NVDA	Stock	13.2245	13.28	13.2173	13.2668	29155680.0
2020-11-27 13:00:00	NVDA	Stock	13.2828	13.2828	13.2252	13.2565	8344440.0
2020-11-27 14:00:00	NVDA	Stock	13.2565	13.2613	13.2525	13.255	161680.0
2020-11-27 15:00:00	NVDA	Stock	13.2525	13.255	13.2525	13.255	77640.0
2020-11-27 16:00:00	NVDA	Stock	13.2505	13.255	13.2505	13.2548	59880.0
2020-11-27 04:00:00	AMZN	Stock	161.0005	161.0005	160.75	160.75	17940.0
2020-11-27 05:00:00	AMZN	Stock	160.75	160.75	160.5	160.5	4400.0
2020-11-27 07:00:00	AMZN	Stock	160.45	160.5765	160.295	160.35	54580.0
2020-11-27 08:00:00	AMZN	Stock	160.5499	161.0	159.2535	160.976	368080.0
2020-11-27 09:00:00	AMZN	Stock	160.997	160.997	159.5808	160.4448	10579500.0
2020-11-27 10:00:00	AMZN	Stock	160.4465	160.752	159.7505	160.715	5338020.0
2020-11-27 11:00:00	AMZN	Stock	160.7443	160.7443	159.78	159.8387	5859900.0
2020-11-27 12:00:00	AMZN	Stock	159.8655	160.249	159.5025	159.7975	7983500.0
2020-11-27 13:00:00	AMZN	Stock	159.7975	159.857	159.65	159.8	1695140.0
2020-11-27 14:00:00	AMZN	Stock	159.8165	159.9	159.767	159.767	53960.0
2020-11-27 15:00:00	AMZN	Stock	159.9	159.9	159.9	159.9	6000.0
2020-11-27 16:00:00	AMZN	Stock	159.95	159.95	159.8	159.8	29600.0
2020-11-27 07:00:00	GOOGL	Stock	88.5	88.5	88.5	88.5	9940.0

> showing 50 of 41,206 rows — these rows as CSV

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