PREVIEW / stock_1hour / 2020-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-25.parquet
  size:    1.2 MB
  rows:    56,097
  symbols: 2,494

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-09-25 04:00:00	AAPL	Stock	108.53	108.53	108.02	108.4	23505.0
2020-09-25 05:00:00	AAPL	Stock	108.5	108.7	107.54	108.11	17229.0
2020-09-25 06:00:00	AAPL	Stock	108.07	108.4	107.27	107.5	23928.0
2020-09-25 07:00:00	AAPL	Stock	107.62	108.67	107.2	108.56	303365.0
2020-09-25 08:00:00	AAPL	Stock	107.45	109.19	107.25	109.15	891843.0
2020-09-25 09:00:00	AAPL	Stock	109.102	109.436	107.67	109.14	17221583.0
2020-09-25 10:00:00	AAPL	Stock	109.13	110.45	108.57	110.095	23469102.0
2020-09-25 11:00:00	AAPL	Stock	110.09	110.94	109.81	109.865	17124364.0
2020-09-25 12:00:00	AAPL	Stock	109.865	110.75	109.82	110.7	11602313.0
2020-09-25 13:00:00	AAPL	Stock	110.71	111.265	110.4	111.235	12649283.0
2020-09-25 14:00:00	AAPL	Stock	111.23	111.82	111.18	111.77	16058995.0
2020-09-25 15:00:00	AAPL	Stock	111.76	112.44	111.715	112.28	25797517.0
2020-09-25 16:00:00	AAPL	Stock	112.28	112.57	112.279	112.48	8578482.0
2020-09-25 17:00:00	AAPL	Stock	112.5	112.52	111.9	111.97	370721.0
2020-09-25 18:00:00	AAPL	Stock	112.0	112.0	111.64	111.86	172865.0
2020-09-25 19:00:00	AAPL	Stock	111.89	112.25	111.86	112.25	123983.0
2020-09-25 04:00:00	MSFT	Stock	203.8	203.8	203.11	203.19	2549.0
2020-09-25 05:00:00	MSFT	Stock	203.8	203.8	202.35	202.65	920.0
2020-09-25 06:00:00	MSFT	Stock	202.69	202.82	202.31	202.37	1122.0
2020-09-25 07:00:00	MSFT	Stock	202.65	203.77	202.2	203.77	39461.0
2020-09-25 08:00:00	MSFT	Stock	202.927	204.278	202.13	204.278	51179.0
2020-09-25 09:00:00	MSFT	Stock	204.01	204.66	202.54	203.955	2623776.0
2020-09-25 10:00:00	MSFT	Stock	203.96	205.78	202.72	205.31	3481213.0
2020-09-25 11:00:00	MSFT	Stock	205.32	207.09	204.83	205.54	2690174.0
2020-09-25 12:00:00	MSFT	Stock	205.56	206.99	205.54	206.45	2024742.0
2020-09-25 13:00:00	MSFT	Stock	206.47	207.29	206.12	207.09	1954960.0
2020-09-25 14:00:00	MSFT	Stock	207.08	208.04	206.89	207.723	2504123.0
2020-09-25 15:00:00	MSFT	Stock	207.725	209.04	207.64	207.77	5319128.0
2020-09-25 16:00:00	MSFT	Stock	207.82	208.15	207.48	207.62	3383716.0
2020-09-25 17:00:00	MSFT	Stock	207.79	207.79	206.9	207.05	14361.0
2020-09-25 18:00:00	MSFT	Stock	206.92	207.1	206.74	207.0	5106.0
2020-09-25 19:00:00	MSFT	Stock	207.0	207.19	206.8	207.1	9908.0
2020-09-25 04:00:00	NVDA	Stock	12.4488	12.4488	12.3125	12.3748	26840.0
2020-09-25 05:00:00	NVDA	Stock	12.3188	12.3188	12.3188	12.3188	5040.0
2020-09-25 06:00:00	NVDA	Stock	12.3	12.3	12.2118	12.225	193360.0
2020-09-25 07:00:00	NVDA	Stock	12.25	12.436	12.2375	12.425	1448760.0
2020-09-25 08:00:00	NVDA	Stock	12.2875	12.45	12.2375	12.4375	3017160.0
2020-09-25 09:00:00	NVDA	Stock	12.4486	12.5	12.2458	12.3748	81634600.0
2020-09-25 10:00:00	NVDA	Stock	12.3779	12.5408	12.2913	12.523	84700920.0
2020-09-25 11:00:00	NVDA	Stock	12.5298	12.6646	12.4846	12.5837	75298280.0
2020-09-25 12:00:00	NVDA	Stock	12.586	12.6985	12.5852	12.6524	58588920.0
2020-09-25 13:00:00	NVDA	Stock	12.6521	12.7463	12.6343	12.7408	57504960.0
2020-09-25 14:00:00	NVDA	Stock	12.7362	12.8215	12.7352	12.7962	73059200.0
2020-09-25 15:00:00	NVDA	Stock	12.796	12.8835	12.7883	12.875	96165600.0
2020-09-25 16:00:00	NVDA	Stock	12.8738	12.8738	12.8023	12.8023	8676920.0
2020-09-25 17:00:00	NVDA	Stock	12.8602	12.8628	12.8152	12.8375	682880.0
2020-09-25 18:00:00	NVDA	Stock	12.8338	12.8338	12.8188	12.825	83680.0
2020-09-25 19:00:00	NVDA	Stock	12.825	12.8312	12.8225	12.8262	113280.0
2020-09-25 05:00:00	AMZN	Stock	151.35	151.35	151.0915	151.0915	8960.0
2020-09-25 06:00:00	AMZN	Stock	150.95	151.1	150.9	150.9	20260.0

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

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