PREVIEW / stock_1hour / 2021-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-02.parquet
  size:    1.5 MB
  rows:    68,059
  symbols: 2,747

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
2021-02-02 04:00:00	AAPL	Stock	135.51	135.8	135.22	135.6	43809.0
2021-02-02 05:00:00	AAPL	Stock	135.66	135.8	135.48	135.69	25589.0
2021-02-02 06:00:00	AAPL	Stock	135.74	135.8	135.22	135.49	40416.0
2021-02-02 07:00:00	AAPL	Stock	135.45	135.55	135.25	135.479	271007.0
2021-02-02 08:00:00	AAPL	Stock	135.3	136.45	134.47	136.03	867991.0
2021-02-02 09:00:00	AAPL	Stock	136.03	136.31	134.14	135.43	12792571.0
2021-02-02 10:00:00	AAPL	Stock	135.435	136.03	135.02	135.48	12198297.0
2021-02-02 11:00:00	AAPL	Stock	135.475	135.66	134.85	135.03	7861219.0
2021-02-02 12:00:00	AAPL	Stock	135.04	135.48	134.9	135.0	6006909.0
2021-02-02 13:00:00	AAPL	Stock	135.01	135.19	134.62	134.989	5868284.0
2021-02-02 14:00:00	AAPL	Stock	134.98	135.13	134.74	134.86	5211763.0
2021-02-02 15:00:00	AAPL	Stock	134.87	135.45	134.61	134.98	11155837.0
2021-02-02 16:00:00	AAPL	Stock	134.98	135.3	134.53	135.05	7436875.0
2021-02-02 17:00:00	AAPL	Stock	135.06	135.26	135.0	135.08	179446.0
2021-02-02 18:00:00	AAPL	Stock	135.07	135.12	134.81	134.95	160611.0
2021-02-02 19:00:00	AAPL	Stock	134.91	135.4	134.9	135.35	239470.0
2021-02-02 04:00:00	MSFT	Stock	240.65	241.32	240.65	241.32	1248.0
2021-02-02 05:00:00	MSFT	Stock	241.74	241.79	241.22	241.65	4358.0
2021-02-02 06:00:00	MSFT	Stock	241.65	241.71	241.25	241.25	5324.0
2021-02-02 07:00:00	MSFT	Stock	241.35	241.95	241.28	241.79	54515.0
2021-02-02 08:00:00	MSFT	Stock	241.7	241.95	239.06	241.35	86183.0
2021-02-02 09:00:00	MSFT	Stock	241.32	242.31	239.68	240.665	3250139.0
2021-02-02 10:00:00	MSFT	Stock	240.67	241.28	239.19	240.16	2788273.0
2021-02-02 11:00:00	MSFT	Stock	240.13	240.5	238.69	240.45	2440009.0
2021-02-02 12:00:00	MSFT	Stock	240.45	240.45	239.66	240.205	1559696.0
2021-02-02 13:00:00	MSFT	Stock	240.21	240.85	239.44	240.81	1663085.0
2021-02-02 14:00:00	MSFT	Stock	240.81	241.47	240.17	241.3	1847887.0
2021-02-02 15:00:00	MSFT	Stock	241.29	241.3	239.3	239.48	3126328.0
2021-02-02 16:00:00	MSFT	Stock	239.47	240.03	238.42	239.35	3339892.0
2021-02-02 17:00:00	MSFT	Stock	239.35	239.74	239.25	239.42	23405.0
2021-02-02 18:00:00	MSFT	Stock	239.47	239.7	238.8	239.3	27619.0
2021-02-02 19:00:00	MSFT	Stock	239.3	240.39	239.15	240.2	21266.0
2021-02-02 04:00:00	NVDA	Stock	13.3262	13.3262	13.3262	13.3262	9160.0
2021-02-02 05:00:00	NVDA	Stock	13.3812	13.3812	13.3812	13.3812	8000.0
2021-02-02 06:00:00	NVDA	Stock	13.3798	13.4	13.35	13.35	35480.0
2021-02-02 07:00:00	NVDA	Stock	13.3302	13.4482	13.325	13.395	532680.0
2021-02-02 08:00:00	NVDA	Stock	13.3249	13.45	13.3249	13.3675	341360.0
2021-02-02 09:00:00	NVDA	Stock	13.3725	13.5114	13.34	13.4064	28152760.0
2021-02-02 10:00:00	NVDA	Stock	13.4065	13.4442	13.2855	13.3792	28127560.0
2021-02-02 11:00:00	NVDA	Stock	13.3792	13.4425	13.3138	13.4342	17781560.0
2021-02-02 12:00:00	NVDA	Stock	13.4295	13.4634	13.404	13.4195	12834520.0
2021-02-02 13:00:00	NVDA	Stock	13.4222	13.4673	13.3695	13.454	12229080.0
2021-02-02 14:00:00	NVDA	Stock	13.4585	13.4998	13.4375	13.4938	13296600.0
2021-02-02 15:00:00	NVDA	Stock	13.4948	13.572	13.4791	13.557	42651120.0
2021-02-02 16:00:00	NVDA	Stock	13.5568	13.5575	13.5143	13.5575	3562440.0
2021-02-02 17:00:00	NVDA	Stock	13.5708	13.5738	13.5275	13.5555	190160.0
2021-02-02 18:00:00	NVDA	Stock	13.5625	13.5625	13.5288	13.5375	99680.0
2021-02-02 19:00:00	NVDA	Stock	13.538	13.587	13.538	13.587	252080.0
2021-02-02 04:00:00	AMZN	Stock	168.4805	169.0875	168.4805	169.0875	20020.0
2021-02-02 05:00:00	AMZN	Stock	169.2	169.3375	169.15	169.225	13200.0

> showing 50 of 68,059 rows — these rows as CSV

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