PREVIEW / stock_1hour / 2021-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-19.parquet
  size:    1.4 MB
  rows:    66,009
  symbols: 2,972

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
2021-04-19 04:00:00	AAPL	Stock	134.24	134.4	134.16	134.4	10110.0
2021-04-19 05:00:00	AAPL	Stock	134.35	134.39	134.18	134.31	4680.0
2021-04-19 06:00:00	AAPL	Stock	134.3	134.32	133.76	134.01	19125.0
2021-04-19 07:00:00	AAPL	Stock	134.01	134.12	133.79	133.96	84530.0
2021-04-19 08:00:00	AAPL	Stock	133.99	134.495	133.7	133.77	320859.0
2021-04-19 09:00:00	AAPL	Stock	133.76	135.33	133.34	135.22	12507112.0
2021-04-19 10:00:00	AAPL	Stock	135.23	135.47	134.15	134.7961	14160448.0
2021-04-19 11:00:00	AAPL	Stock	134.8	135.09	134.25	134.38	9379816.0
2021-04-19 12:00:00	AAPL	Stock	134.37	134.54	133.72	134.0462	8470995.0
2021-04-19 13:00:00	AAPL	Stock	134.055	134.67	133.96	134.553	5530032.0
2021-04-19 14:00:00	AAPL	Stock	134.55	134.82	134.33	134.575	6183099.0
2021-04-19 15:00:00	AAPL	Stock	134.58	134.94	134.145	134.86	9902044.0
2021-04-19 16:00:00	AAPL	Stock	134.84	134.93	134.55	134.8	13293801.0
2021-04-19 17:00:00	AAPL	Stock	134.8	134.9	134.77	134.9	48233.0
2021-04-19 18:00:00	AAPL	Stock	134.89	135.0	134.84	134.99	169170.0
2021-04-19 19:00:00	AAPL	Stock	134.96	135.0	134.89	134.98	90024.0
2021-04-19 04:00:00	MSFT	Stock	261.0	261.0	260.7	260.7	1015.0
2021-04-19 05:00:00	MSFT	Stock	260.63	261.4	260.63	261.3	3382.0
2021-04-19 06:00:00	MSFT	Stock	261.35	261.39	260.0	260.0	4102.0
2021-04-19 07:00:00	MSFT	Stock	260.17	260.75	260.05	260.45	14489.0
2021-04-19 08:00:00	MSFT	Stock	260.8	260.8	259.98	259.98	43135.0
2021-04-19 09:00:00	MSFT	Stock	260.07	261.48	259.18	260.41	1808958.0
2021-04-19 10:00:00	MSFT	Stock	260.405	260.752	258.765	260.12	2559705.0
2021-04-19 11:00:00	MSFT	Stock	260.11	260.48	258.83	259.03	1725863.0
2021-04-19 12:00:00	MSFT	Stock	259.01	259.05	257.821	258.21	1584921.0
2021-04-19 13:00:00	MSFT	Stock	258.21	258.97	258.05	258.6899	1175978.0
2021-04-19 14:00:00	MSFT	Stock	258.66	259.11	258.39	259.0	1081141.0
2021-04-19 15:00:00	MSFT	Stock	259.01	259.06	258.19	258.82	2549850.0
2021-04-19 16:00:00	MSFT	Stock	258.74	258.91	258.46	258.75	4928876.0
2021-04-19 17:00:00	MSFT	Stock	258.75	258.9	258.74	258.76	4670.0
2021-04-19 18:00:00	MSFT	Stock	258.79	258.97	258.78	258.9	4255.0
2021-04-19 19:00:00	MSFT	Stock	258.9	258.99	258.79	258.99	6670.0
2021-04-19 04:00:00	NVDA	Stock	15.975	15.975	15.9125	15.9125	45920.0
2021-04-19 06:00:00	NVDA	Stock	15.85	15.85	15.85	15.85	4400.0
2021-04-19 07:00:00	NVDA	Stock	15.8348	15.8835	15.813	15.813	104360.0
2021-04-19 08:00:00	NVDA	Stock	15.8375	15.925	15.2995	15.5358	4435440.0
2021-04-19 09:00:00	NVDA	Stock	15.55	15.8075	15.45	15.7535	51586720.0
2021-04-19 10:00:00	NVDA	Stock	15.746	15.7595	15.4278	15.5562	50085920.0
2021-04-19 11:00:00	NVDA	Stock	15.5562	15.5895	15.343	15.4058	35968480.0
2021-04-19 12:00:00	NVDA	Stock	15.4039	15.4049	15.233	15.309	31589320.0
2021-04-19 13:00:00	NVDA	Stock	15.3012	15.422	15.3012	15.3792	18370040.0
2021-04-19 14:00:00	NVDA	Stock	15.3767	15.4182	15.2983	15.4182	17870680.0
2021-04-19 15:00:00	NVDA	Stock	15.4192	15.4197	15.3118	15.3523	36104360.0
2021-04-19 16:00:00	NVDA	Stock	15.3618	15.3725	15.355	15.3562	17420760.0
2021-04-19 17:00:00	NVDA	Stock	15.3502	15.3647	15.3502	15.355	92040.0
2021-04-19 18:00:00	NVDA	Stock	15.3558	15.3745	15.3558	15.3638	73240.0
2021-04-19 19:00:00	NVDA	Stock	15.3725	15.3825	15.3638	15.3655	114760.0
2021-04-19 06:00:00	AMZN	Stock	169.65	169.706	169.55	169.55	8580.0
2021-04-19 07:00:00	AMZN	Stock	169.65	169.8055	169.615	169.7815	35980.0
2021-04-19 08:00:00	AMZN	Stock	169.847	169.8495	169.25	169.425	139520.0

> showing 50 of 66,009 rows — these rows as CSV

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