PREVIEW / stock_1hour / 2020-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-11.parquet
  size:    1.3 MB
  rows:    58,637
  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-11 04:00:00	AAPL	Stock	113.025	113.4375	113.025	113.325	46284.0
2020-08-11 05:00:00	AAPL	Stock	113.3375	113.5525	113.2025	113.25	72428.0
2020-08-11 06:00:00	AAPL	Stock	113.25	113.3125	113.1475	113.1475	60316.0
2020-08-11 07:00:00	AAPL	Stock	113.1875	113.2925	112.28	112.4	683940.0
2020-08-11 08:00:00	AAPL	Stock	112.91	113.275	111.5	111.9	1008972.0
2020-08-11 09:00:00	AAPL	Stock	111.8552	112.4825	111.2025	111.8712	17458424.0
2020-08-11 10:00:00	AAPL	Stock	111.8725	111.9622	111.07	111.36	18366312.0
2020-08-11 11:00:00	AAPL	Stock	111.3625	112.1825	111.095	111.3838	15898924.0
2020-08-11 12:00:00	AAPL	Stock	111.3925	111.87	111.2325	111.4775	11550120.0
2020-08-11 13:00:00	AAPL	Stock	111.48	111.75	111.2975	111.51	7809572.0
2020-08-11 14:00:00	AAPL	Stock	111.515	111.555	110.5775	110.8422	16289020.0
2020-08-11 15:00:00	AAPL	Stock	110.8525	110.93	109.1068	109.3775	31867932.0
2020-08-11 16:00:00	AAPL	Stock	109.375	110.733	109.28	109.9375	14133896.0
2020-08-11 17:00:00	AAPL	Stock	109.965	110.25	109.7725	109.7725	310680.0
2020-08-11 18:00:00	AAPL	Stock	109.85	110.1225	109.825	109.86	106720.0
2020-08-11 19:00:00	AAPL	Stock	109.9	110.125	109.7725	110.035	177684.0
2020-08-11 04:00:00	MSFT	Stock	209.4	209.7	209.4	209.5	4476.0
2020-08-11 05:00:00	MSFT	Stock	209.54	209.8	208.99	209.45	7240.0
2020-08-11 06:00:00	MSFT	Stock	209.3	209.48	209.05	209.05	3964.0
2020-08-11 07:00:00	MSFT	Stock	209.05	209.18	207.55	207.6	62073.0
2020-08-11 08:00:00	MSFT	Stock	208.9	209.15	206.28	206.6	121879.0
2020-08-11 09:00:00	MSFT	Stock	206.53	207.55	203.77	205.29	5282049.0
2020-08-11 10:00:00	MSFT	Stock	205.27	205.71	203.9	205.5	4018870.0
2020-08-11 11:00:00	MSFT	Stock	205.53	206.97	205.5	206.375	2264726.0
2020-08-11 12:00:00	MSFT	Stock	206.4	207.65	206.26	207.31	1630285.0
2020-08-11 13:00:00	MSFT	Stock	207.31	207.38	206.41	206.76	1362269.0
2020-08-11 14:00:00	MSFT	Stock	206.76	207.005	205.74	206.54	2006164.0
2020-08-11 15:00:00	MSFT	Stock	206.55	206.67	203.14	203.33	6332268.0
2020-08-11 16:00:00	MSFT	Stock	203.33	205.036	203.33	203.95	3278996.0
2020-08-11 17:00:00	MSFT	Stock	203.95	204.6	203.85	204.5	44555.0
2020-08-11 18:00:00	MSFT	Stock	204.49	205.1	204.3	204.4	33400.0
2020-08-11 19:00:00	MSFT	Stock	204.46	204.52	204.06	204.45	33535.0
2020-08-11 04:00:00	NVDA	Stock	11.1842	11.1905	11.1842	11.1905	86040.0
2020-08-11 05:00:00	NVDA	Stock	11.2475	11.25	11.2475	11.25	21360.0
2020-08-11 07:00:00	NVDA	Stock	11.25	11.253	11.1225	11.1225	663280.0
2020-08-11 08:00:00	NVDA	Stock	11.2507	11.2515	10.99	11.0562	1749760.0
2020-08-11 09:00:00	NVDA	Stock	11.0562	11.1368	10.9085	11.0551	60456680.0
2020-08-11 10:00:00	NVDA	Stock	11.057	11.0875	10.9345	11.0233	48530680.0
2020-08-11 11:00:00	NVDA	Stock	11.0255	11.0988	10.9635	10.989	34343680.0
2020-08-11 12:00:00	NVDA	Stock	10.99	11.0805	10.985	11.0398	27906520.0
2020-08-11 13:00:00	NVDA	Stock	11.0375	11.056	10.9802	11.0099	21668160.0
2020-08-11 14:00:00	NVDA	Stock	11.0105	11.0278	10.9312	10.9903	28128840.0
2020-08-11 15:00:00	NVDA	Stock	10.9852	11.0043	10.7958	10.8528	80341960.0
2020-08-11 16:00:00	NVDA	Stock	10.85	10.9028	10.8308	10.8875	11968280.0
2020-08-11 17:00:00	NVDA	Stock	10.885	10.9145	10.8762	10.91	260760.0
2020-08-11 18:00:00	NVDA	Stock	10.911	10.9125	10.8912	10.9125	514600.0
2020-08-11 19:00:00	NVDA	Stock	10.9018	10.9138	10.9	10.9138	228160.0
2020-08-11 04:00:00	AMZN	Stock	158.0	158.276	158.0	158.276	8820.0
2020-08-11 05:00:00	AMZN	Stock	158.25	158.25	158.25	158.25	5440.0
2020-08-11 07:00:00	AMZN	Stock	157.994	158.02	156.943	157.1995	164900.0

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

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