PREVIEW / stock_1hour / 2020-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-20.parquet
  size:    1.2 MB
  rows:    56,486
  symbols: 2,459

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-20 04:00:00	AAPL	Stock	115.675	115.675	115.25	115.425	11544.0
2020-08-20 05:00:00	AAPL	Stock	115.4925	115.9625	115.4925	115.95	9952.0
2020-08-20 06:00:00	AAPL	Stock	115.9825	116.3625	115.93	116.3625	34732.0
2020-08-20 07:00:00	AAPL	Stock	116.35	116.3775	116.0	116.16	342332.0
2020-08-20 08:00:00	AAPL	Stock	116.16	116.35	115.875	116.0	464828.0
2020-08-20 09:00:00	AAPL	Stock	115.976	117.4225	115.7335	117.255	17923592.0
2020-08-20 10:00:00	AAPL	Stock	117.275	117.445	116.8	117.165	16325212.0
2020-08-20 11:00:00	AAPL	Stock	117.175	117.4125	116.8575	117.3162	8977828.0
2020-08-20 12:00:00	AAPL	Stock	117.32	117.625	117.0925	117.1525	9999012.0
2020-08-20 13:00:00	AAPL	Stock	117.1505	117.5	117.025	117.3425	7590336.0
2020-08-20 14:00:00	AAPL	Stock	117.3325	117.675	117.225	117.6462	8326052.0
2020-08-20 15:00:00	AAPL	Stock	117.6425	118.392	117.4388	118.2075	20348628.0
2020-08-20 16:00:00	AAPL	Stock	118.275	118.685	115.7075	118.63	7242628.0
2020-08-20 17:00:00	AAPL	Stock	118.6375	119.0	115.7075	118.9225	330056.0
2020-08-20 18:00:00	AAPL	Stock	118.9	118.9925	118.8125	118.9725	203364.0
2020-08-20 19:00:00	AAPL	Stock	118.9625	119.22	118.9525	119.1375	318496.0
2020-08-20 04:00:00	MSFT	Stock	209.3	209.4	208.94	209.4	2594.0
2020-08-20 05:00:00	MSFT	Stock	209.35	210.1	209.35	210.09	3093.0
2020-08-20 06:00:00	MSFT	Stock	209.95	210.57	209.95	210.49	1017.0
2020-08-20 07:00:00	MSFT	Stock	210.05	210.21	209.74	209.78	7271.0
2020-08-20 08:00:00	MSFT	Stock	209.787	210.2	209.42	209.52	25177.0
2020-08-20 09:00:00	MSFT	Stock	209.55	210.72	208.91	210.49	1839148.0
2020-08-20 10:00:00	MSFT	Stock	210.53	211.99	210.17	211.96	2420437.0
2020-08-20 11:00:00	MSFT	Stock	211.96	212.092	210.96	211.98	1838446.0
2020-08-20 12:00:00	MSFT	Stock	211.99	212.36	211.58	211.75	1748518.0
2020-08-20 13:00:00	MSFT	Stock	211.751	213.049	211.615	213.01	1931961.0
2020-08-20 14:00:00	MSFT	Stock	213.0	214.35	212.84	214.27	3108360.0
2020-08-20 15:00:00	MSFT	Stock	214.26	215.0	213.88	214.55	4900836.0
2020-08-20 16:00:00	MSFT	Stock	214.58	214.785	213.401	214.25	4601827.0
2020-08-20 17:00:00	MSFT	Stock	214.2	214.58	214.15	214.5	60663.0
2020-08-20 18:00:00	MSFT	Stock	214.32	214.7	214.3	214.3	9860.0
2020-08-20 19:00:00	MSFT	Stock	214.3	214.58	214.26	214.58	13540.0
2020-08-20 04:00:00	NVDA	Stock	11.875	11.9623	11.875	11.9623	300920.0
2020-08-20 05:00:00	NVDA	Stock	11.975	11.975	11.95	11.9748	280560.0
2020-08-20 06:00:00	NVDA	Stock	11.965	12.0	11.9625	11.9625	143360.0
2020-08-20 07:00:00	NVDA	Stock	11.9688	12.125	11.9688	12.0722	3642080.0
2020-08-20 08:00:00	NVDA	Stock	11.9868	12.123	11.9625	12.0225	7725440.0
2020-08-20 09:00:00	NVDA	Stock	12.0138	12.3558	11.8788	12.3038	232759600.0
2020-08-20 10:00:00	NVDA	Stock	12.3048	12.375	12.065	12.1613	208965040.0
2020-08-20 11:00:00	NVDA	Stock	12.1622	12.2225	12.0502	12.2188	97883280.0
2020-08-20 12:00:00	NVDA	Stock	12.2183	12.2205	12.125	12.159	49264720.0
2020-08-20 13:00:00	NVDA	Stock	12.1592	12.243	12.152	12.2322	48067160.0
2020-08-20 14:00:00	NVDA	Stock	12.2328	12.248	12.1583	12.2106	59481520.0
2020-08-20 15:00:00	NVDA	Stock	12.2105	12.2535	12.1225	12.1392	81818640.0
2020-08-20 16:00:00	NVDA	Stock	12.141	12.1575	12.14	12.1433	2896720.0
2020-08-20 17:00:00	NVDA	Stock	12.15	12.1812	12.141	12.1812	840360.0
2020-08-20 18:00:00	NVDA	Stock	12.1833	12.2	12.175	12.1948	1509000.0
2020-08-20 19:00:00	NVDA	Stock	12.1895	12.1895	12.1675	12.175	847960.0
2020-08-20 06:00:00	AMZN	Stock	162.998	162.998	162.998	162.998	2000.0
2020-08-20 07:00:00	AMZN	Stock	163.3	163.305	162.95	162.95	96340.0

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

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