PREVIEW / stock_1hour / 2020-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-16.parquet
  size:    1.2 MB
  rows:    56,424
  symbols: 2,439

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-07-16 04:00:00	AAPL	Stock	96.925	96.925	96.1225	96.21	45344.0
2020-07-16 05:00:00	AAPL	Stock	96.21	96.35	96.0575	96.25	43024.0
2020-07-16 06:00:00	AAPL	Stock	96.275	96.3625	95.755	96.265	37240.0
2020-07-16 07:00:00	AAPL	Stock	96.3125	96.875	96.125	96.675	308776.0
2020-07-16 08:00:00	AAPL	Stock	96.2625	96.875	96.22	96.6	584248.0
2020-07-16 09:00:00	AAPL	Stock	96.5975	97.405	96.5	96.7612	12707052.0
2020-07-16 10:00:00	AAPL	Stock	96.7802	96.9195	96.165	96.41	15722144.0
2020-07-16 11:00:00	AAPL	Stock	96.4125	96.4778	95.905	96.244	12564036.0
2020-07-16 12:00:00	AAPL	Stock	96.24	96.3175	95.9375	95.975	8217612.0
2020-07-16 13:00:00	AAPL	Stock	95.9775	96.545	95.945	96.1925	8833924.0
2020-07-16 14:00:00	AAPL	Stock	96.1875	96.75	96.1325	96.2438	9311268.0
2020-07-16 15:00:00	AAPL	Stock	96.26	96.85	96.1975	96.5575	11658768.0
2020-07-16 16:00:00	AAPL	Stock	96.5575	96.5575	95.945	96.02	5330376.0
2020-07-16 17:00:00	AAPL	Stock	96.0225	96.5225	95.96	95.975	231772.0
2020-07-16 18:00:00	AAPL	Stock	95.975	96.2	95.975	96.105	104824.0
2020-07-16 19:00:00	AAPL	Stock	96.1375	96.2875	96.1375	96.2875	68824.0
2020-07-16 04:00:00	MSFT	Stock	206.1	206.1	204.61	204.86	6794.0
2020-07-16 05:00:00	MSFT	Stock	204.87	205.1	204.33	204.85	12199.0
2020-07-16 06:00:00	MSFT	Stock	205.11	205.15	204.07	204.8	10427.0
2020-07-16 07:00:00	MSFT	Stock	204.8	205.58	204.75	205.0	39506.0
2020-07-16 08:00:00	MSFT	Stock	205.1	208.56	204.38	205.25	81686.0
2020-07-16 09:00:00	MSFT	Stock	205.19	205.95	204.3	204.82	3328257.0
2020-07-16 10:00:00	MSFT	Stock	204.81	204.99	203.0	203.05	4139464.0
2020-07-16 11:00:00	MSFT	Stock	203.06	203.87	202.31	203.84	3206016.0
2020-07-16 12:00:00	MSFT	Stock	203.835	204.2	203.22	203.68	1999909.0
2020-07-16 13:00:00	MSFT	Stock	203.67	204.36	203.61	203.85	2216908.0
2020-07-16 14:00:00	MSFT	Stock	203.845	204.47	203.22	203.33	2136603.0
2020-07-16 15:00:00	MSFT	Stock	203.33	204.71	203.14	203.92	4470045.0
2020-07-16 16:00:00	MSFT	Stock	203.92	203.92	202.5	202.89	2414952.0
2020-07-16 17:00:00	MSFT	Stock	202.83	203.92	202.8	203.15	22822.0
2020-07-16 18:00:00	MSFT	Stock	203.1	203.4	203.03	203.35	17192.0
2020-07-16 19:00:00	MSFT	Stock	203.39	203.6	203.35	203.6	17188.0
2020-07-16 04:00:00	NVDA	Stock	10.0278	10.0502	9.9978	10.0	200920.0
2020-07-16 05:00:00	NVDA	Stock	9.95	9.9698	9.95	9.9698	63920.0
2020-07-16 06:00:00	NVDA	Stock	9.99	10.0	9.99	10.0	129320.0
2020-07-16 07:00:00	NVDA	Stock	10.0008	10.0848	10.0008	10.0515	384920.0
2020-07-16 08:00:00	NVDA	Stock	10.0638	10.075	9.9988	10.05	1003880.0
2020-07-16 09:00:00	NVDA	Stock	10.05	10.1116	9.9412	10.0178	44803240.0
2020-07-16 10:00:00	NVDA	Stock	10.0239	10.05	9.9438	9.9628	67092440.0
2020-07-16 11:00:00	NVDA	Stock	9.964	10.0486	9.8955	10.0458	55525560.0
2020-07-16 12:00:00	NVDA	Stock	10.0442	10.125	10.0125	10.0729	43038200.0
2020-07-16 13:00:00	NVDA	Stock	10.075	10.1608	10.074	10.1375	28585800.0
2020-07-16 14:00:00	NVDA	Stock	10.1332	10.2068	10.1318	10.1565	27123240.0
2020-07-16 15:00:00	NVDA	Stock	10.1592	10.202	10.1155	10.1345	33774640.0
2020-07-16 16:00:00	NVDA	Stock	10.1345	10.1348	10.025	10.05	10032640.0
2020-07-16 17:00:00	NVDA	Stock	10.05	10.0525	10.05	10.05	60560.0
2020-07-16 18:00:00	NVDA	Stock	10.0662	10.0688	10.0505	10.0688	103960.0
2020-07-16 19:00:00	NVDA	Stock	10.0662	10.0972	10.0662	10.0963	133800.0
2020-07-16 04:00:00	AMZN	Stock	147.75	147.75	147.75	147.75	4420.0
2020-07-16 05:00:00	AMZN	Stock	147.5025	147.605	147.303	147.4	51260.0

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

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