PREVIEW / stock_1hour / 2020-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-24.parquet
  size:    962 KB
  rows:    41,392
  symbols: 2,659

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-12-24 04:00:00	AAPL	Stock	131.05	131.15	131.0	131.0	12928.0
2020-12-24 05:00:00	AAPL	Stock	131.01	131.05	130.7	130.7	7558.0
2020-12-24 06:00:00	AAPL	Stock	130.77	130.98	130.69	130.9	13888.0
2020-12-24 07:00:00	AAPL	Stock	131.0	131.1	130.93	131.07	124651.0
2020-12-24 08:00:00	AAPL	Stock	131.05	131.46	130.9	131.27	410230.0
2020-12-24 09:00:00	AAPL	Stock	131.28	133.18	131.07	132.481	12819813.0
2020-12-24 10:00:00	AAPL	Stock	132.48	133.46	132.24	132.515	14695453.0
2020-12-24 11:00:00	AAPL	Stock	132.515	132.64	131.65	131.86	9165248.0
2020-12-24 12:00:00	AAPL	Stock	131.86	132.15	131.59	131.99	9397832.0
2020-12-24 13:00:00	AAPL	Stock	131.97	132.07	131.9	131.92	1877812.0
2020-12-24 14:00:00	AAPL	Stock	131.94	131.99	131.89	131.9	49771.0
2020-12-24 15:00:00	AAPL	Stock	131.96	131.96	131.85	131.89	34819.0
2020-12-24 16:00:00	AAPL	Stock	131.9	132.0	131.89	131.99	23186.0
2020-12-24 05:00:00	MSFT	Stock	221.12	221.12	221.12	221.12	100.0
2020-12-24 07:00:00	MSFT	Stock	221.29	221.77	221.29	221.43	2724.0
2020-12-24 08:00:00	MSFT	Stock	221.888	221.888	220.47	221.57	8644.0
2020-12-24 09:00:00	MSFT	Stock	221.5	222.945	221.2	222.08	1426530.0
2020-12-24 10:00:00	MSFT	Stock	222.07	223.61	222.07	222.11	2120034.0
2020-12-24 11:00:00	MSFT	Stock	222.11	222.4	221.269	221.67	1491394.0
2020-12-24 12:00:00	MSFT	Stock	221.679	223.5	221.44	222.71	2621479.0
2020-12-24 13:00:00	MSFT	Stock	222.75	223.0	222.41	222.6	885147.0
2020-12-24 14:00:00	MSFT	Stock	222.6	222.7	222.59	222.635	1295.0
2020-12-24 15:00:00	MSFT	Stock	222.59	222.59	222.5	222.5	3848.0
2020-12-24 16:00:00	MSFT	Stock	222.5	222.55	222.45	222.51	3022.0
2020-12-24 07:00:00	NVDA	Stock	13.0588	13.0625	13.0445	13.0562	144880.0
2020-12-24 08:00:00	NVDA	Stock	13.0571	13.0648	13.0175	13.041	483680.0
2020-12-24 09:00:00	NVDA	Stock	13.0375	13.1325	13.0093	13.0975	17841920.0
2020-12-24 10:00:00	NVDA	Stock	13.1	13.1035	12.9786	12.9786	18102160.0
2020-12-24 11:00:00	NVDA	Stock	12.9786	13.0153	12.9425	12.9888	14984160.0
2020-12-24 12:00:00	NVDA	Stock	12.9885	13.0059	12.9387	12.9928	23203120.0
2020-12-24 13:00:00	NVDA	Stock	12.9933	13.0125	12.975	12.9875	4297880.0
2020-12-24 14:00:00	NVDA	Stock	12.985	12.985	12.9775	12.9775	45040.0
2020-12-24 15:00:00	NVDA	Stock	12.9822	12.9822	12.968	12.9775	213680.0
2020-12-24 16:00:00	NVDA	Stock	12.985	12.985	12.985	12.985	4000.0
2020-12-24 04:00:00	AMZN	Stock	160.123	160.123	160.123	160.123	3800.0
2020-12-24 06:00:00	AMZN	Stock	159.85	160.1	159.85	160.1	8820.0
2020-12-24 07:00:00	AMZN	Stock	159.645	159.6995	159.645	159.6515	14000.0
2020-12-24 08:00:00	AMZN	Stock	159.555	159.7445	159.555	159.6965	52200.0
2020-12-24 09:00:00	AMZN	Stock	159.55	160.1	159.3	159.345	5152320.0
2020-12-24 10:00:00	AMZN	Stock	159.3865	159.714	158.7505	158.8156	5712520.0
2020-12-24 11:00:00	AMZN	Stock	158.7955	159.385	158.6401	158.874	4439080.0
2020-12-24 12:00:00	AMZN	Stock	158.872	158.9785	158.45	158.558	4749860.0
2020-12-24 13:00:00	AMZN	Stock	158.6345	158.6504	158.35	158.6345	1174920.0
2020-12-24 14:00:00	AMZN	Stock	158.6345	158.975	158.6345	158.6562	11640.0
2020-12-24 15:00:00	AMZN	Stock	158.55	158.55	158.45	158.55	17300.0
2020-12-24 16:00:00	AMZN	Stock	158.6	158.6	158.6	158.6	2000.0
2020-12-24 09:00:00	GOOGL	Stock	86.45	87.1205	86.35	86.6595	787960.0
2020-12-24 10:00:00	GOOGL	Stock	86.7035	86.8	86.25	86.2685	511980.0
2020-12-24 11:00:00	GOOGL	Stock	86.251	86.601	86.2175	86.352	804880.0
2020-12-24 12:00:00	GOOGL	Stock	86.3589	86.8085	86.2505	86.7375	1447180.0

> showing 50 of 41,392 rows — these rows as CSV

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