PREVIEW / stock_1hour / 2020-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-27.parquet
  size:    1.2 MB
  rows:    56,746
  symbols: 2,500

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-10-27 04:00:00	AAPL	Stock	115.22	115.47	115.0	115.37	24079.0
2020-10-27 05:00:00	AAPL	Stock	115.33	115.35	115.15	115.25	7270.0
2020-10-27 06:00:00	AAPL	Stock	115.23	116.0	115.23	115.66	29457.0
2020-10-27 07:00:00	AAPL	Stock	115.74	115.86	115.35	115.8	177666.0
2020-10-27 08:00:00	AAPL	Stock	115.75	115.86	115.27	115.4	393260.0
2020-10-27 09:00:00	AAPL	Stock	115.42	116.03	114.54	116.0	11545989.0
2020-10-27 10:00:00	AAPL	Stock	116.015	116.45	115.45	116.0	13657909.0
2020-10-27 11:00:00	AAPL	Stock	115.998	117.19	115.95	117.11	12858457.0
2020-10-27 12:00:00	AAPL	Stock	117.11	117.28	116.54	117.03	9830272.0
2020-10-27 13:00:00	AAPL	Stock	117.02	117.16	116.305	116.374	8820517.0
2020-10-27 14:00:00	AAPL	Stock	116.37	116.469	115.92	116.215	8237834.0
2020-10-27 15:00:00	AAPL	Stock	116.22	117.0	116.03	116.53	11319594.0
2020-10-27 16:00:00	AAPL	Stock	116.55	116.8	116.11	116.12	6367581.0
2020-10-27 17:00:00	AAPL	Stock	116.12	116.28	116.08	116.21	104339.0
2020-10-27 18:00:00	AAPL	Stock	116.21	116.29	115.78	116.02	241346.0
2020-10-27 19:00:00	AAPL	Stock	116.07	116.19	116.0	116.12	146610.0
2020-10-27 04:00:00	MSFT	Stock	211.3	211.3	210.72	211.02	7356.0
2020-10-27 05:00:00	MSFT	Stock	211.18	211.25	211.02	211.2	1805.0
2020-10-27 06:00:00	MSFT	Stock	211.27	212.3	211.12	211.96	11658.0
2020-10-27 07:00:00	MSFT	Stock	212.0	212.1	211.61	211.76	51401.0
2020-10-27 08:00:00	MSFT	Stock	211.744	212.09	211.25	211.31	96120.0
2020-10-27 09:00:00	MSFT	Stock	211.316	212.41	210.57	211.905	2907804.0
2020-10-27 10:00:00	MSFT	Stock	211.92	212.38	210.329	211.71	2856074.0
2020-10-27 11:00:00	MSFT	Stock	211.72	213.23	211.54	213.08	2687607.0
2020-10-27 12:00:00	MSFT	Stock	213.07	213.4	212.42	213.36	2275204.0
2020-10-27 13:00:00	MSFT	Stock	213.36	214.47	212.77	214.11	2642334.0
2020-10-27 14:00:00	MSFT	Stock	214.12	214.25	213.09	213.82	2611534.0
2020-10-27 15:00:00	MSFT	Stock	213.825	214.67	213.04	213.15	6171598.0
2020-10-27 16:00:00	MSFT	Stock	213.18	216.5	211.02	212.86	6075789.0
2020-10-27 17:00:00	MSFT	Stock	212.79	213.47	211.8	212.87	467869.0
2020-10-27 18:00:00	MSFT	Stock	212.91	213.5	208.75	208.8	964341.0
2020-10-27 19:00:00	MSFT	Stock	208.8	209.75	208.7	209.7	219665.0
2020-10-27 05:00:00	NVDA	Stock	13.1433	13.1433	13.1433	13.1433	4000.0
2020-10-27 06:00:00	NVDA	Stock	13.175	13.1862	13.0695	13.1745	163520.0
2020-10-27 07:00:00	NVDA	Stock	13.1562	13.2212	13.1562	13.2212	244200.0
2020-10-27 08:00:00	NVDA	Stock	13.1812	13.2595	13.1562	13.2488	1494160.0
2020-10-27 09:00:00	NVDA	Stock	13.2438	13.4202	13.2326	13.3062	49156560.0
2020-10-27 10:00:00	NVDA	Stock	13.308	13.35	13.1915	13.3211	37693560.0
2020-10-27 11:00:00	NVDA	Stock	13.3248	13.4195	13.3185	13.4129	26982800.0
2020-10-27 12:00:00	NVDA	Stock	13.414	13.4272	13.2888	13.3111	18287520.0
2020-10-27 13:00:00	NVDA	Stock	13.3108	13.3403	13.26	13.3295	17418440.0
2020-10-27 14:00:00	NVDA	Stock	13.3258	13.3418	13.2713	13.3238	16536680.0
2020-10-27 15:00:00	NVDA	Stock	13.326	13.442	13.2915	13.393	40930720.0
2020-10-27 16:00:00	NVDA	Stock	13.3968	13.4248	13.3442	13.3442	15870600.0
2020-10-27 17:00:00	NVDA	Stock	13.3575	13.3575	13.3405	13.3485	81120.0
2020-10-27 18:00:00	NVDA	Stock	13.3412	13.3412	13.2875	13.3312	106800.0
2020-10-27 19:00:00	NVDA	Stock	13.3	13.3643	13.3	13.364	231120.0
2020-10-27 04:00:00	AMZN	Stock	161.25	161.25	161.24	161.24	6020.0
2020-10-27 06:00:00	AMZN	Stock	161.6	161.6	161.6	161.6	15640.0
2020-10-27 07:00:00	AMZN	Stock	161.65	161.65	161.113	161.494	167020.0

> showing 50 of 56,746 rows — these rows as CSV

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