PREVIEW / stock_1hour / 2020-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-31.parquet
  size:    1.3 MB
  rows:    58,117
  symbols: 2,465

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-31 04:00:00	AAPL	Stock	128.0	137.29	125.6	126.99	384083.0
2020-08-31 05:00:00	AAPL	Stock	126.99	126.99	126.36	126.7	101696.0
2020-08-31 06:00:00	AAPL	Stock	126.67	126.74	125.95	126.04	142199.0
2020-08-31 07:00:00	AAPL	Stock	126.2	126.9	125.36	125.75	1466063.0
2020-08-31 08:00:00	AAPL	Stock	125.73	126.9	125.21	125.67	2071565.0
2020-08-31 09:00:00	AAPL	Stock	125.67	128.74	125.02	128.035	34940550.0
2020-08-31 10:00:00	AAPL	Stock	128.048	129.5	127.12	129.065	30118060.0
2020-08-31 11:00:00	AAPL	Stock	129.07	130.05	127.7	128.95	30962586.0
2020-08-31 12:00:00	AAPL	Stock	128.94	129.69	128.53	129.456	14608614.0
2020-08-31 13:00:00	AAPL	Stock	129.46	131.0	129.4	130.69	19715991.0
2020-08-31 14:00:00	AAPL	Stock	130.681	130.89	129.76	130.521	14045572.0
2020-08-31 15:00:00	AAPL	Stock	130.52	130.6	128.75	128.85	24621148.0
2020-08-31 16:00:00	AAPL	Stock	128.85	129.65	128.79	129.1	14558839.0
2020-08-31 17:00:00	AAPL	Stock	129.1	129.64	129.07	129.41	316829.0
2020-08-31 18:00:00	AAPL	Stock	129.41	129.65	129.01	129.2	251400.0
2020-08-31 19:00:00	AAPL	Stock	129.17	129.48	129.12	129.33	171622.0
2020-08-31 04:00:00	MSFT	Stock	228.0	228.0	222.0	224.04	32684.0
2020-08-31 05:00:00	MSFT	Stock	224.0	225.68	223.91	225.65	16708.0
2020-08-31 06:00:00	MSFT	Stock	225.78	226.0	225.15	225.79	6407.0
2020-08-31 07:00:00	MSFT	Stock	226.0	226.0	224.1	224.43	74998.0
2020-08-31 08:00:00	MSFT	Stock	224.5	227.7	224.1	227.0	262356.0
2020-08-31 09:00:00	MSFT	Stock	227.0	228.7	225.83	227.36	4017634.0
2020-08-31 10:00:00	MSFT	Stock	227.37	227.9	225.46	226.035	3447875.0
2020-08-31 11:00:00	MSFT	Stock	226.035	226.25	224.31	225.105	2892639.0
2020-08-31 12:00:00	MSFT	Stock	225.111	225.9	225.11	225.477	1255028.0
2020-08-31 13:00:00	MSFT	Stock	225.5	225.88	225.17	225.72	1342029.0
2020-08-31 14:00:00	MSFT	Stock	225.73	226.371	225.28	226.332	1631401.0
2020-08-31 15:00:00	MSFT	Stock	226.33	226.85	225.0	225.06	3475278.0
2020-08-31 16:00:00	MSFT	Stock	225.0	226.49	224.97	225.18	4050670.0
2020-08-31 17:00:00	MSFT	Stock	225.19	225.383	225.08	225.383	20927.0
2020-08-31 18:00:00	MSFT	Stock	225.38	225.43	225.05	225.23	20761.0
2020-08-31 19:00:00	MSFT	Stock	225.1	225.69	225.07	225.62	18924.0
2020-08-31 04:00:00	NVDA	Stock	13.2102	13.2105	13.2	13.2095	121840.0
2020-08-31 05:00:00	NVDA	Stock	13.2325	13.25	13.2325	13.25	96120.0
2020-08-31 06:00:00	NVDA	Stock	13.25	13.25	13.2472	13.25	97080.0
2020-08-31 07:00:00	NVDA	Stock	13.275	13.2788	13.2273	13.2708	1170000.0
2020-08-31 08:00:00	NVDA	Stock	13.247	13.2795	13.1838	13.2125	2014920.0
2020-08-31 09:00:00	NVDA	Stock	13.2019	13.2523	13.0812	13.1222	54238920.0
2020-08-31 10:00:00	NVDA	Stock	13.1213	13.2148	13.0775	13.1348	49138760.0
2020-08-31 11:00:00	NVDA	Stock	13.1364	13.1409	13.0378	13.1278	29871720.0
2020-08-31 12:00:00	NVDA	Stock	13.1295	13.4942	13.1269	13.47	111708560.0
2020-08-31 13:00:00	NVDA	Stock	13.4712	13.575	13.4184	13.5494	56659760.0
2020-08-31 14:00:00	NVDA	Stock	13.5462	13.5596	13.4765	13.505	34094240.0
2020-08-31 15:00:00	NVDA	Stock	13.5064	13.5132	13.3115	13.3115	64555760.0
2020-08-31 16:00:00	NVDA	Stock	13.3745	13.3812	13.35	13.37	7250600.0
2020-08-31 17:00:00	NVDA	Stock	13.37	13.38	13.3695	13.375	336360.0
2020-08-31 18:00:00	NVDA	Stock	13.375	13.3798	13.35	13.3675	203960.0
2020-08-31 19:00:00	NVDA	Stock	13.3675	13.3998	13.3675	13.3812	644240.0
2020-08-31 04:00:00	AMZN	Stock	170.75	170.75	170.75	170.75	2200.0
2020-08-31 05:00:00	AMZN	Stock	171.187	171.187	171.187	171.187	2320.0

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

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