PREVIEW / stock_1hour / 2021-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-18.parquet
  size:    1.5 MB
  rows:    67,082
  symbols: 2,707

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-11-18 04:00:00	AAPL	Stock	153.71	154.4	153.71	154.01	24868.0
2021-11-18 05:00:00	AAPL	Stock	154.01	154.07	153.81	154.0	12224.0
2021-11-18 06:00:00	AAPL	Stock	153.97	153.97	153.8	153.97	19025.0
2021-11-18 07:00:00	AAPL	Stock	153.94	153.98	153.71	153.75	75074.0
2021-11-18 08:00:00	AAPL	Stock	153.9	153.99	153.107	153.72	306094.0
2021-11-18 09:00:00	AAPL	Stock	153.71	154.615	153.05	154.4199	9070702.0
2021-11-18 10:00:00	AAPL	Stock	154.415	154.58	153.56	154.16	9767560.0
2021-11-18 11:00:00	AAPL	Stock	154.15	154.87	153.88	154.63	7207170.0
2021-11-18 12:00:00	AAPL	Stock	154.63	157.87	154.54	157.215	29956298.0
2021-11-18 13:00:00	AAPL	Stock	157.215	157.77	156.7	157.5012	12341565.0
2021-11-18 14:00:00	AAPL	Stock	157.5	158.4	157.37	157.64	13512459.0
2021-11-18 15:00:00	AAPL	Stock	157.64	158.67	157.6	157.89	17941326.0
2021-11-18 16:00:00	AAPL	Stock	157.9	158.08	157.65	158.05	10580186.0
2021-11-18 17:00:00	AAPL	Stock	158.07	158.28	157.67	157.69	237363.0
2021-11-18 18:00:00	AAPL	Stock	157.73	157.87	157.6	157.6	89609.0
2021-11-18 19:00:00	AAPL	Stock	157.59	157.77	157.58	157.73	67408.0
2021-11-18 04:00:00	MSFT	Stock	340.0	340.6	340.0	340.3	3547.0
2021-11-18 05:00:00	MSFT	Stock	340.19	340.2	339.89	340.05	919.0
2021-11-18 06:00:00	MSFT	Stock	340.01	340.3	339.52	340.3	2849.0
2021-11-18 07:00:00	MSFT	Stock	340.29	340.29	339.03	339.06	12008.0
2021-11-18 08:00:00	MSFT	Stock	339.55	340.35	338.5	339.12	1263138.0
2021-11-18 09:00:00	MSFT	Stock	338.5	340.34	337.12	340.04	1667516.0
2021-11-18 10:00:00	MSFT	Stock	340.06	340.35	338.68	339.37	1495261.0
2021-11-18 11:00:00	MSFT	Stock	339.34	342.09	339.17	341.48	1401808.0
2021-11-18 12:00:00	MSFT	Stock	341.47	342.45	340.32	340.8	1347565.0
2021-11-18 13:00:00	MSFT	Stock	340.78	341.52	340.73	341.07	773752.0
2021-11-18 14:00:00	MSFT	Stock	341.062	341.291	340.5701	340.94	844153.0
2021-11-18 15:00:00	MSFT	Stock	340.96	341.71	340.72	341.27	2242141.0
2021-11-18 16:00:00	MSFT	Stock	341.4	341.62	340.84	341.31	3295969.0
2021-11-18 17:00:00	MSFT	Stock	341.4123	341.74	341.4123	341.74	3627.0
2021-11-18 18:00:00	MSFT	Stock	341.72	342.08	341.51	341.95	11057.0
2021-11-18 19:00:00	MSFT	Stock	341.9	342.2	341.8001	342.18	11615.0
2021-11-18 04:00:00	NVDA	Stock	30.906	31.468	30.81	31.177	691360.0
2021-11-18 05:00:00	NVDA	Stock	31.198	31.25	30.94	31.233	275690.0
2021-11-18 06:00:00	NVDA	Stock	31.219	31.464	31.101	31.426	430600.0
2021-11-18 07:00:00	NVDA	Stock	31.401	31.985	31.19	31.65	4721530.0
2021-11-18 08:00:00	NVDA	Stock	31.8596	32.09	31.203	32.05	11237580.0
2021-11-18 09:00:00	NVDA	Stock	32.05	32.76	31.51	32.5845	165257960.0
2021-11-18 10:00:00	NVDA	Stock	32.585	32.6173	31.6	31.941	113492870.0
2021-11-18 11:00:00	NVDA	Stock	31.93	32.418	31.74	32.146	71645340.0
2021-11-18 12:00:00	NVDA	Stock	32.1495	32.455	31.671	31.763	64906810.0
2021-11-18 13:00:00	NVDA	Stock	31.764	31.8476	31.321	31.4805	48260750.0
2021-11-18 14:00:00	NVDA	Stock	31.477	31.839	31.34	31.7325	47463820.0
2021-11-18 15:00:00	NVDA	Stock	31.732	31.969	31.607	31.675	61819340.0
2021-11-18 16:00:00	NVDA	Stock	31.675	31.797	31.609	31.775	20498760.0
2021-11-18 17:00:00	NVDA	Stock	31.783	31.795	31.703	31.779	445120.0
2021-11-18 18:00:00	NVDA	Stock	31.783	31.797	31.754	31.79	344460.0
2021-11-18 19:00:00	NVDA	Stock	31.787	31.975	31.761	31.97	519680.0
2021-11-18 07:00:00	AMZN	Stock	178.2	178.6145	178.191	178.6145	79300.0
2021-11-18 08:00:00	AMZN	Stock	178.3	178.6	177.0064	178.5445	53020.0

> showing 50 of 67,082 rows — these rows as CSV

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