PREVIEW / stock_1hour / 2021-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-07.parquet
  size:    1.4 MB
  rows:    65,479
  symbols: 2,676

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-01-07 04:00:00	AAPL	Stock	128.0	128.64	127.51	127.68	76311.0
2021-01-07 05:00:00	AAPL	Stock	127.58	128.29	127.55	127.75	53611.0
2021-01-07 06:00:00	AAPL	Stock	127.54	127.99	127.42	127.78	23564.0
2021-01-07 07:00:00	AAPL	Stock	127.69	128.31	127.69	128.28	382285.0
2021-01-07 08:00:00	AAPL	Stock	128.11	128.64	127.87	128.23	815673.0
2021-01-07 09:00:00	AAPL	Stock	128.24	129.14	127.86	129.01	16545680.0
2021-01-07 10:00:00	AAPL	Stock	129.03	130.56	128.88	130.541	18026893.0
2021-01-07 11:00:00	AAPL	Stock	130.545	131.03	130.14	130.32	12892372.0
2021-01-07 12:00:00	AAPL	Stock	130.33	130.65	129.85	130.465	7812590.0
2021-01-07 13:00:00	AAPL	Stock	130.465	130.56	130.02	130.31	6433115.0
2021-01-07 14:00:00	AAPL	Stock	130.305	130.78	130.28	130.775	6685850.0
2021-01-07 15:00:00	AAPL	Stock	130.772	131.63	130.46	130.85	16539785.0
2021-01-07 16:00:00	AAPL	Stock	130.92	131.0	130.61	130.63	11278705.0
2021-01-07 17:00:00	AAPL	Stock	130.66	130.75	130.42	130.72	131132.0
2021-01-07 18:00:00	AAPL	Stock	130.72	131.16	130.5	131.03	176597.0
2021-01-07 19:00:00	AAPL	Stock	131.04	131.95	130.96	131.68	399777.0
2021-01-07 04:00:00	MSFT	Stock	214.0	214.38	213.32	213.95	19727.0
2021-01-07 05:00:00	MSFT	Stock	213.85	214.15	213.55	213.75	10586.0
2021-01-07 06:00:00	MSFT	Stock	213.3	213.89	213.15	213.75	5019.0
2021-01-07 07:00:00	MSFT	Stock	213.68	214.24	213.5	214.14	48065.0
2021-01-07 08:00:00	MSFT	Stock	214.0	214.28	213.6	213.98	73199.0
2021-01-07 09:00:00	MSFT	Stock	213.84	217.19	213.71	216.91	3807168.0
2021-01-07 10:00:00	MSFT	Stock	216.92	218.14	216.79	218.107	3124026.0
2021-01-07 11:00:00	MSFT	Stock	218.09	218.78	217.41	218.29	2174973.0
2021-01-07 12:00:00	MSFT	Stock	218.33	218.46	217.76	218.16	1216973.0
2021-01-07 13:00:00	MSFT	Stock	218.17	218.64	217.65	218.58	1167625.0
2021-01-07 14:00:00	MSFT	Stock	218.59	218.73	217.846	218.697	1190934.0
2021-01-07 15:00:00	MSFT	Stock	218.7	219.34	218.15	218.29	3252117.0
2021-01-07 16:00:00	MSFT	Stock	218.29	218.73	218.0	218.02	6717913.0
2021-01-07 17:00:00	MSFT	Stock	218.07	218.3	218.05	218.2	9553.0
2021-01-07 18:00:00	MSFT	Stock	218.05	218.29	217.87	218.1	15044.0
2021-01-07 19:00:00	MSFT	Stock	218.29	218.55	217.9	218.4	13306.0
2021-01-07 04:00:00	NVDA	Stock	12.755	12.755	12.75	12.75	51440.0
2021-01-07 05:00:00	NVDA	Stock	12.7752	12.786	12.775	12.775	52520.0
2021-01-07 06:00:00	NVDA	Stock	12.7875	12.8	12.7875	12.8	75520.0
2021-01-07 07:00:00	NVDA	Stock	12.7775	12.8765	12.7752	12.875	1710280.0
2021-01-07 08:00:00	NVDA	Stock	12.8076	12.8875	12.775	12.8563	2091960.0
2021-01-07 09:00:00	NVDA	Stock	12.856	13.1438	12.854	13.095	81357960.0
2021-01-07 10:00:00	NVDA	Stock	13.0988	13.199	13.0648	13.1508	67485520.0
2021-01-07 11:00:00	NVDA	Stock	13.157	13.2888	13.1438	13.2008	49864280.0
2021-01-07 12:00:00	NVDA	Stock	13.1988	13.2808	13.1755	13.1782	45656480.0
2021-01-07 13:00:00	NVDA	Stock	13.1832	13.325	13.1275	13.3055	38709360.0
2021-01-07 14:00:00	NVDA	Stock	13.3058	13.344	13.2578	13.3285	24340600.0
2021-01-07 15:00:00	NVDA	Stock	13.3285	13.3778	13.3018	13.3452	54455600.0
2021-01-07 16:00:00	NVDA	Stock	13.344	13.3725	13.2875	13.2882	5723880.0
2021-01-07 17:00:00	NVDA	Stock	13.3062	13.344	13.2938	13.3125	3716560.0
2021-01-07 18:00:00	NVDA	Stock	13.344	13.344	13.2925	13.3228	353280.0
2021-01-07 19:00:00	NVDA	Stock	13.325	13.3408	13.325	13.33	274360.0
2021-01-07 04:00:00	AMZN	Stock	158.2	158.2	158.2	158.2	2920.0
2021-01-07 05:00:00	AMZN	Stock	157.8695	158.15	157.8695	158.15	33700.0

> showing 50 of 65,479 rows — these rows as CSV

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