PREVIEW / stock_1hour / 2019-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-08.parquet
  size:    1.1 MB
  rows:    49,042
  symbols: 2,499

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-08 04:00:00	AAPL	Stock	56.755	56.885	56.755	56.8325	23048.0
2019-10-08 05:00:00	AAPL	Stock	56.8675	56.8875	56.7	56.75	48752.0
2019-10-08 06:00:00	AAPL	Stock	56.7175	56.7175	56.3675	56.46	70320.0
2019-10-08 07:00:00	AAPL	Stock	56.475	56.5175	56.2275	56.405	307120.0
2019-10-08 08:00:00	AAPL	Stock	56.355	56.625	56.2225	56.3675	343844.0
2019-10-08 09:00:00	AAPL	Stock	56.385	56.805	56.35	56.4575	14045388.0
2019-10-08 10:00:00	AAPL	Stock	56.4575	56.6212	56.265	56.565	16978536.0
2019-10-08 11:00:00	AAPL	Stock	56.5625	56.6562	56.33	56.525	9095608.0
2019-10-08 12:00:00	AAPL	Stock	56.525	56.87	56.405	56.6875	7366468.0
2019-10-08 13:00:00	AAPL	Stock	56.6875	56.8725	56.6325	56.7378	6550216.0
2019-10-08 14:00:00	AAPL	Stock	56.7375	57.015	56.2875	56.5675	11905164.0
2019-10-08 15:00:00	AAPL	Stock	56.5575	56.7225	56.0825	56.0975	15876516.0
2019-10-08 16:00:00	AAPL	Stock	56.1	56.1625	55.785	56.0	9977516.0
2019-10-08 17:00:00	AAPL	Stock	56.0	56.1	55.875	55.9775	251820.0
2019-10-08 18:00:00	AAPL	Stock	56.01	56.0525	55.9	55.9125	74088.0
2019-10-08 19:00:00	AAPL	Stock	55.9125	55.98	55.9	55.925	115796.0
2019-10-08 04:00:00	MSFT	Stock	137.88	138.18	137.88	138.18	9968.0
2019-10-08 05:00:00	MSFT	Stock	138.05	138.13	137.8	137.8	1100.0
2019-10-08 06:00:00	MSFT	Stock	137.81	137.81	137.2	137.3	20846.0
2019-10-08 07:00:00	MSFT	Stock	137.47	137.5	136.75	137.25	34912.0
2019-10-08 08:00:00	MSFT	Stock	137.0	137.5	136.82	137.25	55026.0
2019-10-08 09:00:00	MSFT	Stock	137.25	137.52	136.2	136.24	3070135.0
2019-10-08 10:00:00	MSFT	Stock	136.25	136.94	135.9	136.9	3443124.0
2019-10-08 11:00:00	MSFT	Stock	136.895	137.37	136.78	136.96	2496784.0
2019-10-08 12:00:00	MSFT	Stock	136.95	137.73	136.83	137.3	1680257.0
2019-10-08 13:00:00	MSFT	Stock	137.29	137.389	137.07	137.11	1073132.0
2019-10-08 14:00:00	MSFT	Stock	137.13	137.76	136.25	136.8	2445971.0
2019-10-08 15:00:00	MSFT	Stock	136.78	137.16	135.62	135.66	4759661.0
2019-10-08 16:00:00	MSFT	Stock	135.67	135.96	135.5	135.67	3202448.0
2019-10-08 17:00:00	MSFT	Stock	135.84	135.92	135.6	135.89	6224.0
2019-10-08 18:00:00	MSFT	Stock	135.88	136.0	135.67	135.67	12436.0
2019-10-08 19:00:00	MSFT	Stock	135.67	135.67	135.5	135.56	13851.0
2019-10-08 04:00:00	NVDA	Stock	4.6	4.6	4.5625	4.5703	56360.0
2019-10-08 05:00:00	NVDA	Stock	4.55	4.55	4.55	4.55	12000.0
2019-10-08 06:00:00	NVDA	Stock	4.55	4.55	4.55	4.55	8000.0
2019-10-08 07:00:00	NVDA	Stock	4.5462	4.5572	4.525	4.5572	421320.0
2019-10-08 08:00:00	NVDA	Stock	4.5342	4.555	4.5295	4.535	2325600.0
2019-10-08 09:00:00	NVDA	Stock	4.5375	4.545	4.4478	4.4575	66282000.0
2019-10-08 10:00:00	NVDA	Stock	4.4575	4.4615	4.4125	4.4434	89872080.0
2019-10-08 11:00:00	NVDA	Stock	4.4428	4.451	4.4158	4.4442	41405120.0
2019-10-08 12:00:00	NVDA	Stock	4.4442	4.486	4.436	4.459	45476400.0
2019-10-08 13:00:00	NVDA	Stock	4.4592	4.486	4.448	4.4725	23921720.0
2019-10-08 14:00:00	NVDA	Stock	4.4735	4.4995	4.439	4.4565	35690800.0
2019-10-08 15:00:00	NVDA	Stock	4.4576	4.4757	4.4288	4.4308	67641440.0
2019-10-08 16:00:00	NVDA	Stock	4.4308	4.4375	4.4275	4.428	5450040.0
2019-10-08 17:00:00	NVDA	Stock	4.428	4.4335	4.425	4.43	217760.0
2019-10-08 18:00:00	NVDA	Stock	4.4263	4.43	4.4155	4.42	617600.0
2019-10-08 19:00:00	NVDA	Stock	4.4128	4.4175	4.4075	4.4122	402400.0
2019-10-08 06:00:00	AMZN	Stock	86.25	86.25	86.15	86.15	8640.0
2019-10-08 07:00:00	AMZN	Stock	86.0005	86.1795	85.857	86.1405	98880.0

> showing 50 of 49,042 rows — these rows as CSV

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