PREVIEW / stock_1hour / 2020-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-18.parquet
  size:    1.3 MB
  rows:    59,706
  symbols: 2,559

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-11-18 04:00:00	AAPL	Stock	119.4	119.56	119.4	119.46	10832.0
2020-11-18 05:00:00	AAPL	Stock	119.42	119.86	119.42	119.86	32540.0
2020-11-18 06:00:00	AAPL	Stock	119.75	119.88	118.63	118.96	126749.0
2020-11-18 07:00:00	AAPL	Stock	118.98	119.5	118.97	119.27	252591.0
2020-11-18 08:00:00	AAPL	Stock	119.2	119.53	118.9	118.93	489231.0
2020-11-18 09:00:00	AAPL	Stock	118.95	119.438	118.24	118.79	12172080.0
2020-11-18 10:00:00	AAPL	Stock	118.77	119.5	118.4	119.485	9733867.0
2020-11-18 11:00:00	AAPL	Stock	119.49	119.59	119.07	119.515	6434774.0
2020-11-18 12:00:00	AAPL	Stock	119.511	119.82	119.44	119.55	5657419.0
2020-11-18 13:00:00	AAPL	Stock	119.54	119.7	119.12	119.315	5444693.0
2020-11-18 14:00:00	AAPL	Stock	119.315	119.335	118.8	119.335	6205083.0
2020-11-18 15:00:00	AAPL	Stock	119.33	119.62	118.0	118.0	12126494.0
2020-11-18 16:00:00	AAPL	Stock	118.03	119.137	117.72	117.98	7387752.0
2020-11-18 17:00:00	AAPL	Stock	117.98	118.03	117.84	117.96	100690.0
2020-11-18 18:00:00	AAPL	Stock	117.95	118.07	117.95	118.0	57332.0
2020-11-18 19:00:00	AAPL	Stock	118.0	118.0	117.82	117.87	88995.0
2020-11-18 04:00:00	MSFT	Stock	214.57	214.64	214.32	214.5	1545.0
2020-11-18 05:00:00	MSFT	Stock	214.83	214.97	214.56	214.62	982.0
2020-11-18 06:00:00	MSFT	Stock	214.06	214.74	214.05	214.3	5225.0
2020-11-18 07:00:00	MSFT	Stock	214.58	214.68	214.25	214.46	20528.0
2020-11-18 08:00:00	MSFT	Stock	214.3	214.7	214.2	214.35	46565.0
2020-11-18 09:00:00	MSFT	Stock	214.3	215.17	213.05	213.289	3057945.0
2020-11-18 10:00:00	MSFT	Stock	213.24	213.43	211.88	212.68	4487875.0
2020-11-18 11:00:00	MSFT	Stock	212.67	213.061	212.35	213.061	1635105.0
2020-11-18 12:00:00	MSFT	Stock	213.05	213.58	212.76	212.972	1313356.0
2020-11-18 13:00:00	MSFT	Stock	212.96	213.1	211.93	212.21	1663107.0
2020-11-18 14:00:00	MSFT	Stock	212.15	212.75	211.82	212.62	1746928.0
2020-11-18 15:00:00	MSFT	Stock	212.61	213.2	210.93	210.97	3927997.0
2020-11-18 16:00:00	MSFT	Stock	211.08	211.58	210.7	211.01	4056714.0
2020-11-18 17:00:00	MSFT	Stock	211.07	211.232	211.0	211.232	16380.0
2020-11-18 18:00:00	MSFT	Stock	211.15	211.34	211.15	211.25	6297.0
2020-11-18 19:00:00	MSFT	Stock	211.2	211.25	210.91	211.15	17664.0
2020-11-18 04:00:00	NVDA	Stock	13.49	13.5125	13.4835	13.5125	74280.0
2020-11-18 05:00:00	NVDA	Stock	13.5213	13.525	13.5	13.5	65320.0
2020-11-18 06:00:00	NVDA	Stock	13.475	13.475	13.4252	13.4375	64920.0
2020-11-18 07:00:00	NVDA	Stock	13.4712	13.4895	13.4425	13.4842	837880.0
2020-11-18 08:00:00	NVDA	Stock	13.4626	13.4993	13.45	13.475	1411720.0
2020-11-18 09:00:00	NVDA	Stock	13.475	13.4785	13.185	13.247	63817120.0
2020-11-18 10:00:00	NVDA	Stock	13.2455	13.4875	13.204	13.4867	67065800.0
2020-11-18 11:00:00	NVDA	Stock	13.4868	13.4958	13.3798	13.4715	35508000.0
2020-11-18 12:00:00	NVDA	Stock	13.4748	13.566	13.4725	13.5167	32666080.0
2020-11-18 13:00:00	NVDA	Stock	13.5155	13.5415	13.4282	13.464	26383840.0
2020-11-18 14:00:00	NVDA	Stock	13.4613	13.4848	13.4038	13.4795	29158400.0
2020-11-18 15:00:00	NVDA	Stock	13.4825	13.6058	13.4028	13.425	78001880.0
2020-11-18 16:00:00	NVDA	Stock	13.4288	13.7863	13.3022	13.445	66904040.0
2020-11-18 17:00:00	NVDA	Stock	13.4428	13.4635	12.95	12.9973	38032600.0
2020-11-18 18:00:00	NVDA	Stock	13.0	13.1745	12.9925	13.1725	9850280.0
2020-11-18 19:00:00	NVDA	Stock	13.174	13.209	13.1378	13.1625	6789080.0
2020-11-18 04:00:00	AMZN	Stock	157.5	157.5	157.5	157.5	5520.0
2020-11-18 05:00:00	AMZN	Stock	157.7055	157.7055	157.7055	157.7055	2000.0

> showing 50 of 59,706 rows — these rows as CSV

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