PREVIEW / stock_1hour / 2021-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-14.parquet
  size:    1.4 MB
  rows:    66,482
  symbols: 2,709

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-14 04:00:00	AAPL	Stock	131.2	131.2	130.25	130.3	20194.0
2021-01-14 05:00:00	AAPL	Stock	130.27	130.4	130.0	130.3	15451.0
2021-01-14 06:00:00	AAPL	Stock	130.39	130.65	130.08	130.6	18862.0
2021-01-14 07:00:00	AAPL	Stock	130.64	130.96	130.56	130.85	229127.0
2021-01-14 08:00:00	AAPL	Stock	130.75	131.16	130.6	130.97	304577.0
2021-01-14 09:00:00	AAPL	Stock	130.98	131.07	129.664	130.01	11849209.0
2021-01-14 10:00:00	AAPL	Stock	130.0	130.87	129.6	130.623	13746071.0
2021-01-14 11:00:00	AAPL	Stock	130.63	130.7	129.86	130.0	7878526.0
2021-01-14 12:00:00	AAPL	Stock	129.995	130.2	129.54	130.13	7125644.0
2021-01-14 13:00:00	AAPL	Stock	130.132	130.133	129.5	129.53	5754086.0
2021-01-14 14:00:00	AAPL	Stock	129.52	129.74	129.29	129.625	6971506.0
2021-01-14 15:00:00	AAPL	Stock	129.623	129.73	128.76	128.92	14200533.0
2021-01-14 16:00:00	AAPL	Stock	128.91	129.18	128.91	128.98	9138860.0
2021-01-14 17:00:00	AAPL	Stock	128.98	129.35	128.96	129.34	118568.0
2021-01-14 18:00:00	AAPL	Stock	129.3	129.34	129.25	129.29	73214.0
2021-01-14 19:00:00	AAPL	Stock	129.27	129.35	129.0	129.2	126413.0
2021-01-14 04:00:00	MSFT	Stock	216.34	216.47	215.15	215.15	7007.0
2021-01-14 05:00:00	MSFT	Stock	215.28	215.42	214.53	214.71	2412.0
2021-01-14 06:00:00	MSFT	Stock	215.71	216.01	215.05	215.05	8158.0
2021-01-14 07:00:00	MSFT	Stock	215.88	216.03	215.41	215.81	20128.0
2021-01-14 08:00:00	MSFT	Stock	215.7	216.2	215.39	216.02	27078.0
2021-01-14 09:00:00	MSFT	Stock	216.01	217.46	215.51	215.92	2313452.0
2021-01-14 10:00:00	MSFT	Stock	215.935	216.415	215.56	215.898	2341435.0
2021-01-14 11:00:00	MSFT	Stock	215.9	215.96	214.42	214.631	2213507.0
2021-01-14 12:00:00	MSFT	Stock	214.64	214.81	213.94	214.79	2001528.0
2021-01-14 13:00:00	MSFT	Stock	214.78	214.8	213.912	213.99	1627797.0
2021-01-14 14:00:00	MSFT	Stock	213.97	214.21	213.76	214.0	1717596.0
2021-01-14 15:00:00	MSFT	Stock	213.99	214.24	212.74	213.02	4838660.0
2021-01-14 16:00:00	MSFT	Stock	213.02	213.5	212.53	213.18	6404852.0
2021-01-14 17:00:00	MSFT	Stock	213.18	213.6	213.15	213.6	22084.0
2021-01-14 18:00:00	MSFT	Stock	213.59	213.74	213.51	213.68	10856.0
2021-01-14 19:00:00	MSFT	Stock	213.6	213.68	213.39	213.52	14359.0
2021-01-14 04:00:00	NVDA	Stock	13.6	13.6355	13.6	13.625	86840.0
2021-01-14 05:00:00	NVDA	Stock	13.625	13.625	13.5552	13.5625	194880.0
2021-01-14 06:00:00	NVDA	Stock	13.5842	13.5842	13.54	13.5715	81120.0
2021-01-14 07:00:00	NVDA	Stock	13.575	13.6	13.5712	13.5885	255080.0
2021-01-14 08:00:00	NVDA	Stock	13.6	13.625	13.545	13.6075	402800.0
2021-01-14 09:00:00	NVDA	Stock	13.5988	13.6215	13.4328	13.4658	30398600.0
2021-01-14 10:00:00	NVDA	Stock	13.4601	13.5	13.358	13.4185	35940040.0
2021-01-14 11:00:00	NVDA	Stock	13.4222	13.4535	13.316	13.3692	29425160.0
2021-01-14 12:00:00	NVDA	Stock	13.3625	13.4302	13.3428	13.4191	20532760.0
2021-01-14 13:00:00	NVDA	Stock	13.4199	13.4212	13.3026	13.3128	16089400.0
2021-01-14 14:00:00	NVDA	Stock	13.3115	13.3542	13.225	13.2675	30866960.0
2021-01-14 15:00:00	NVDA	Stock	13.2705	13.3122	13.1805	13.1958	49151600.0
2021-01-14 16:00:00	NVDA	Stock	13.2002	13.2022	13.1625	13.1875	9164080.0
2021-01-14 17:00:00	NVDA	Stock	13.1938	13.2248	13.1938	13.2225	466400.0
2021-01-14 18:00:00	NVDA	Stock	13.213	13.2415	13.2125	13.2415	244360.0
2021-01-14 19:00:00	NVDA	Stock	13.2485	13.2485	13.2125	13.2325	361120.0
2021-01-14 04:00:00	AMZN	Stock	158.465	158.465	158.465	158.465	2000.0
2021-01-14 05:00:00	AMZN	Stock	158.2945	158.2945	157.9	157.9	17340.0

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

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