PREVIEW / stock_1hour / 2020-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-07.parquet
  size:    1.4 MB
  rows:    64,045
  symbols: 2,653

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-07 04:00:00	AAPL	Stock	122.0	122.0	121.2	121.56	33269.0
2020-12-07 05:00:00	AAPL	Stock	121.51	121.88	121.51	121.84	15020.0
2020-12-07 06:00:00	AAPL	Stock	121.84	122.4	121.84	122.3	32853.0
2020-12-07 07:00:00	AAPL	Stock	122.2	122.47	121.98	122.16	95884.0
2020-12-07 08:00:00	AAPL	Stock	122.13	122.52	121.966	122.52	281013.0
2020-12-07 09:00:00	AAPL	Stock	122.55	124.53	122.22	124.45	15989770.0
2020-12-07 10:00:00	AAPL	Stock	124.44	124.57	123.697	124.035	12785730.0
2020-12-07 11:00:00	AAPL	Stock	124.03	124.36	123.73	124.09	7484035.0
2020-12-07 12:00:00	AAPL	Stock	124.09	124.27	123.79	124.075	6407764.0
2020-12-07 13:00:00	AAPL	Stock	124.077	124.09	123.41	123.905	7258556.0
2020-12-07 14:00:00	AAPL	Stock	123.91	124.29	123.77	124.01	5952715.0
2020-12-07 15:00:00	AAPL	Stock	124.028	124.05	123.3	123.8	9396595.0
2020-12-07 16:00:00	AAPL	Stock	123.75	123.84	123.51	123.57	9958095.0
2020-12-07 17:00:00	AAPL	Stock	123.6	123.71	123.55	123.6	63285.0
2020-12-07 18:00:00	AAPL	Stock	123.64	123.66	123.56	123.6	45669.0
2020-12-07 19:00:00	AAPL	Stock	123.61	123.66	123.5	123.52	72225.0
2020-12-07 04:00:00	MSFT	Stock	214.1	215.2	214.01	215.02	11917.0
2020-12-07 05:00:00	MSFT	Stock	214.98	216.4	214.98	216.2	20751.0
2020-12-07 06:00:00	MSFT	Stock	216.13	216.15	216.0	216.0	4998.0
2020-12-07 07:00:00	MSFT	Stock	215.65	215.74	214.8	214.95	45015.0
2020-12-07 08:00:00	MSFT	Stock	214.95	215.2	214.54	214.8	30773.0
2020-12-07 09:00:00	MSFT	Stock	214.67	215.54	214.12	215.08	2268085.0
2020-12-07 10:00:00	MSFT	Stock	215.08	215.29	213.77	213.795	2685164.0
2020-12-07 11:00:00	MSFT	Stock	213.79	214.285	213.72	213.83	1581842.0
2020-12-07 12:00:00	MSFT	Stock	213.82	214.08	213.4	213.685	1548563.0
2020-12-07 13:00:00	MSFT	Stock	213.68	213.76	212.99	213.372	1494926.0
2020-12-07 14:00:00	MSFT	Stock	213.36	213.74	213.08	213.6	1198447.0
2020-12-07 15:00:00	MSFT	Stock	213.6	214.33	213.03	214.32	2592993.0
2020-12-07 16:00:00	MSFT	Stock	214.29	214.32	213.65	213.7	5942004.0
2020-12-07 17:00:00	MSFT	Stock	213.7	213.9	213.7	213.8	3556.0
2020-12-07 18:00:00	MSFT	Stock	213.84	213.99	213.7	213.7	5733.0
2020-12-07 19:00:00	MSFT	Stock	213.8	213.8	213.67	213.7	12547.0
2020-12-07 05:00:00	NVDA	Stock	13.5475	13.5475	13.5333	13.5333	40280.0
2020-12-07 06:00:00	NVDA	Stock	13.4875	13.4875	13.4835	13.4875	47800.0
2020-12-07 07:00:00	NVDA	Stock	13.495	13.505	13.495	13.5028	120440.0
2020-12-07 08:00:00	NVDA	Stock	13.5028	13.535	13.4925	13.535	277960.0
2020-12-07 09:00:00	NVDA	Stock	13.5375	13.7312	13.5375	13.646	35379760.0
2020-12-07 10:00:00	NVDA	Stock	13.649	13.7312	13.6192	13.6334	29056440.0
2020-12-07 11:00:00	NVDA	Stock	13.6312	13.682	13.5648	13.6075	19474160.0
2020-12-07 12:00:00	NVDA	Stock	13.605	13.6058	13.5535	13.5726	36071840.0
2020-12-07 13:00:00	NVDA	Stock	13.5705	13.5729	13.5	13.565	15511360.0
2020-12-07 14:00:00	NVDA	Stock	13.5669	13.5948	13.538	13.5585	7906160.0
2020-12-07 15:00:00	NVDA	Stock	13.5632	13.611	13.5178	13.6108	20577880.0
2020-12-07 16:00:00	NVDA	Stock	13.6068	13.615	13.575	13.575	20046040.0
2020-12-07 17:00:00	NVDA	Stock	13.5755	13.5775	13.5588	13.5588	54480.0
2020-12-07 18:00:00	NVDA	Stock	13.5872	13.5872	13.5872	13.5872	8840.0
2020-12-07 19:00:00	NVDA	Stock	13.5762	13.5875	13.5625	13.5875	116520.0
2020-12-07 05:00:00	AMZN	Stock	158.0	158.25	158.0	158.25	7380.0
2020-12-07 07:00:00	AMZN	Stock	158.25	158.25	157.45	157.5	168300.0
2020-12-07 08:00:00	AMZN	Stock	158.05	158.2575	157.5	157.88	116020.0

> showing 50 of 64,045 rows — these rows as CSV

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