PREVIEW / stock_1hour / 2020-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-17.parquet
  size:    1.2 MB
  rows:    56,877
  symbols: 2,484

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-09-17 04:00:00	AAPL	Stock	110.34	111.2	110.0	110.98	135831.0
2020-09-17 05:00:00	AAPL	Stock	111.08	111.6	110.76	111.4	44729.0
2020-09-17 06:00:00	AAPL	Stock	111.45	111.5	110.47	110.5	72644.0
2020-09-17 07:00:00	AAPL	Stock	110.67	111.0	109.8	109.96	1128100.0
2020-09-17 08:00:00	AAPL	Stock	109.95	111.0	109.27	109.46	2001709.0
2020-09-17 09:00:00	AAPL	Stock	109.5	110.85	108.65	110.37	25635821.0
2020-09-17 10:00:00	AAPL	Stock	110.36	111.525	109.8	110.905	23344447.0
2020-09-17 11:00:00	AAPL	Stock	110.91	112.2	110.2	110.3	19118405.0
2020-09-17 12:00:00	AAPL	Stock	110.29	110.67	108.96	109.75	21204211.0
2020-09-17 13:00:00	AAPL	Stock	109.75	110.46	109.37	109.904	13319587.0
2020-09-17 14:00:00	AAPL	Stock	109.9	110.48	109.1	109.41	14980197.0
2020-09-17 15:00:00	AAPL	Stock	109.41	110.67	108.96	110.32	24512706.0
2020-09-17 16:00:00	AAPL	Stock	110.34	112.13	110.19	110.22	11288423.0
2020-09-17 17:00:00	AAPL	Stock	110.22	110.3	110.02	110.25	153150.0
2020-09-17 18:00:00	AAPL	Stock	110.24	110.58	110.1	110.54	149450.0
2020-09-17 19:00:00	AAPL	Stock	110.54	110.68	110.25	110.34	207899.0
2020-09-17 04:00:00	MSFT	Stock	202.6	203.1	202.28	202.86	9631.0
2020-09-17 05:00:00	MSFT	Stock	203.34	204.34	202.91	204.25	10115.0
2020-09-17 06:00:00	MSFT	Stock	204.2	204.2	202.04	202.04	12468.0
2020-09-17 07:00:00	MSFT	Stock	202.88	203.35	201.19	201.5	92946.0
2020-09-17 08:00:00	MSFT	Stock	202.465	203.0	200.59	200.8	186187.0
2020-09-17 09:00:00	MSFT	Stock	200.96	203.36	199.44	203.1	4717980.0
2020-09-17 10:00:00	MSFT	Stock	203.105	204.165	201.85	203.308	3303163.0
2020-09-17 11:00:00	MSFT	Stock	203.3	204.33	201.29	201.45	2653799.0
2020-09-17 12:00:00	MSFT	Stock	201.44	201.92	199.96	201.36	3784866.0
2020-09-17 13:00:00	MSFT	Stock	201.355	202.65	200.74	201.97	2290866.0
2020-09-17 14:00:00	MSFT	Stock	202.01	202.72	200.876	201.55	1893549.0
2020-09-17 15:00:00	MSFT	Stock	201.56	203.18	200.58	202.96	4020204.0
2020-09-17 16:00:00	MSFT	Stock	202.91	205.05	202.18	202.51	4636924.0
2020-09-17 17:00:00	MSFT	Stock	202.47	202.48	202.12	202.35	12501.0
2020-09-17 18:00:00	MSFT	Stock	202.39	203.88	202.33	202.92	34093.0
2020-09-17 19:00:00	MSFT	Stock	202.92	203.9	202.4	202.6	21408.0
2020-09-17 04:00:00	NVDA	Stock	12.3143	12.3143	12.2678	12.3122	119160.0
2020-09-17 05:00:00	NVDA	Stock	12.3725	12.4002	12.3725	12.4002	35800.0
2020-09-17 06:00:00	NVDA	Stock	12.4125	12.4125	12.2593	12.275	356720.0
2020-09-17 07:00:00	NVDA	Stock	12.275	12.3222	12.1255	12.156	1236040.0
2020-09-17 08:00:00	NVDA	Stock	12.181	12.317	12.0525	12.1018	6646880.0
2020-09-17 09:00:00	NVDA	Stock	12.0755	12.381	11.925	12.3644	137417960.0
2020-09-17 10:00:00	NVDA	Stock	12.3653	12.5315	12.2675	12.4375	151702120.0
2020-09-17 11:00:00	NVDA	Stock	12.4375	12.5898	12.3375	12.3435	111793760.0
2020-09-17 12:00:00	NVDA	Stock	12.3446	12.3933	12.2153	12.3713	107646080.0
2020-09-17 13:00:00	NVDA	Stock	12.3675	12.457	12.3198	12.395	73543440.0
2020-09-17 14:00:00	NVDA	Stock	12.3981	12.4858	12.3148	12.365	64392200.0
2020-09-17 15:00:00	NVDA	Stock	12.3685	12.48	12.2795	12.4635	82242160.0
2020-09-17 16:00:00	NVDA	Stock	12.4635	12.5145	12.4505	12.4635	19764760.0
2020-09-17 17:00:00	NVDA	Stock	12.464	12.4775	12.4318	12.4495	429240.0
2020-09-17 18:00:00	NVDA	Stock	12.45	12.4998	12.4402	12.4998	537200.0
2020-09-17 19:00:00	NVDA	Stock	12.5	12.533	12.475	12.4755	615360.0
2020-09-17 04:00:00	AMZN	Stock	151.995	151.995	151.35	151.35	27920.0
2020-09-17 05:00:00	AMZN	Stock	152.326	152.6755	152.326	152.675	10820.0

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

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