PREVIEW / stock_1hour / 2020-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-25.parquet
  size:    1.2 MB
  rows:    56,058
  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-03-25 04:00:00	AAPL	Stock	63.75	64.375	63.0075	64.25	223940.0
2020-03-25 05:00:00	AAPL	Stock	64.245	64.975	64.02	64.1825	109920.0
2020-03-25 06:00:00	AAPL	Stock	64.2875	64.2875	61.8275	61.8275	301464.0
2020-03-25 07:00:00	AAPL	Stock	62.0625	62.875	61.6375	62.1025	1101576.0
2020-03-25 08:00:00	AAPL	Stock	62.4825	62.875	61.625	62.75	1545692.0
2020-03-25 09:00:00	AAPL	Stock	62.8325	64.5625	62.45	62.7175	41239228.0
2020-03-25 10:00:00	AAPL	Stock	62.6675	62.6775	61.075	62.61	36172952.0
2020-03-25 11:00:00	AAPL	Stock	62.6275	63.75	62.5975	63.2975	29418820.0
2020-03-25 12:00:00	AAPL	Stock	63.32	63.9425	63.2575	63.4925	24372528.0
2020-03-25 13:00:00	AAPL	Stock	63.4978	64.325	63.445	63.8375	22761848.0
2020-03-25 14:00:00	AAPL	Stock	63.8512	64.005	63.1702	63.73	20876076.0
2020-03-25 15:00:00	AAPL	Stock	63.7422	64.2875	61.075	61.3662	47428108.0
2020-03-25 16:00:00	AAPL	Stock	61.385	61.6875	61.0875	61.5775	19991356.0
2020-03-25 17:00:00	AAPL	Stock	61.5625	61.8	61.45	61.75	304208.0
2020-03-25 18:00:00	AAPL	Stock	61.75	62.0675	61.66	61.95	306416.0
2020-03-25 19:00:00	AAPL	Stock	61.945	61.995	61.455	61.88	272296.0
2020-03-25 04:00:00	MSFT	Stock	150.0	153.47	150.0	153.47	41649.0
2020-03-25 05:00:00	MSFT	Stock	153.68	154.9	152.65	152.73	53909.0
2020-03-25 06:00:00	MSFT	Stock	152.98	153.5	147.0	147.2	50762.0
2020-03-25 07:00:00	MSFT	Stock	147.42	150.0	147.0	147.75	138171.0
2020-03-25 08:00:00	MSFT	Stock	148.9	149.89	147.0	149.25	209063.0
2020-03-25 09:00:00	MSFT	Stock	149.27	151.256	147.38	147.44	8675713.0
2020-03-25 10:00:00	MSFT	Stock	147.43	148.7	144.44	148.415	7221089.0
2020-03-25 11:00:00	MSFT	Stock	148.42	148.56	146.71	147.55	5275646.0
2020-03-25 12:00:00	MSFT	Stock	147.54	150.45	147.415	149.81	7037467.0
2020-03-25 13:00:00	MSFT	Stock	149.85	154.33	149.55	153.35	8164824.0
2020-03-25 14:00:00	MSFT	Stock	153.37	154.0	151.17	151.9	6728009.0
2020-03-25 15:00:00	MSFT	Stock	151.91	153.15	146.0	146.85	10774159.0
2020-03-25 16:00:00	MSFT	Stock	146.89	147.44	146.46	147.19	8546672.0
2020-03-25 17:00:00	MSFT	Stock	147.35	147.85	146.92	147.85	34402.0
2020-03-25 18:00:00	MSFT	Stock	147.55	148.5	147.5	147.8	38988.0
2020-03-25 19:00:00	MSFT	Stock	148.1	148.1	147.0	147.93	31480.0
2020-03-25 04:00:00	NVDA	Stock	6.3325	6.525	6.3325	6.48	538520.0
2020-03-25 05:00:00	NVDA	Stock	6.4558	6.5375	6.4365	6.4365	298480.0
2020-03-25 06:00:00	NVDA	Stock	6.45	6.45	6.125	6.1585	383200.0
2020-03-25 07:00:00	NVDA	Stock	6.148	6.3518	6.148	6.195	1761640.0
2020-03-25 08:00:00	NVDA	Stock	6.2875	6.35	6.1973	6.329	2438760.0
2020-03-25 09:00:00	NVDA	Stock	6.3313	6.5125	6.2673	6.2773	124824720.0
2020-03-25 10:00:00	NVDA	Stock	6.276	6.373	6.0915	6.3578	124469200.0
2020-03-25 11:00:00	NVDA	Stock	6.3559	6.4175	6.2853	6.3325	75920600.0
2020-03-25 12:00:00	NVDA	Stock	6.3315	6.4398	6.3295	6.3839	62889960.0
2020-03-25 13:00:00	NVDA	Stock	6.384	6.5455	6.363	6.4693	84904080.0
2020-03-25 14:00:00	NVDA	Stock	6.4715	6.5245	6.4114	6.4782	74284640.0
2020-03-25 15:00:00	NVDA	Stock	6.4768	6.5028	6.1208	6.137	110536280.0
2020-03-25 16:00:00	NVDA	Stock	6.1405	6.2188	6.1382	6.2075	7377160.0
2020-03-25 17:00:00	NVDA	Stock	6.2042	6.215	6.1875	6.195	508400.0
2020-03-25 18:00:00	NVDA	Stock	6.2	6.2375	6.195	6.2172	1236480.0
2020-03-25 19:00:00	NVDA	Stock	6.2045	6.2375	6.19	6.2375	847600.0
2020-03-25 04:00:00	AMZN	Stock	98.0	99.0	97.97	99.0	64340.0
2020-03-25 05:00:00	AMZN	Stock	99.15	99.15	99.15	99.15	15780.0

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

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