PREVIEW / stock_1hour / 2020-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-07.parquet
  size:    1.3 MB
  rows:    57,190
  symbols: 2,442

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-07 04:00:00	AAPL	Stock	113.5	113.5	112.5125	113.0125	48484.0
2020-08-07 05:00:00	AAPL	Stock	113.0425	113.25	112.875	113.175	14696.0
2020-08-07 06:00:00	AAPL	Stock	113.2425	113.325	113.16	113.25	83316.0
2020-08-07 07:00:00	AAPL	Stock	113.25	113.6775	113.155	113.25	594388.0
2020-08-07 08:00:00	AAPL	Stock	113.7125	113.7775	113.125	113.3775	2086652.0
2020-08-07 09:00:00	AAPL	Stock	113.38	113.485	112.26	113.1262	25176948.0
2020-08-07 10:00:00	AAPL	Stock	113.1325	113.675	112.0325	113.2362	24208056.0
2020-08-07 11:00:00	AAPL	Stock	113.2425	113.3375	112.175	112.2228	14308524.0
2020-08-07 12:00:00	AAPL	Stock	112.2075	112.622	111.425	111.5825	15158744.0
2020-08-07 13:00:00	AAPL	Stock	111.57	111.765	110.7275	111.0405	19061004.0
2020-08-07 14:00:00	AAPL	Stock	111.0575	111.4458	110.2925	111.1425	17938664.0
2020-08-07 15:00:00	AAPL	Stock	111.135	111.6875	110.97	111.1025	24330948.0
2020-08-07 16:00:00	AAPL	Stock	111.1125	111.32	110.9025	111.255	7585560.0
2020-08-07 17:00:00	AAPL	Stock	111.2825	111.75	111.275	111.4375	399312.0
2020-08-07 18:00:00	AAPL	Stock	111.46	111.4725	111.4075	111.4725	60920.0
2020-08-07 19:00:00	AAPL	Stock	111.45	111.4625	111.3125	111.3725	87640.0
2020-08-07 04:00:00	MSFT	Stock	216.0	216.0	214.5	214.9	3601.0
2020-08-07 05:00:00	MSFT	Stock	214.85	214.98	214.55	214.98	3245.0
2020-08-07 06:00:00	MSFT	Stock	214.85	215.09	214.8	215.09	4374.0
2020-08-07 07:00:00	MSFT	Stock	215.11	215.4	214.59	215.37	30340.0
2020-08-07 08:00:00	MSFT	Stock	215.15	216.89	214.81	215.06	108106.0
2020-08-07 09:00:00	MSFT	Stock	215.02	216.35	213.95	214.921	2731996.0
2020-08-07 10:00:00	MSFT	Stock	214.93	215.208	214.22	215.163	2434842.0
2020-08-07 11:00:00	MSFT	Stock	215.15	215.2	213.47	213.5	1999827.0
2020-08-07 12:00:00	MSFT	Stock	213.48	213.705	212.46	212.46	2292671.0
2020-08-07 13:00:00	MSFT	Stock	212.45	212.48	210.96	211.41	2885653.0
2020-08-07 14:00:00	MSFT	Stock	211.43	212.05	210.93	211.73	2180247.0
2020-08-07 15:00:00	MSFT	Stock	211.74	212.94	211.48	212.44	3932331.0
2020-08-07 16:00:00	MSFT	Stock	212.48	212.5	212.15	212.37	2318583.0
2020-08-07 17:00:00	MSFT	Stock	212.38	212.39	212.31	212.38	11951.0
2020-08-07 18:00:00	MSFT	Stock	212.35	212.35	212.15	212.3	12117.0
2020-08-07 19:00:00	MSFT	Stock	212.3	212.4	212.18	212.21	14792.0
2020-08-07 06:00:00	NVDA	Stock	11.2563	11.2563	11.2563	11.2563	5800.0
2020-08-07 07:00:00	NVDA	Stock	11.2748	11.3	11.2748	11.3	129600.0
2020-08-07 08:00:00	NVDA	Stock	11.2875	11.3638	11.2748	11.3065	888240.0
2020-08-07 09:00:00	NVDA	Stock	11.3048	11.5048	11.275	11.4968	49256640.0
2020-08-07 10:00:00	NVDA	Stock	11.494	11.5028	11.3775	11.4327	40398200.0
2020-08-07 11:00:00	NVDA	Stock	11.4315	11.435	11.3215	11.3215	28721200.0
2020-08-07 12:00:00	NVDA	Stock	11.3206	11.3392	11.1915	11.1985	30811880.0
2020-08-07 13:00:00	NVDA	Stock	11.195	11.2048	11.083	11.1133	44701040.0
2020-08-07 14:00:00	NVDA	Stock	11.1185	11.1654	11.0375	11.0818	35246360.0
2020-08-07 15:00:00	NVDA	Stock	11.08	11.2061	11.0781	11.1995	39897880.0
2020-08-07 16:00:00	NVDA	Stock	11.1995	11.205	11.188	11.1963	12737040.0
2020-08-07 17:00:00	NVDA	Stock	11.1958	11.2055	11.1912	11.1975	158040.0
2020-08-07 18:00:00	NVDA	Stock	11.1925	11.1995	11.1925	11.1995	42440.0
2020-08-07 19:00:00	NVDA	Stock	11.2038	11.2125	11.1975	11.2125	164360.0
2020-08-07 05:00:00	AMZN	Stock	160.55	160.55	160.55	160.55	9240.0
2020-08-07 06:00:00	AMZN	Stock	160.575	160.5795	160.575	160.5795	10620.0
2020-08-07 07:00:00	AMZN	Stock	160.5	160.75	160.45	160.75	100960.0
2020-08-07 08:00:00	AMZN	Stock	160.75	161.653	160.5605	160.95	355940.0

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

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