PREVIEW / stock_1hour / 2020-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-23.parquet
  size:    1.2 MB
  rows:    56,057
  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-03-23 04:00:00	AAPL	Stock	56.22	56.22	55.37	55.6875	181896.0
2020-03-23 05:00:00	AAPL	Stock	55.75	56.375	55.7	56.1	113456.0
2020-03-23 06:00:00	AAPL	Stock	56.0375	56.75	56.0375	56.75	97088.0
2020-03-23 07:00:00	AAPL	Stock	56.7425	56.7425	55.625	55.75	737564.0
2020-03-23 08:00:00	AAPL	Stock	56.3738	59.525	55.63	58.57	3687892.0
2020-03-23 09:00:00	AAPL	Stock	58.5525	58.875	54.5	56.0375	42475956.0
2020-03-23 10:00:00	AAPL	Stock	56.0488	56.17	54.65	54.7608	37341816.0
2020-03-23 11:00:00	AAPL	Stock	54.78	55.33	53.1525	54.1925	40834224.0
2020-03-23 12:00:00	AAPL	Stock	54.175	56.36	53.77	56.1875	36948628.0
2020-03-23 13:00:00	AAPL	Stock	56.2012	56.775	55.015	55.3175	30016524.0
2020-03-23 14:00:00	AAPL	Stock	55.32	55.5965	54.55	54.9812	22034292.0
2020-03-23 15:00:00	AAPL	Stock	54.99	56.7	54.255	55.8575	40064788.0
2020-03-23 16:00:00	AAPL	Stock	56.0925	56.2225	55.6275	55.875	19616820.0
2020-03-23 17:00:00	AAPL	Stock	55.975	56.4925	55.8425	56.425	218768.0
2020-03-23 18:00:00	AAPL	Stock	56.4275	56.95	56.39	56.8	577900.0
2020-03-23 19:00:00	AAPL	Stock	56.855	57.45	56.7875	57.0	573604.0
2020-03-23 04:00:00	MSFT	Stock	133.49	134.62	133.1	133.63	19338.0
2020-03-23 05:00:00	MSFT	Stock	133.74	135.49	133.74	134.8	13928.0
2020-03-23 06:00:00	MSFT	Stock	134.61	135.87	134.35	135.55	54182.0
2020-03-23 07:00:00	MSFT	Stock	135.5	136.0	134.02	134.72	111560.0
2020-03-23 08:00:00	MSFT	Stock	135.99	144.0	134.01	141.24	490558.0
2020-03-23 09:00:00	MSFT	Stock	141.24	142.4	134.52	138.99	10634253.0
2020-03-23 10:00:00	MSFT	Stock	138.955	140.57	135.61	135.695	8541279.0
2020-03-23 11:00:00	MSFT	Stock	135.74	137.03	132.52	134.74	8305275.0
2020-03-23 12:00:00	MSFT	Stock	134.71	140.0	134.64	139.3	7986484.0
2020-03-23 13:00:00	MSFT	Stock	139.33	139.89	135.5	136.341	5952333.0
2020-03-23 14:00:00	MSFT	Stock	136.39	137.62	134.8	135.42	5343162.0
2020-03-23 15:00:00	MSFT	Stock	135.46	137.25	133.67	135.56	12096423.0
2020-03-23 16:00:00	MSFT	Stock	135.98	136.27	135.0	135.39	6541733.0
2020-03-23 17:00:00	MSFT	Stock	135.74	136.9	135.15	136.85	64734.0
2020-03-23 18:00:00	MSFT	Stock	136.8	137.8	136.8	137.8	92954.0
2020-03-23 19:00:00	MSFT	Stock	137.85	139.15	137.8	138.01	122846.0
2020-03-23 04:00:00	NVDA	Stock	4.9503	4.975	4.8722	4.95	197960.0
2020-03-23 05:00:00	NVDA	Stock	4.9503	5.0	4.9478	5.0	27840.0
2020-03-23 06:00:00	NVDA	Stock	4.995	5.05	4.995	5.05	57720.0
2020-03-23 07:00:00	NVDA	Stock	5.0312	5.075	4.9725	4.9958	901800.0
2020-03-23 08:00:00	NVDA	Stock	5.019	5.4	4.981	5.31	4827480.0
2020-03-23 09:00:00	NVDA	Stock	5.3125	5.375	4.963	5.291	88091600.0
2020-03-23 10:00:00	NVDA	Stock	5.283	5.3068	5.183	5.1974	86186760.0
2020-03-23 11:00:00	NVDA	Stock	5.1908	5.27	5.0089	5.1205	73574640.0
2020-03-23 12:00:00	NVDA	Stock	5.1198	5.3298	5.06	5.312	87436040.0
2020-03-23 13:00:00	NVDA	Stock	5.3115	5.412	5.225	5.2578	70975400.0
2020-03-23 14:00:00	NVDA	Stock	5.2618	5.3265	5.18	5.286	44919120.0
2020-03-23 15:00:00	NVDA	Stock	5.2828	5.3472	5.1768	5.3028	81513960.0
2020-03-23 16:00:00	NVDA	Stock	5.3173	5.3438	5.2815	5.3173	26124240.0
2020-03-23 17:00:00	NVDA	Stock	5.3248	5.3875	5.3235	5.3875	598440.0
2020-03-23 18:00:00	NVDA	Stock	5.3875	5.45	5.385	5.4495	869280.0
2020-03-23 19:00:00	NVDA	Stock	5.4495	5.4625	5.4255	5.4438	782560.0
2020-03-23 04:00:00	AMZN	Stock	90.0	90.0	90.0	90.0	5480.0
2020-03-23 05:00:00	AMZN	Stock	90.75	91.0	90.5	90.85	37780.0

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

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