PREVIEW / stock_1hour / 2020-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-20.parquet
  size:    1.3 MB
  rows:    59,210
  symbols: 2,581

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
2020-11-20 04:00:00	AAPL	Stock	118.35	118.6	118.35	118.5	10929.0
2020-11-20 05:00:00	AAPL	Stock	118.5	118.64	118.32	118.64	9994.0
2020-11-20 06:00:00	AAPL	Stock	118.61	118.64	118.45	118.6	5776.0
2020-11-20 07:00:00	AAPL	Stock	118.61	118.95	118.56	118.84	83401.0
2020-11-20 08:00:00	AAPL	Stock	118.95	118.97	118.59	118.7	166801.0
2020-11-20 09:00:00	AAPL	Stock	118.67	118.81	117.84	118.13	11609864.0
2020-11-20 10:00:00	AAPL	Stock	118.13	118.64	118.06	118.465	7803417.0
2020-11-20 11:00:00	AAPL	Stock	118.46	118.77	117.905	117.99	7554166.0
2020-11-20 12:00:00	AAPL	Stock	117.98	118.3	117.88	118.27	5849081.0
2020-11-20 13:00:00	AAPL	Stock	118.28	118.29	117.9	117.958	4914978.0
2020-11-20 14:00:00	AAPL	Stock	117.96	118.1	117.7	117.87	5667274.0
2020-11-20 15:00:00	AAPL	Stock	117.87	117.96	117.29	117.32	12682183.0
2020-11-20 16:00:00	AAPL	Stock	117.33	117.41	117.15	117.38	6701452.0
2020-11-20 17:00:00	AAPL	Stock	117.4	117.44	117.22	117.22	97807.0
2020-11-20 18:00:00	AAPL	Stock	117.22	117.23	116.91	117.08	197548.0
2020-11-20 19:00:00	AAPL	Stock	117.07	117.19	117.02	117.11	92114.0
2020-11-20 04:00:00	MSFT	Stock	212.95	213.0	212.7	212.93	4422.0
2020-11-20 05:00:00	MSFT	Stock	212.7	212.98	212.7	212.98	2538.0
2020-11-20 06:00:00	MSFT	Stock	212.98	213.2	212.94	213.18	1439.0
2020-11-20 07:00:00	MSFT	Stock	213.04	213.18	212.7	212.79	25800.0
2020-11-20 08:00:00	MSFT	Stock	213.0	213.05	212.62	212.62	34221.0
2020-11-20 09:00:00	MSFT	Stock	212.62	213.0	211.337	212.19	2891852.0
2020-11-20 10:00:00	MSFT	Stock	212.19	212.72	211.66	212.14	1822570.0
2020-11-20 11:00:00	MSFT	Stock	212.13	213.285	211.83	212.0	2033902.0
2020-11-20 12:00:00	MSFT	Stock	212.0	212.43	211.8	212.05	1263008.0
2020-11-20 13:00:00	MSFT	Stock	212.03	212.22	211.673	212.12	1163848.0
2020-11-20 14:00:00	MSFT	Stock	212.14	212.525	212.01	212.37	1072739.0
2020-11-20 15:00:00	MSFT	Stock	212.39	212.5	210.0	210.34	3694532.0
2020-11-20 16:00:00	MSFT	Stock	210.39	211.35	210.096	210.46	4176491.0
2020-11-20 17:00:00	MSFT	Stock	210.49	210.6	210.42	210.55	23091.0
2020-11-20 18:00:00	MSFT	Stock	210.59	210.71	210.52	210.71	6783.0
2020-11-20 19:00:00	MSFT	Stock	210.75	210.75	210.41	210.49	6215.0
2020-11-20 04:00:00	NVDA	Stock	13.45	13.45	13.35	13.425	54240.0
2020-11-20 05:00:00	NVDA	Stock	13.4202	13.4375	13.4202	13.425	43400.0
2020-11-20 07:00:00	NVDA	Stock	13.4275	13.4868	13.4192	13.448	840320.0
2020-11-20 08:00:00	NVDA	Stock	13.4763	13.4868	13.4337	13.4475	1587920.0
2020-11-20 09:00:00	NVDA	Stock	13.44	13.4945	13.2606	13.31	51306760.0
2020-11-20 10:00:00	NVDA	Stock	13.3095	13.3625	13.2928	13.3031	31020320.0
2020-11-20 11:00:00	NVDA	Stock	13.302	13.3138	13.1778	13.2215	42941000.0
2020-11-20 12:00:00	NVDA	Stock	13.223	13.2962	13.2073	13.2888	21971760.0
2020-11-20 13:00:00	NVDA	Stock	13.2872	13.3338	13.2648	13.27	18290880.0
2020-11-20 14:00:00	NVDA	Stock	13.2715	13.2818	13.1981	13.204	19955440.0
2020-11-20 15:00:00	NVDA	Stock	13.2055	13.2255	13.065	13.0878	68042360.0
2020-11-20 16:00:00	NVDA	Stock	13.0878	13.1113	13.0755	13.0988	3152200.0
2020-11-20 17:00:00	NVDA	Stock	13.0988	13.0988	13.0875	13.0942	230960.0
2020-11-20 18:00:00	NVDA	Stock	13.0968	13.1063	13.095	13.1	508440.0
2020-11-20 19:00:00	NVDA	Stock	13.1025	13.1063	13.0875	13.0963	369400.0
2020-11-20 07:00:00	AMZN	Stock	156.15	156.325	155.975	156.15	111500.0
2020-11-20 08:00:00	AMZN	Stock	156.3311	156.5	155.5605	155.75	244460.0
2020-11-20 09:00:00	AMZN	Stock	155.8292	156.1325	154.9763	155.1717	9834340.0

> showing 50 of 59,210 rows — these rows as CSV

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