PREVIEW / stock_1hour / 2019-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-04.parquet
  size:    1.1 MB
  rows:    48,388
  symbols: 2,519

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
2019-10-04 04:00:00	AAPL	Stock	55.675	56.1175	55.675	56.0625	115696.0
2019-10-04 05:00:00	AAPL	Stock	56.0075	56.1	55.75	55.88	128776.0
2019-10-04 06:00:00	AAPL	Stock	55.8875	56.025	55.875	55.9375	61680.0
2019-10-04 07:00:00	AAPL	Stock	55.88	56.1075	55.805	56.085	714116.0
2019-10-04 08:00:00	AAPL	Stock	56.08	56.5375	55.85	56.5	2135688.0
2019-10-04 09:00:00	AAPL	Stock	56.485	56.59	55.9725	56.2075	21921216.0
2019-10-04 10:00:00	AAPL	Stock	56.225	56.35	56.0625	56.285	15538716.0
2019-10-04 11:00:00	AAPL	Stock	56.285	56.5475	56.23	56.51	15909224.0
2019-10-04 12:00:00	AAPL	Stock	56.5075	56.53	56.365	56.4875	8307456.0
2019-10-04 13:00:00	AAPL	Stock	56.4875	56.615	56.4375	56.5788	7886216.0
2019-10-04 14:00:00	AAPL	Stock	56.58	56.8725	56.5625	56.7242	14313556.0
2019-10-04 15:00:00	AAPL	Stock	56.7275	56.7875	56.53	56.7525	21852444.0
2019-10-04 16:00:00	AAPL	Stock	56.7525	56.865	56.6675	56.7625	8851652.0
2019-10-04 17:00:00	AAPL	Stock	56.77	56.8	56.7525	56.77	74708.0
2019-10-04 18:00:00	AAPL	Stock	56.7625	56.7725	56.7525	56.7625	32248.0
2019-10-04 19:00:00	AAPL	Stock	56.765	56.7725	56.68	56.7375	96112.0
2019-10-04 04:00:00	MSFT	Stock	136.43	136.43	135.63	135.63	2156.0
2019-10-04 05:00:00	MSFT	Stock	135.93	135.99	135.41	135.75	3251.0
2019-10-04 06:00:00	MSFT	Stock	135.75	135.75	135.72	135.72	307.0
2019-10-04 07:00:00	MSFT	Stock	135.84	135.95	135.78	135.82	8798.0
2019-10-04 08:00:00	MSFT	Stock	135.76	136.855	135.54	136.57	62523.0
2019-10-04 09:00:00	MSFT	Stock	136.61	137.75	136.42	137.67	2541628.0
2019-10-04 10:00:00	MSFT	Stock	137.68	137.89	136.88	137.045	2310310.0
2019-10-04 11:00:00	MSFT	Stock	137.05	137.87	136.72	137.67	2444418.0
2019-10-04 12:00:00	MSFT	Stock	137.66	137.77	137.2	137.491	1938617.0
2019-10-04 13:00:00	MSFT	Stock	137.5	137.89	137.23	137.53	967107.0
2019-10-04 14:00:00	MSFT	Stock	137.53	138.01	137.45	137.96	1421386.0
2019-10-04 15:00:00	MSFT	Stock	137.97	138.25	137.83	138.11	3728763.0
2019-10-04 16:00:00	MSFT	Stock	138.12	138.28	137.98	138.13	4963558.0
2019-10-04 17:00:00	MSFT	Stock	138.25	138.25	138.08	138.19	7085.0
2019-10-04 18:00:00	MSFT	Stock	138.14	138.2	138.14	138.2	3467.0
2019-10-04 19:00:00	MSFT	Stock	138.18	138.25	138.15	138.25	2207.0
2019-10-04 06:00:00	NVDA	Stock	4.5125	4.5125	4.5125	4.5125	20000.0
2019-10-04 07:00:00	NVDA	Stock	4.5125	4.5125	4.5042	4.508	494080.0
2019-10-04 08:00:00	NVDA	Stock	4.5078	4.55	4.5033	4.5405	1587520.0
2019-10-04 09:00:00	NVDA	Stock	4.5375	4.6495	4.4695	4.563	49761080.0
2019-10-04 10:00:00	NVDA	Stock	4.5653	4.5788	4.5235	4.5292	41841600.0
2019-10-04 11:00:00	NVDA	Stock	4.529	4.5495	4.5138	4.5428	21034040.0
2019-10-04 12:00:00	NVDA	Stock	4.5429	4.5585	4.53	4.5318	13279720.0
2019-10-04 13:00:00	NVDA	Stock	4.5333	4.5413	4.5182	4.5255	16063880.0
2019-10-04 14:00:00	NVDA	Stock	4.5268	4.5446	4.523	4.535	20226840.0
2019-10-04 15:00:00	NVDA	Stock	4.5348	4.555	4.5268	4.551	50989520.0
2019-10-04 16:00:00	NVDA	Stock	4.5492	4.5562	4.5475	4.5492	2517200.0
2019-10-04 17:00:00	NVDA	Stock	4.5502	4.5538	4.5475	4.5538	111760.0
2019-10-04 18:00:00	NVDA	Stock	4.5472	4.5538	4.5472	4.5538	73520.0
2019-10-04 19:00:00	NVDA	Stock	4.5472	4.5525	4.5472	4.5525	68840.0
2019-10-04 04:00:00	AMZN	Stock	86.2555	86.2555	86.2555	86.2555	4020.0
2019-10-04 05:00:00	AMZN	Stock	86.004	86.004	85.95	85.95	7200.0
2019-10-04 06:00:00	AMZN	Stock	85.9205	85.9205	85.9205	85.9205	2000.0
2019-10-04 07:00:00	AMZN	Stock	86.0	86.0	85.904	85.95	27340.0

> showing 50 of 48,388 rows — these rows as CSV

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