PREVIEW / stock_1hour / 2022-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-17.parquet
  size:    1.4 MB
  rows:    63,196
  symbols: 2,386

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
2022-06-17 04:00:00	AAPL	Stock	131.01	131.7	130.92	131.37	38488.0
2022-06-17 05:00:00	AAPL	Stock	131.3	131.59	131.2	131.48	22288.0
2022-06-17 06:00:00	AAPL	Stock	131.4	131.69	131.2	131.42	23652.0
2022-06-17 07:00:00	AAPL	Stock	131.42	131.99	131.23	131.36	105758.0
2022-06-17 08:00:00	AAPL	Stock	131.3999	131.95	130.6	130.7	653538.0
2022-06-17 09:00:00	AAPL	Stock	130.7	132.66	129.76	132.05	24787655.0
2022-06-17 10:00:00	AAPL	Stock	132.06	132.4199	129.81	130.5968	11820754.0
2022-06-17 11:00:00	AAPL	Stock	130.6	132.83	130.205	131.3465	11246787.0
2022-06-17 12:00:00	AAPL	Stock	131.35	132.32	131.08	131.97	7853943.0
2022-06-17 13:00:00	AAPL	Stock	131.98	133.079	131.65	132.0737	7622214.0
2022-06-17 14:00:00	AAPL	Stock	132.08	132.54	131.69	131.874	7269747.0
2022-06-17 15:00:00	AAPL	Stock	131.87	132.22	131.0428	131.42	16526792.0
2022-06-17 16:00:00	AAPL	Stock	131.48	131.7	131.35	131.52	31766357.0
2022-06-17 17:00:00	AAPL	Stock	131.51	131.56	131.42	131.5273	1643325.0
2022-06-17 18:00:00	AAPL	Stock	131.57	131.66	131.51	131.62	24122.0
2022-06-17 19:00:00	AAPL	Stock	131.55	131.61	131.5	131.56	15084.0
2022-06-17 04:00:00	MSFT	Stock	246.51	247.5	246.5	246.82	4160.0
2022-06-17 05:00:00	MSFT	Stock	246.8	247.47	246.8	247.1	7239.0
2022-06-17 06:00:00	MSFT	Stock	247.11	247.8	247.1	247.15	3225.0
2022-06-17 07:00:00	MSFT	Stock	247.05	248.1	247.05	247.2	27555.0
2022-06-17 08:00:00	MSFT	Stock	247.69	248.16	244.358	246.3	74777.0
2022-06-17 09:00:00	MSFT	Stock	246.18	249.0	244.13	247.76	8984751.0
2022-06-17 10:00:00	MSFT	Stock	247.81	247.94	244.03	245.11	2691794.0
2022-06-17 11:00:00	MSFT	Stock	245.13	248.66	244.45	246.9	2537099.0
2022-06-17 12:00:00	MSFT	Stock	246.92	248.827	246.4201	248.645	2287446.0
2022-06-17 13:00:00	MSFT	Stock	248.655	250.5	248.555	249.72	2006990.0
2022-06-17 14:00:00	MSFT	Stock	249.72	250.4312	249.21	249.38	2073865.0
2022-06-17 15:00:00	MSFT	Stock	249.39	250.0	247.5	247.53	4129735.0
2022-06-17 16:00:00	MSFT	Stock	247.54	248.0048	247.05	247.5	8850067.0
2022-06-17 17:00:00	MSFT	Stock	247.57	247.72	247.47	247.62	152866.0
2022-06-17 18:00:00	MSFT	Stock	247.47	247.63	247.47	247.6	4950.0
2022-06-17 19:00:00	MSFT	Stock	247.62	247.63	247.5	247.5	3289.0
2022-06-17 04:00:00	NVDA	Stock	15.736	15.868	15.7	15.804	416940.0
2022-06-17 05:00:00	NVDA	Stock	15.824	15.852	15.8	15.845	54150.0
2022-06-17 06:00:00	NVDA	Stock	15.828	15.853	15.811	15.83	79230.0
2022-06-17 07:00:00	NVDA	Stock	15.82	15.875	15.809	15.83	118960.0
2022-06-17 08:00:00	NVDA	Stock	15.82	15.886	15.77	15.775	1564380.0
2022-06-17 09:00:00	NVDA	Stock	15.783	15.995	15.612	15.887	82045100.0
2022-06-17 10:00:00	NVDA	Stock	15.889	15.897	15.328	15.542	71872800.0
2022-06-17 11:00:00	NVDA	Stock	15.537	15.791	15.4711	15.659	53829980.0
2022-06-17 12:00:00	NVDA	Stock	15.6605	15.872	15.608	15.81	39270740.0
2022-06-17 13:00:00	NVDA	Stock	15.81	15.977	15.789	15.858	47314290.0
2022-06-17 14:00:00	NVDA	Stock	15.86	15.933	15.807	15.824	34141120.0
2022-06-17 15:00:00	NVDA	Stock	15.8245	15.955	15.685	15.877	73934870.0
2022-06-17 16:00:00	NVDA	Stock	15.877	15.951	15.848	15.875	123956610.0
2022-06-17 17:00:00	NVDA	Stock	15.876	15.892	15.85	15.886	4020910.0
2022-06-17 18:00:00	NVDA	Stock	15.877	15.893	15.877	15.893	139310.0
2022-06-17 19:00:00	NVDA	Stock	15.882	15.896	15.84	15.85	193320.0
2022-06-17 04:00:00	AMZN	Stock	104.51	105.2	104.5	104.67	26886.0
2022-06-17 05:00:00	AMZN	Stock	104.94	105.25	104.76	104.76	12606.0

> showing 50 of 63,196 rows — these rows as CSV

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