PREVIEW / stock_1hour / 2019-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-19.parquet
  size:    1.1 MB
  rows:    50,489
  symbols: 2,553

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-09-19 04:00:00	AAPL	Stock	55.54	55.6075	55.5	55.5275	24404.0
2019-09-19 05:00:00	AAPL	Stock	55.55	55.55	55.55	55.55	756.0
2019-09-19 06:00:00	AAPL	Stock	55.525	55.525	55.435	55.465	20400.0
2019-09-19 07:00:00	AAPL	Stock	55.4825	55.6	55.4475	55.6	149388.0
2019-09-19 08:00:00	AAPL	Stock	55.45	55.7975	55.445	55.725	390840.0
2019-09-19 09:00:00	AAPL	Stock	55.7225	55.81	55.4775	55.7275	13120784.0
2019-09-19 10:00:00	AAPL	Stock	55.7275	55.94	55.6425	55.815	10716440.0
2019-09-19 11:00:00	AAPL	Stock	55.8125	55.8475	55.49	55.54	9701268.0
2019-09-19 12:00:00	AAPL	Stock	55.5425	55.575	55.1925	55.3438	8204060.0
2019-09-19 13:00:00	AAPL	Stock	55.3425	55.425	55.0925	55.3962	7903724.0
2019-09-19 14:00:00	AAPL	Stock	55.395	55.43	55.1875	55.2698	6855032.0
2019-09-19 15:00:00	AAPL	Stock	55.2688	55.375	55.1875	55.2375	10956836.0
2019-09-19 16:00:00	AAPL	Stock	55.2525	55.275	55.21	55.275	7334356.0
2019-09-19 17:00:00	AAPL	Stock	55.275	55.285	55.215	55.2175	38748.0
2019-09-19 18:00:00	AAPL	Stock	55.24	55.285	55.24	55.28	32852.0
2019-09-19 19:00:00	AAPL	Stock	55.265	55.32	55.24	55.2975	62264.0
2019-09-19 04:00:00	MSFT	Stock	140.0	140.2	140.0	140.1	2734.0
2019-09-19 05:00:00	MSFT	Stock	140.1	140.2	140.06	140.1	3672.0
2019-09-19 06:00:00	MSFT	Stock	140.17	140.29	139.88	139.95	11585.0
2019-09-19 07:00:00	MSFT	Stock	139.99	140.3	139.77	140.22	56835.0
2019-09-19 08:00:00	MSFT	Stock	140.22	140.6	138.52	140.45	166613.0
2019-09-19 09:00:00	MSFT	Stock	140.45	141.9	140.13	141.69	7523209.0
2019-09-19 10:00:00	MSFT	Stock	141.685	142.37	141.63	141.76	5539967.0
2019-09-19 11:00:00	MSFT	Stock	141.762	141.81	141.115	141.295	2806536.0
2019-09-19 12:00:00	MSFT	Stock	141.29	141.51	140.63	140.666	2399848.0
2019-09-19 13:00:00	MSFT	Stock	140.66	140.97	140.074	140.947	2922597.0
2019-09-19 14:00:00	MSFT	Stock	140.945	141.22	140.89	141.08	1729938.0
2019-09-19 15:00:00	MSFT	Stock	141.08	141.19	140.64	141.08	4473097.0
2019-09-19 16:00:00	MSFT	Stock	141.07	141.1	140.81	140.89	3385625.0
2019-09-19 17:00:00	MSFT	Stock	140.95	141.07	140.9	141.07	5437.0
2019-09-19 18:00:00	MSFT	Stock	141.07	141.1	140.98	141.1	6808.0
2019-09-19 19:00:00	MSFT	Stock	141.1	141.15	141.07	141.07	11598.0
2019-09-19 06:00:00	NVDA	Stock	4.4815	4.4815	4.4815	4.4815	4000.0
2019-09-19 07:00:00	NVDA	Stock	4.482	4.4922	4.482	4.4918	202240.0
2019-09-19 08:00:00	NVDA	Stock	4.4825	4.5275	4.4825	4.525	823680.0
2019-09-19 09:00:00	NVDA	Stock	4.525	4.5322	4.4855	4.4955	38668520.0
2019-09-19 10:00:00	NVDA	Stock	4.4958	4.5088	4.4892	4.4974	27887320.0
2019-09-19 11:00:00	NVDA	Stock	4.4975	4.5025	4.471	4.4725	25217040.0
2019-09-19 12:00:00	NVDA	Stock	4.4726	4.4795	4.4468	4.4598	23448960.0
2019-09-19 13:00:00	NVDA	Stock	4.4602	4.4625	4.425	4.4312	24150720.0
2019-09-19 14:00:00	NVDA	Stock	4.431	4.4382	4.4215	4.43	20282120.0
2019-09-19 15:00:00	NVDA	Stock	4.4295	4.436	4.4128	4.4228	42192800.0
2019-09-19 16:00:00	NVDA	Stock	4.4325	4.4325	4.4175	4.4235	23421400.0
2019-09-19 17:00:00	NVDA	Stock	4.4228	4.4228	4.417	4.417	68840.0
2019-09-19 18:00:00	NVDA	Stock	4.4172	4.4238	4.4172	4.4232	32560.0
2019-09-19 19:00:00	NVDA	Stock	4.4263	4.427	4.4188	4.425	180960.0
2019-09-19 05:00:00	AMZN	Stock	90.7	90.7	90.7	90.7	6000.0
2019-09-19 07:00:00	AMZN	Stock	90.6	90.7945	90.6	90.77	25820.0
2019-09-19 08:00:00	AMZN	Stock	90.675	91.15	90.675	91.13	185660.0
2019-09-19 09:00:00	AMZN	Stock	91.1125	91.4608	90.9678	91.375	8189980.0

> showing 50 of 50,489 rows — these rows as CSV

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