PREVIEW / stock_1hour / 2020-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-28.parquet
  size:    1.2 MB
  rows:    54,853
  symbols: 2,390

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-04-28 04:00:00	AAPL	Stock	71.125	71.125	71.0	71.0	1340.0
2020-04-28 05:00:00	AAPL	Stock	70.9725	71.3175	70.9725	71.3175	6960.0
2020-04-28 06:00:00	AAPL	Stock	71.55	71.7325	71.5025	71.5225	10756.0
2020-04-28 07:00:00	AAPL	Stock	71.5275	71.5525	71.29	71.4675	125508.0
2020-04-28 08:00:00	AAPL	Stock	71.42	71.55	71.205	71.3225	318248.0
2020-04-28 09:00:00	AAPL	Stock	71.2875	71.4575	71.0575	71.175	12331860.0
2020-04-28 10:00:00	AAPL	Stock	71.17	71.3525	70.16	70.2712	19568304.0
2020-04-28 11:00:00	AAPL	Stock	70.285	70.59	70.14	70.2875	10119668.0
2020-04-28 12:00:00	AAPL	Stock	70.2875	70.4125	69.8328	70.3625	10480924.0
2020-04-28 13:00:00	AAPL	Stock	70.3625	70.4325	70.045	70.2612	6768224.0
2020-04-28 14:00:00	AAPL	Stock	70.255	70.5125	70.1132	70.2062	6612788.0
2020-04-28 15:00:00	AAPL	Stock	70.205	70.6	69.55	69.6425	14627404.0
2020-04-28 16:00:00	AAPL	Stock	69.6425	70.3015	69.6275	69.945	6699916.0
2020-04-28 17:00:00	AAPL	Stock	69.9375	70.2	69.915	70.0425	121544.0
2020-04-28 18:00:00	AAPL	Stock	70.025	70.1725	69.9475	70.0475	95520.0
2020-04-28 19:00:00	AAPL	Stock	70.0475	70.2075	69.975	70.145	87700.0
2020-04-28 04:00:00	MSFT	Stock	175.08	175.15	175.05	175.05	759.0
2020-04-28 05:00:00	MSFT	Stock	175.5	176.7	175.5	176.7	9329.0
2020-04-28 06:00:00	MSFT	Stock	176.7	176.7	176.3	176.55	7418.0
2020-04-28 07:00:00	MSFT	Stock	176.37	176.37	175.25	175.83	74971.0
2020-04-28 08:00:00	MSFT	Stock	175.829	176.2	175.09	175.6	105741.0
2020-04-28 09:00:00	MSFT	Stock	175.65	175.7	173.86	173.99	3654151.0
2020-04-28 10:00:00	MSFT	Stock	173.97	174.18	170.59	170.96	5187616.0
2020-04-28 11:00:00	MSFT	Stock	171.0	171.8	170.319	171.105	3555669.0
2020-04-28 12:00:00	MSFT	Stock	171.11	171.3	170.17	171.25	2582343.0
2020-04-28 13:00:00	MSFT	Stock	171.245	171.85	171.11	171.46	2123435.0
2020-04-28 14:00:00	MSFT	Stock	171.44	171.87	170.72	170.845	2188128.0
2020-04-28 15:00:00	MSFT	Stock	170.84	171.5	169.39	169.79	5628701.0
2020-04-28 16:00:00	MSFT	Stock	169.81	171.5	169.74	170.66	3000471.0
2020-04-28 17:00:00	MSFT	Stock	170.7	172.4	170.67	172.03	167513.0
2020-04-28 18:00:00	MSFT	Stock	172.1	172.3	171.5	171.8	61665.0
2020-04-28 19:00:00	MSFT	Stock	171.81	172.45	171.66	172.39	46047.0
2020-04-28 05:00:00	NVDA	Stock	7.5	7.539	7.5	7.525	28640.0
2020-04-28 06:00:00	NVDA	Stock	7.5418	7.57	7.5418	7.57	45560.0
2020-04-28 07:00:00	NVDA	Stock	7.55	7.6202	7.5465	7.6125	1396440.0
2020-04-28 08:00:00	NVDA	Stock	7.555	7.62	7.55	7.5825	2339240.0
2020-04-28 09:00:00	NVDA	Stock	7.586	7.605	7.455	7.4631	71737240.0
2020-04-28 10:00:00	NVDA	Stock	7.4603	7.5055	7.2785	7.2899	97143560.0
2020-04-28 11:00:00	NVDA	Stock	7.2928	7.3912	7.29	7.3665	57725800.0
2020-04-28 12:00:00	NVDA	Stock	7.3678	7.3745	7.3025	7.3743	33494160.0
2020-04-28 13:00:00	NVDA	Stock	7.3745	7.4172	7.3562	7.3948	28194720.0
2020-04-28 14:00:00	NVDA	Stock	7.3955	7.4394	7.356	7.3658	35321280.0
2020-04-28 15:00:00	NVDA	Stock	7.3662	7.3942	7.2805	7.2885	48899800.0
2020-04-28 16:00:00	NVDA	Stock	7.284	7.345	7.1938	7.2375	16804200.0
2020-04-28 17:00:00	NVDA	Stock	7.2375	7.297	7.2375	7.2875	747760.0
2020-04-28 18:00:00	NVDA	Stock	7.29	7.3218	7.24	7.2538	884080.0
2020-04-28 19:00:00	NVDA	Stock	7.2665	7.32	7.2505	7.3138	331000.0
2020-04-28 04:00:00	AMZN	Stock	119.5	119.5	119.5	119.5	2000.0
2020-04-28 05:00:00	AMZN	Stock	119.75	119.7725	119.675	119.7	24700.0
2020-04-28 06:00:00	AMZN	Stock	119.7	119.7	119.508	119.633	20360.0

> showing 50 of 54,853 rows — these rows as CSV

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