PREVIEW / stock_1hour / 2020-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-27.parquet
  size:    1.2 MB
  rows:    55,086
  symbols: 2,398

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-27 04:00:00	AAPL	Stock	71.35	71.625	71.35	71.525	25128.0
2020-04-27 05:00:00	AAPL	Stock	71.5	71.65	71.4975	71.4975	19984.0
2020-04-27 06:00:00	AAPL	Stock	71.575	71.575	70.65	70.75	176048.0
2020-04-27 07:00:00	AAPL	Stock	70.79	71.2925	70.565	71.125	624392.0
2020-04-27 08:00:00	AAPL	Stock	70.665	71.25	70.655	70.7575	792796.0
2020-04-27 09:00:00	AAPL	Stock	70.7575	71.0575	69.9875	71.0475	18716320.0
2020-04-27 10:00:00	AAPL	Stock	71.0425	71.135	70.2625	70.3425	17321456.0
2020-04-27 11:00:00	AAPL	Stock	70.3375	70.8325	70.1775	70.5578	11649432.0
2020-04-27 12:00:00	AAPL	Stock	70.56	70.615	70.275	70.45	8660600.0
2020-04-27 13:00:00	AAPL	Stock	70.4515	70.4925	70.088	70.4298	8171236.0
2020-04-27 14:00:00	AAPL	Stock	70.4238	70.755	70.4238	70.6465	8089796.0
2020-04-27 15:00:00	AAPL	Stock	70.65	70.905	70.5825	70.8125	14760288.0
2020-04-27 16:00:00	AAPL	Stock	70.79	70.7925	70.621	70.7	6866808.0
2020-04-27 17:00:00	AAPL	Stock	70.7	70.75	70.6875	70.75	28372.0
2020-04-27 18:00:00	AAPL	Stock	70.7525	70.8725	70.73	70.825	84488.0
2020-04-27 19:00:00	AAPL	Stock	70.815	70.9125	70.8025	70.8475	42764.0
2020-04-27 04:00:00	MSFT	Stock	176.55	177.0	176.11	177.0	7321.0
2020-04-27 05:00:00	MSFT	Stock	176.81	177.2	176.77	177.09	2358.0
2020-04-27 06:00:00	MSFT	Stock	176.8	177.0	176.5	176.6	11170.0
2020-04-27 07:00:00	MSFT	Stock	176.59	176.95	176.15	176.82	38830.0
2020-04-27 08:00:00	MSFT	Stock	176.5	176.95	176.2	176.7	119204.0
2020-04-27 09:00:00	MSFT	Stock	176.8	177.04	175.37	176.03	3945346.0
2020-04-27 10:00:00	MSFT	Stock	176.035	176.19	174.26	174.339	4329855.0
2020-04-27 11:00:00	MSFT	Stock	174.32	175.79	174.05	175.144	3500312.0
2020-04-27 12:00:00	MSFT	Stock	175.15	175.25	173.3	174.07	3533352.0
2020-04-27 13:00:00	MSFT	Stock	174.08	174.4	173.37	173.685	2756451.0
2020-04-27 14:00:00	MSFT	Stock	173.675	174.64	173.675	174.5	2644004.0
2020-04-27 15:00:00	MSFT	Stock	174.505	174.76	173.82	174.03	4474880.0
2020-04-27 16:00:00	MSFT	Stock	174.05	174.564	174.0	174.05	3011375.0
2020-04-27 17:00:00	MSFT	Stock	174.06	174.33	174.04	174.245	9167.0
2020-04-27 18:00:00	MSFT	Stock	174.22	174.4	174.04	174.28	14552.0
2020-04-27 19:00:00	MSFT	Stock	174.28	174.74	174.23	174.5	17326.0
2020-04-27 04:00:00	NVDA	Stock	7.3	7.3622	7.3	7.3622	77440.0
2020-04-27 05:00:00	NVDA	Stock	7.355	7.3938	7.355	7.3922	36720.0
2020-04-27 06:00:00	NVDA	Stock	7.3658	7.387	7.3343	7.3362	216480.0
2020-04-27 07:00:00	NVDA	Stock	7.325	7.3788	7.325	7.375	557760.0
2020-04-27 08:00:00	NVDA	Stock	7.3722	7.3875	7.338	7.3824	822880.0
2020-04-27 09:00:00	NVDA	Stock	7.3765	7.5832	7.35	7.5708	107174720.0
2020-04-27 10:00:00	NVDA	Stock	7.57	7.5875	7.4265	7.435	73583960.0
2020-04-27 11:00:00	NVDA	Stock	7.433	7.5225	7.4162	7.487	50957840.0
2020-04-27 12:00:00	NVDA	Stock	7.487	7.4919	7.4268	7.4619	29580120.0
2020-04-27 13:00:00	NVDA	Stock	7.4632	7.4665	7.3778	7.4013	41520320.0
2020-04-27 14:00:00	NVDA	Stock	7.4021	7.4418	7.3955	7.4265	27042560.0
2020-04-27 15:00:00	NVDA	Stock	7.4274	7.4555	7.414	7.427	51896000.0
2020-04-27 16:00:00	NVDA	Stock	7.427	7.4312	7.42	7.4258	30005760.0
2020-04-27 17:00:00	NVDA	Stock	7.431	7.4535	7.43	7.4528	368800.0
2020-04-27 18:00:00	NVDA	Stock	7.45	7.485	7.4345	7.4718	2246040.0
2020-04-27 19:00:00	NVDA	Stock	7.4692	7.5	7.4688	7.475	558840.0
2020-04-27 04:00:00	AMZN	Stock	121.45	121.9	120.977	121.9	28440.0
2020-04-27 06:00:00	AMZN	Stock	121.722	121.75	121.722	121.741	9380.0

> showing 50 of 55,086 rows — these rows as CSV

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