PREVIEW / stock_1hour / 2020-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-10.parquet
  size:    1.3 MB
  rows:    58,457
  symbols: 2,451

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-08-10 04:00:00	AAPL	Stock	111.625	111.7	111.35	111.7	26652.0
2020-08-10 05:00:00	AAPL	Stock	111.7375	111.9625	111.6875	111.925	28692.0
2020-08-10 06:00:00	AAPL	Stock	111.8775	112.0	111.75	111.9	34072.0
2020-08-10 07:00:00	AAPL	Stock	111.95	112.4975	111.85	112.485	581756.0
2020-08-10 08:00:00	AAPL	Stock	112.18	113.1125	111.9	112.965	1632224.0
2020-08-10 09:00:00	AAPL	Stock	112.95	113.775	111.965	112.427	34190496.0
2020-08-10 10:00:00	AAPL	Stock	112.4375	112.685	110.305	110.33	29980144.0
2020-08-10 11:00:00	AAPL	Stock	110.329	112.275	110.0	112.0592	27636916.0
2020-08-10 12:00:00	AAPL	Stock	112.0725	112.9675	111.81	112.685	20986536.0
2020-08-10 13:00:00	AAPL	Stock	112.6875	112.975	112.29	112.4888	13776864.0
2020-08-10 14:00:00	AAPL	Stock	112.4888	113.205	112.405	113.1325	14143608.0
2020-08-10 15:00:00	AAPL	Stock	113.13	113.245	112.395	112.735	20992360.0
2020-08-10 16:00:00	AAPL	Stock	112.735	112.8	112.324	112.7025	6175592.0
2020-08-10 17:00:00	AAPL	Stock	112.7025	112.72	112.4	112.435	162768.0
2020-08-10 18:00:00	AAPL	Stock	112.415	112.4625	112.375	112.4125	91000.0
2020-08-10 19:00:00	AAPL	Stock	112.4225	112.4925	112.4	112.4775	128356.0
2020-08-10 04:00:00	MSFT	Stock	211.98	211.98	211.51	211.6	3109.0
2020-08-10 05:00:00	MSFT	Stock	211.55	211.77	211.31	211.45	2838.0
2020-08-10 06:00:00	MSFT	Stock	211.5	211.75	211.39	211.39	2913.0
2020-08-10 07:00:00	MSFT	Stock	211.77	211.93	210.95	211.19	52234.0
2020-08-10 08:00:00	MSFT	Stock	211.021	211.85	210.95	211.24	94380.0
2020-08-10 09:00:00	MSFT	Stock	211.25	211.88	208.62	208.89	4619966.0
2020-08-10 10:00:00	MSFT	Stock	208.91	209.07	206.78	206.79	3895140.0
2020-08-10 11:00:00	MSFT	Stock	206.78	208.15	206.35	207.0	4338125.0
2020-08-10 12:00:00	MSFT	Stock	207.03	208.2	206.75	207.782	2585120.0
2020-08-10 13:00:00	MSFT	Stock	207.8	208.575	207.65	207.8	2232334.0
2020-08-10 14:00:00	MSFT	Stock	207.8	208.13	206.78	207.32	2444780.0
2020-08-10 15:00:00	MSFT	Stock	207.318	208.35	207.15	208.33	3751411.0
2020-08-10 16:00:00	MSFT	Stock	208.18	208.45	207.91	208.25	2692257.0
2020-08-10 17:00:00	MSFT	Stock	208.25	208.38	208.01	208.11	4961.0
2020-08-10 18:00:00	MSFT	Stock	208.03	208.08	208.0	208.04	11342.0
2020-08-10 19:00:00	MSFT	Stock	208.05	208.35	207.75	208.35	19329.0
2020-08-10 04:00:00	NVDA	Stock	11.2	11.2	11.2	11.2	12000.0
2020-08-10 06:00:00	NVDA	Stock	11.225	11.225	11.225	11.225	5240.0
2020-08-10 07:00:00	NVDA	Stock	11.2623	11.2672	11.225	11.251	573120.0
2020-08-10 08:00:00	NVDA	Stock	11.255	11.333	11.2265	11.3105	1217920.0
2020-08-10 09:00:00	NVDA	Stock	11.3125	11.4082	11.1355	11.17	51456400.0
2020-08-10 10:00:00	NVDA	Stock	11.17	11.2088	10.875	10.8817	63334600.0
2020-08-10 11:00:00	NVDA	Stock	10.889	11.1625	10.8565	11.1368	74602480.0
2020-08-10 12:00:00	NVDA	Stock	11.1382	11.2895	11.1012	11.2578	59944520.0
2020-08-10 13:00:00	NVDA	Stock	11.2612	11.3162	11.2112	11.2243	35984040.0
2020-08-10 14:00:00	NVDA	Stock	11.2245	11.2808	11.1834	11.2398	31198520.0
2020-08-10 15:00:00	NVDA	Stock	11.2378	11.248	11.1209	11.1652	42131560.0
2020-08-10 16:00:00	NVDA	Stock	11.165	11.1838	11.154	11.1793	3913240.0
2020-08-10 17:00:00	NVDA	Stock	11.1728	11.1728	11.1545	11.1545	73680.0
2020-08-10 18:00:00	NVDA	Stock	11.1575	11.165	11.1545	11.165	50400.0
2020-08-10 19:00:00	NVDA	Stock	11.1562	11.1613	11.14	11.1438	178400.0
2020-08-10 07:00:00	AMZN	Stock	158.3	158.7	158.0	158.6995	89980.0
2020-08-10 08:00:00	AMZN	Stock	158.3701	159.15	158.2	158.625	375400.0
2020-08-10 09:00:00	AMZN	Stock	158.6495	158.6495	156.515	156.7582	10132980.0

> showing 50 of 58,457 rows — these rows as CSV

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