PREVIEW / stock_1hour / 2020-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-03.parquet
  size:    1.2 MB
  rows:    56,810
  symbols: 2,394

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-03 04:00:00	AAPL	Stock	81.125	81.4125	81.075	81.275	39216.0
2020-06-03 05:00:00	AAPL	Stock	81.345	81.3725	81.275	81.3725	11460.0
2020-06-03 06:00:00	AAPL	Stock	81.26	81.315	81.2025	81.22	60160.0
2020-06-03 07:00:00	AAPL	Stock	81.195	81.3125	81.075	81.25	248660.0
2020-06-03 08:00:00	AAPL	Stock	81.1718	81.3125	80.875	81.045	470596.0
2020-06-03 09:00:00	AAPL	Stock	81.0075	81.2525	80.615	81.1082	14079136.0
2020-06-03 10:00:00	AAPL	Stock	81.1125	81.2075	80.765	80.9802	11227300.0
2020-06-03 11:00:00	AAPL	Stock	80.9775	81.1475	80.835	80.9225	7305988.0
2020-06-03 12:00:00	AAPL	Stock	80.9125	80.985	80.575	80.8275	7307672.0
2020-06-03 13:00:00	AAPL	Stock	80.8275	81.1025	80.7875	80.995	6227648.0
2020-06-03 14:00:00	AAPL	Stock	80.9925	81.25	80.965	81.1325	9788264.0
2020-06-03 15:00:00	AAPL	Stock	81.1332	81.55	81.0625	81.2725	19601676.0
2020-06-03 16:00:00	AAPL	Stock	81.28	81.28	81.0288	81.1675	10071176.0
2020-06-03 17:00:00	AAPL	Stock	81.195	81.2225	81.1675	81.2225	11940.0
2020-06-03 18:00:00	AAPL	Stock	81.21	81.21	81.105	81.1975	31536.0
2020-06-03 19:00:00	AAPL	Stock	81.21	81.3	81.1875	81.3	36268.0
2020-06-03 04:00:00	MSFT	Stock	185.16	185.3	184.94	185.25	2563.0
2020-06-03 05:00:00	MSFT	Stock	185.31	185.7	185.2	185.59	2111.0
2020-06-03 06:00:00	MSFT	Stock	185.16	185.55	185.13	185.2	5696.0
2020-06-03 07:00:00	MSFT	Stock	185.5	185.5	185.0	185.21	31455.0
2020-06-03 08:00:00	MSFT	Stock	185.145	185.47	184.13	184.5	87513.0
2020-06-03 09:00:00	MSFT	Stock	184.501	185.15	183.61	184.56	3268444.0
2020-06-03 10:00:00	MSFT	Stock	184.57	184.73	183.625	184.14	3235981.0
2020-06-03 11:00:00	MSFT	Stock	184.143	184.51	183.93	184.365	2451924.0
2020-06-03 12:00:00	MSFT	Stock	184.36	184.45	183.58	184.13	2235686.0
2020-06-03 13:00:00	MSFT	Stock	184.13	184.82	184.06	184.52	1481187.0
2020-06-03 14:00:00	MSFT	Stock	184.524	185.14	184.48	184.995	2503981.0
2020-06-03 15:00:00	MSFT	Stock	184.999	185.94	184.83	185.36	4357973.0
2020-06-03 16:00:00	MSFT	Stock	185.1	185.36	184.8	184.81	4061873.0
2020-06-03 17:00:00	MSFT	Stock	184.89	184.9	184.71	184.71	10135.0
2020-06-03 18:00:00	MSFT	Stock	184.77	184.77	184.37	184.55	17647.0
2020-06-03 19:00:00	MSFT	Stock	184.56	185.18	184.56	184.9	12458.0
2020-06-03 04:00:00	NVDA	Stock	8.875	8.875	8.8578	8.8578	15880.0
2020-06-03 06:00:00	NVDA	Stock	8.8828	8.8828	8.8828	8.8828	4000.0
2020-06-03 07:00:00	NVDA	Stock	8.8625	8.8625	8.8388	8.8625	208480.0
2020-06-03 08:00:00	NVDA	Stock	8.85	8.871	8.82	8.8375	1164520.0
2020-06-03 09:00:00	NVDA	Stock	8.84	8.8662	8.7756	8.8028	42058640.0
2020-06-03 10:00:00	NVDA	Stock	8.8039	8.8125	8.72	8.7515	52475560.0
2020-06-03 11:00:00	NVDA	Stock	8.7502	8.786	8.7125	8.7292	37749240.0
2020-06-03 12:00:00	NVDA	Stock	8.7285	8.7652	8.7	8.7368	30778320.0
2020-06-03 13:00:00	NVDA	Stock	8.7384	8.7726	8.7115	8.7272	23398160.0
2020-06-03 14:00:00	NVDA	Stock	8.7275	8.8002	8.7243	8.791	27266320.0
2020-06-03 15:00:00	NVDA	Stock	8.7925	8.816	8.748	8.7662	65938320.0
2020-06-03 16:00:00	NVDA	Stock	8.7695	8.7758	8.75	8.7638	16350880.0
2020-06-03 17:00:00	NVDA	Stock	8.7628	8.7675	8.7565	8.7662	156200.0
2020-06-03 18:00:00	NVDA	Stock	8.7595	8.76	8.7522	8.7538	165040.0
2020-06-03 19:00:00	NVDA	Stock	8.753	8.76	8.7375	8.75	480760.0
2020-06-03 04:00:00	AMZN	Stock	123.85	123.85	123.85	123.85	2040.0
2020-06-03 06:00:00	AMZN	Stock	124.0	124.0	123.975	123.975	9280.0
2020-06-03 07:00:00	AMZN	Stock	124.1	124.1	123.953	124.0	20480.0

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

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