PREVIEW / stock_1hour / 2020-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-08.parquet
  size:    1.2 MB
  rows:    53,638
  symbols: 2,432

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-04-08 04:00:00	AAPL	Stock	65.0	65.1925	64.355	64.83	25316.0
2020-04-08 05:00:00	AAPL	Stock	64.815	64.85	64.675	64.675	20928.0
2020-04-08 06:00:00	AAPL	Stock	64.7	65.2475	64.7	65.175	33680.0
2020-04-08 07:00:00	AAPL	Stock	65.135	65.7125	65.135	65.575	259356.0
2020-04-08 08:00:00	AAPL	Stock	65.2875	65.9625	65.175	65.525	771904.0
2020-04-08 09:00:00	AAPL	Stock	65.5	65.97	65.32	65.3825	14682116.0
2020-04-08 10:00:00	AAPL	Stock	65.3825	66.21	65.3075	66.155	18582788.0
2020-04-08 11:00:00	AAPL	Stock	66.1612	66.435	65.9568	66.2175	17226568.0
2020-04-08 12:00:00	AAPL	Stock	66.22	66.37	66.0425	66.2475	10295932.0
2020-04-08 13:00:00	AAPL	Stock	66.2575	66.3378	65.7095	65.8088	10317400.0
2020-04-08 14:00:00	AAPL	Stock	65.83	66.525	65.7675	66.5175	14389200.0
2020-04-08 15:00:00	AAPL	Stock	66.5175	66.8425	65.91	66.51	32155068.0
2020-04-08 16:00:00	AAPL	Stock	66.51	66.545	66.2462	66.485	16818724.0
2020-04-08 17:00:00	AAPL	Stock	66.4625	66.48	66.395	66.425	73864.0
2020-04-08 18:00:00	AAPL	Stock	66.4125	66.5175	66.2675	66.375	115012.0
2020-04-08 19:00:00	AAPL	Stock	66.37	66.84	66.3375	66.84	206196.0
2020-04-08 04:00:00	MSFT	Stock	164.44	164.44	163.0	163.5	6283.0
2020-04-08 05:00:00	MSFT	Stock	163.24	163.65	163.11	163.5	3535.0
2020-04-08 06:00:00	MSFT	Stock	163.7	164.6	163.48	164.6	4289.0
2020-04-08 07:00:00	MSFT	Stock	164.48	165.5	164.23	165.0	70468.0
2020-04-08 08:00:00	MSFT	Stock	164.6	165.92	164.5	165.39	158054.0
2020-04-08 09:00:00	MSFT	Stock	165.31	166.67	164.13	164.4	4700575.0
2020-04-08 10:00:00	MSFT	Stock	164.4	165.22	163.71	165.12	4679264.0
2020-04-08 11:00:00	MSFT	Stock	165.1	165.99	164.38	165.32	4548854.0
2020-04-08 12:00:00	MSFT	Stock	165.35	165.79	164.58	165.19	4398298.0
2020-04-08 13:00:00	MSFT	Stock	165.2	165.7	163.82	164.015	4461428.0
2020-04-08 14:00:00	MSFT	Stock	164.015	165.932	163.5	165.84	5108584.0
2020-04-08 15:00:00	MSFT	Stock	165.83	165.98	163.97	165.11	9008121.0
2020-04-08 16:00:00	MSFT	Stock	165.12	165.18	164.42	164.95	4842486.0
2020-04-08 17:00:00	MSFT	Stock	165.0	165.0	164.78	164.95	8405.0
2020-04-08 18:00:00	MSFT	Stock	164.8	165.13	164.01	164.69	20071.0
2020-04-08 19:00:00	MSFT	Stock	164.6	165.95	164.55	165.73	51554.0
2020-04-08 04:00:00	NVDA	Stock	6.55	6.55	6.4405	6.444	213120.0
2020-04-08 05:00:00	NVDA	Stock	6.4745	6.475	6.4745	6.475	21720.0
2020-04-08 06:00:00	NVDA	Stock	6.5183	6.5183	6.5183	6.5183	5080.0
2020-04-08 07:00:00	NVDA	Stock	6.4905	6.616	6.49	6.5738	1000880.0
2020-04-08 08:00:00	NVDA	Stock	6.52	6.6	6.52	6.5495	2146560.0
2020-04-08 09:00:00	NVDA	Stock	6.5475	6.6463	6.515	6.5312	59530320.0
2020-04-08 10:00:00	NVDA	Stock	6.5348	6.6198	6.522	6.5994	70430680.0
2020-04-08 11:00:00	NVDA	Stock	6.5979	6.684	6.5531	6.621	72299240.0
2020-04-08 12:00:00	NVDA	Stock	6.621	6.678	6.6102	6.663	42179520.0
2020-04-08 13:00:00	NVDA	Stock	6.6645	6.6752	6.5898	6.5968	41339680.0
2020-04-08 14:00:00	NVDA	Stock	6.6	6.6988	6.5963	6.6846	54897880.0
2020-04-08 15:00:00	NVDA	Stock	6.683	6.692	6.615	6.67	112545720.0
2020-04-08 16:00:00	NVDA	Stock	6.6738	6.6738	6.6358	6.671	5323520.0
2020-04-08 17:00:00	NVDA	Stock	6.671	6.671	6.6582	6.67	257240.0
2020-04-08 18:00:00	NVDA	Stock	6.661	6.6638	6.6535	6.6625	300120.0
2020-04-08 19:00:00	NVDA	Stock	6.6638	6.6975	6.655	6.6952	1423480.0
2020-04-08 07:00:00	AMZN	Stock	100.795	100.925	100.75	100.885	76480.0
2020-04-08 08:00:00	AMZN	Stock	100.9005	101.2085	100.9005	100.975	110540.0

> showing 50 of 53,638 rows — these rows as CSV

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