PREVIEW / stock_1hour / 2020-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-21.parquet
  size:    1.2 MB
  rows:    56,432
  symbols: 2,448

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-08-21 04:00:00	AAPL	Stock	119.345	119.345	118.88	119.0625	68508.0
2020-08-21 05:00:00	AAPL	Stock	119.0625	119.3175	119.06	119.215	31944.0
2020-08-21 06:00:00	AAPL	Stock	119.23	119.2325	118.755	118.8	98048.0
2020-08-21 07:00:00	AAPL	Stock	118.935	119.2025	118.8	118.825	838208.0
2020-08-21 08:00:00	AAPL	Stock	119.0988	119.3125	118.5	119.2662	1741744.0
2020-08-21 09:00:00	AAPL	Stock	119.27	120.8475	119.15	120.755	33235644.0
2020-08-21 10:00:00	AAPL	Stock	120.7788	123.2375	120.385	123.119	50762624.0
2020-08-21 11:00:00	AAPL	Stock	123.11	123.3975	121.94	122.0625	42231160.0
2020-08-21 12:00:00	AAPL	Stock	122.055	123.1698	121.9775	123.1058	23632456.0
2020-08-21 13:00:00	AAPL	Stock	123.1028	123.1525	122.16	122.6325	20574096.0
2020-08-21 14:00:00	AAPL	Stock	122.6282	124.0725	122.595	124.025	27950476.0
2020-08-21 15:00:00	AAPL	Stock	124.0175	124.868	123.625	124.35	56483964.0
2020-08-21 16:00:00	AAPL	Stock	124.35	124.7225	121.55	124.715	8402812.0
2020-08-21 17:00:00	AAPL	Stock	124.7175	124.725	124.6175	124.675	454392.0
2020-08-21 18:00:00	AAPL	Stock	124.675	124.71	124.6175	124.6875	305472.0
2020-08-21 19:00:00	AAPL	Stock	124.6875	124.7475	124.625	124.7375	360588.0
2020-08-21 04:00:00	MSFT	Stock	214.07	214.19	213.53	213.84	4854.0
2020-08-21 05:00:00	MSFT	Stock	214.09	214.19	213.61	213.9	3081.0
2020-08-21 06:00:00	MSFT	Stock	213.57	213.84	213.08	213.49	6800.0
2020-08-21 07:00:00	MSFT	Stock	213.5	213.73	212.27	212.27	42337.0
2020-08-21 08:00:00	MSFT	Stock	213.3	213.75	212.082	213.17	77223.0
2020-08-21 09:00:00	MSFT	Stock	213.13	215.16	213.0	214.52	4861935.0
2020-08-21 10:00:00	MSFT	Stock	214.525	216.25	214.0	215.887	4311179.0
2020-08-21 11:00:00	MSFT	Stock	215.87	215.95	213.35	213.545	3086538.0
2020-08-21 12:00:00	MSFT	Stock	213.53	214.86	213.5	214.085	1762520.0
2020-08-21 13:00:00	MSFT	Stock	214.08	214.19	213.14	213.31	1552684.0
2020-08-21 14:00:00	MSFT	Stock	213.31	213.79	212.935	213.519	2032295.0
2020-08-21 15:00:00	MSFT	Stock	213.52	213.94	212.85	213.02	3367250.0
2020-08-21 16:00:00	MSFT	Stock	213.02	213.43	212.95	213.12	5760097.0
2020-08-21 17:00:00	MSFT	Stock	213.22	216.44	213.22	215.1	314934.0
2020-08-21 18:00:00	MSFT	Stock	215.12	215.48	214.63	214.71	37082.0
2020-08-21 19:00:00	MSFT	Stock	214.68	214.85	214.6	214.6	28139.0
2020-08-21 04:00:00	NVDA	Stock	12.18	12.18	12.1575	12.165	18400.0
2020-08-21 05:00:00	NVDA	Stock	12.1655	12.2168	12.1655	12.2168	16880.0
2020-08-21 06:00:00	NVDA	Stock	12.187	12.187	12.1295	12.1295	64320.0
2020-08-21 07:00:00	NVDA	Stock	12.175	12.1845	12.1088	12.1088	1168720.0
2020-08-21 08:00:00	NVDA	Stock	12.1746	12.185	12.0675	12.1248	2143240.0
2020-08-21 09:00:00	NVDA	Stock	12.1188	12.4623	12.1034	12.4535	140138520.0
2020-08-21 10:00:00	NVDA	Stock	12.455	12.5063	12.3968	12.4873	125514400.0
2020-08-21 11:00:00	NVDA	Stock	12.4873	12.6258	12.4185	12.5662	153186960.0
2020-08-21 12:00:00	NVDA	Stock	12.5645	12.7332	12.535	12.7016	124110200.0
2020-08-21 13:00:00	NVDA	Stock	12.7025	12.8087	12.6016	12.6098	134770880.0
2020-08-21 14:00:00	NVDA	Stock	12.6126	12.692	12.585	12.6253	97266360.0
2020-08-21 15:00:00	NVDA	Stock	12.625	12.7365	12.6088	12.678	94594000.0
2020-08-21 16:00:00	NVDA	Stock	12.6835	12.6835	12.6675	12.6798	23251840.0
2020-08-21 17:00:00	NVDA	Stock	12.6758	12.6793	12.6652	12.6738	408520.0
2020-08-21 18:00:00	NVDA	Stock	12.6652	12.6875	12.6652	12.6842	747040.0
2020-08-21 19:00:00	NVDA	Stock	12.6875	12.6912	12.6805	12.6838	393960.0
2020-08-21 04:00:00	AMZN	Stock	165.05	165.05	165.05	165.05	10680.0
2020-08-21 05:00:00	AMZN	Stock	165.1	165.1	165.1	165.1	2000.0

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

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