PREVIEW / stock_1hour / 2021-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-09.parquet
  size:    1.5 MB
  rows:    70,513
  symbols: 2,801

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-02-09 04:00:00	AAPL	Stock	136.4	136.67	136.1	136.38	33821.0
2021-02-09 05:00:00	AAPL	Stock	136.36	136.6	136.36	136.57	11787.0
2021-02-09 06:00:00	AAPL	Stock	136.56	136.71	136.45	136.64	20594.0
2021-02-09 07:00:00	AAPL	Stock	136.62	136.68	136.31	136.45	96059.0
2021-02-09 08:00:00	AAPL	Stock	136.5	136.66	136.25	136.44	356005.0
2021-02-09 09:00:00	AAPL	Stock	136.42	137.68	136.14	136.94	11236825.0
2021-02-09 10:00:00	AAPL	Stock	136.95	137.877	136.82	137.194	10338724.0
2021-02-09 11:00:00	AAPL	Stock	137.195	137.27	136.43	136.47	8312720.0
2021-02-09 12:00:00	AAPL	Stock	136.464	136.79	136.43	136.575	4350238.0
2021-02-09 13:00:00	AAPL	Stock	136.577	136.61	136.18	136.415	4984427.0
2021-02-09 14:00:00	AAPL	Stock	136.419	136.8	136.41	136.725	3768730.0
2021-02-09 15:00:00	AAPL	Stock	136.715	136.74	135.85	136.0	8838301.0
2021-02-09 16:00:00	AAPL	Stock	135.99	136.649	135.99	136.27	5281318.0
2021-02-09 17:00:00	AAPL	Stock	136.25	136.26	136.05	136.11	71222.0
2021-02-09 18:00:00	AAPL	Stock	136.11	136.24	135.99	136.03	100758.0
2021-02-09 19:00:00	AAPL	Stock	136.02	136.02	135.81	135.93	129413.0
2021-02-09 04:00:00	MSFT	Stock	242.01	242.3	242.01	242.3	601.0
2021-02-09 05:00:00	MSFT	Stock	241.74	241.93	241.74	241.76	952.0
2021-02-09 06:00:00	MSFT	Stock	241.97	242.7	241.97	242.33	2939.0
2021-02-09 07:00:00	MSFT	Stock	242.38	242.38	241.95	241.95	7113.0
2021-02-09 08:00:00	MSFT	Stock	242.2	242.2	241.68	241.771	15089.0
2021-02-09 09:00:00	MSFT	Stock	241.77	244.16	241.11	243.76	2126515.0
2021-02-09 10:00:00	MSFT	Stock	243.845	244.76	243.678	244.33	2176299.0
2021-02-09 11:00:00	MSFT	Stock	244.32	244.38	243.03	243.22	1310366.0
2021-02-09 12:00:00	MSFT	Stock	243.22	243.33	242.56	242.99	1062941.0
2021-02-09 13:00:00	MSFT	Stock	242.98	243.49	242.87	243.31	997070.0
2021-02-09 14:00:00	MSFT	Stock	243.32	244.46	243.27	244.44	1222800.0
2021-02-09 15:00:00	MSFT	Stock	244.44	244.53	243.33	243.8	2477888.0
2021-02-09 16:00:00	MSFT	Stock	243.77	244.2	243.61	244.15	3247310.0
2021-02-09 17:00:00	MSFT	Stock	244.2	244.3	243.9	244.15	8400.0
2021-02-09 18:00:00	MSFT	Stock	244.25	244.54	243.77	244.06	7164.0
2021-02-09 19:00:00	MSFT	Stock	244.05	244.05	244.0	244.0	859.0
2021-02-09 04:00:00	NVDA	Stock	14.45	14.45	14.4098	14.4098	32880.0
2021-02-09 05:00:00	NVDA	Stock	14.3995	14.4012	14.3625	14.4012	66880.0
2021-02-09 06:00:00	NVDA	Stock	14.354	14.354	14.3245	14.35	138520.0
2021-02-09 07:00:00	NVDA	Stock	14.37	14.4222	14.35	14.355	797280.0
2021-02-09 08:00:00	NVDA	Stock	14.3975	14.4222	14.3502	14.365	598080.0
2021-02-09 09:00:00	NVDA	Stock	14.3692	14.5725	14.2225	14.4325	69128280.0
2021-02-09 10:00:00	NVDA	Stock	14.4277	14.5832	14.3525	14.3923	47539120.0
2021-02-09 11:00:00	NVDA	Stock	14.395	14.45	14.2895	14.413	29343080.0
2021-02-09 12:00:00	NVDA	Stock	14.4122	14.4555	14.3728	14.3785	14607640.0
2021-02-09 13:00:00	NVDA	Stock	14.3796	14.3798	14.278	14.3031	14010880.0
2021-02-09 14:00:00	NVDA	Stock	14.2997	14.3605	14.2997	14.3605	13332480.0
2021-02-09 15:00:00	NVDA	Stock	14.362	14.368	14.225	14.2562	27289320.0
2021-02-09 16:00:00	NVDA	Stock	14.2632	14.3699	14.25	14.3	12722000.0
2021-02-09 17:00:00	NVDA	Stock	14.298	14.3125	14.2828	14.3062	169960.0
2021-02-09 18:00:00	NVDA	Stock	14.315	14.3302	14.2632	14.3302	253200.0
2021-02-09 19:00:00	NVDA	Stock	14.3248	14.3325	14.2875	14.325	29440.0
2021-02-09 06:00:00	AMZN	Stock	165.8005	165.8005	165.8	165.8	10700.0
2021-02-09 07:00:00	AMZN	Stock	165.75	165.7505	165.525	165.525	60280.0

> showing 50 of 70,513 rows — these rows as CSV

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