PREVIEW / stock_1hour / 2020-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-17.parquet
  size:    1.3 MB
  rows:    59,174
  symbols: 2,551

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-11-17 04:00:00	AAPL	Stock	119.99	119.99	119.49	119.79	12452.0
2020-11-17 05:00:00	AAPL	Stock	119.73	119.74	119.47	119.6	14535.0
2020-11-17 06:00:00	AAPL	Stock	119.6	119.69	119.4	119.65	12205.0
2020-11-17 07:00:00	AAPL	Stock	119.68	119.86	119.42	119.76	171259.0
2020-11-17 08:00:00	AAPL	Stock	119.8	119.88	119.45	119.73	286566.0
2020-11-17 09:00:00	AAPL	Stock	119.74	120.31	118.96	119.142	11350562.0
2020-11-17 10:00:00	AAPL	Stock	119.135	120.53	119.11	120.36	11013907.0
2020-11-17 11:00:00	AAPL	Stock	120.36	120.4	119.6	120.22	7732753.0
2020-11-17 12:00:00	AAPL	Stock	120.22	120.49	120.015	120.475	5498198.0
2020-11-17 13:00:00	AAPL	Stock	120.47	120.674	120.28	120.36	5139992.0
2020-11-17 14:00:00	AAPL	Stock	120.36	120.615	119.96	120.014	5950700.0
2020-11-17 15:00:00	AAPL	Stock	120.014	120.15	119.32	119.36	11270440.0
2020-11-17 16:00:00	AAPL	Stock	119.36	119.49	119.36	119.42	7612825.0
2020-11-17 17:00:00	AAPL	Stock	119.39	119.47	119.35	119.41	41925.0
2020-11-17 18:00:00	AAPL	Stock	119.4	119.45	119.25	119.25	83755.0
2020-11-17 19:00:00	AAPL	Stock	119.31	119.4	119.11	119.2	114222.0
2020-11-17 04:00:00	MSFT	Stock	217.63	217.8	217.4	217.7	2744.0
2020-11-17 05:00:00	MSFT	Stock	217.42	217.42	217.0	217.0	889.0
2020-11-17 06:00:00	MSFT	Stock	216.5	216.96	216.5	216.8	1136.0
2020-11-17 07:00:00	MSFT	Stock	216.68	216.88	215.56	216.21	25666.0
2020-11-17 08:00:00	MSFT	Stock	216.69	216.98	215.8	216.2	29645.0
2020-11-17 09:00:00	MSFT	Stock	216.21	217.68	215.71	215.78	2070722.0
2020-11-17 10:00:00	MSFT	Stock	215.76	217.035	215.72	216.925	1719586.0
2020-11-17 11:00:00	MSFT	Stock	216.93	217.0	214.75	215.77	2549961.0
2020-11-17 12:00:00	MSFT	Stock	215.76	216.31	215.57	215.99	1346453.0
2020-11-17 13:00:00	MSFT	Stock	215.98	216.33	215.27	215.404	1418600.0
2020-11-17 14:00:00	MSFT	Stock	215.395	215.86	214.94	215.04	1890174.0
2020-11-17 15:00:00	MSFT	Stock	215.04	215.239	214.08	214.47	3903071.0
2020-11-17 16:00:00	MSFT	Stock	214.46	214.72	214.3	214.3	4388260.0
2020-11-17 17:00:00	MSFT	Stock	214.4	214.49	214.35	214.49	6372.0
2020-11-17 18:00:00	MSFT	Stock	214.47	214.57	214.36	214.57	5406.0
2020-11-17 19:00:00	MSFT	Stock	214.58	214.58	214.19	214.2	16230.0
2020-11-17 04:00:00	NVDA	Stock	13.575	13.575	13.5475	13.5475	16000.0
2020-11-17 06:00:00	NVDA	Stock	13.4972	13.5472	13.4972	13.5388	28840.0
2020-11-17 07:00:00	NVDA	Stock	13.55	13.5585	13.5025	13.5188	712080.0
2020-11-17 08:00:00	NVDA	Stock	13.5457	13.5698	13.4752	13.53	1038520.0
2020-11-17 09:00:00	NVDA	Stock	13.525	13.5965	13.3039	13.3135	40001000.0
2020-11-17 10:00:00	NVDA	Stock	13.316	13.5825	13.316	13.5765	40111240.0
2020-11-17 11:00:00	NVDA	Stock	13.5772	13.5962	13.3698	13.415	39744080.0
2020-11-17 12:00:00	NVDA	Stock	13.4139	13.4343	13.3432	13.391	25534680.0
2020-11-17 13:00:00	NVDA	Stock	13.3893	13.4385	13.3544	13.3955	21370600.0
2020-11-17 14:00:00	NVDA	Stock	13.3905	13.475	13.3882	13.4035	23046240.0
2020-11-17 15:00:00	NVDA	Stock	13.4032	13.4438	13.3165	13.4222	45723560.0
2020-11-17 16:00:00	NVDA	Stock	13.4222	13.4375	13.4175	13.425	17731960.0
2020-11-17 17:00:00	NVDA	Stock	13.4272	13.4568	13.4222	13.456	508240.0
2020-11-17 18:00:00	NVDA	Stock	13.456	13.465	13.45	13.46	573800.0
2020-11-17 19:00:00	NVDA	Stock	13.4575	13.4575	13.4262	13.4395	410000.0
2020-11-17 04:00:00	AMZN	Stock	156.5	156.5	156.5	156.5	4920.0
2020-11-17 05:00:00	AMZN	Stock	156.35	156.35	156.35	156.35	4400.0
2020-11-17 06:00:00	AMZN	Stock	156.65	156.963	156.65	156.931	16800.0

> showing 50 of 59,174 rows — these rows as CSV

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