PREVIEW / stock_1hour / 2020-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-16.parquet
  size:    1.3 MB
  rows:    61,858
  symbols: 2,561

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-16 04:00:00	AAPL	Stock	119.59	119.83	119.59	119.78	22570.0
2020-11-16 05:00:00	AAPL	Stock	119.72	119.72	119.44	119.44	19247.0
2020-11-16 06:00:00	AAPL	Stock	119.56	119.89	118.76	118.76	42864.0
2020-11-16 07:00:00	AAPL	Stock	118.97	119.29	118.21	118.88	562744.0
2020-11-16 08:00:00	AAPL	Stock	119.05	119.55	118.26	118.89	654570.0
2020-11-16 09:00:00	AAPL	Stock	118.886	120.14	118.146	119.949	14507200.0
2020-11-16 10:00:00	AAPL	Stock	119.95	120.72	119.8	120.674	13998453.0
2020-11-16 11:00:00	AAPL	Stock	120.68	120.83	120.305	120.745	8283932.0
2020-11-16 12:00:00	AAPL	Stock	120.745	120.99	120.28	120.43	7550208.0
2020-11-16 13:00:00	AAPL	Stock	120.425	120.59	120.0	120.22	7292175.0
2020-11-16 14:00:00	AAPL	Stock	120.22	120.37	119.79	119.905	6776033.0
2020-11-16 15:00:00	AAPL	Stock	119.908	120.5	119.64	120.35	11490195.0
2020-11-16 16:00:00	AAPL	Stock	120.35	120.47	120.09	120.4	7018364.0
2020-11-16 17:00:00	AAPL	Stock	120.4	120.43	119.95	120.06	153575.0
2020-11-16 18:00:00	AAPL	Stock	120.06	120.32	119.92	119.93	132019.0
2020-11-16 19:00:00	AAPL	Stock	119.93	120.02	119.75	119.9	143943.0
2020-11-16 04:00:00	MSFT	Stock	216.85	218.0	216.85	217.92	2387.0
2020-11-16 05:00:00	MSFT	Stock	217.82	218.0	217.6	217.68	3030.0
2020-11-16 06:00:00	MSFT	Stock	217.9	217.92	216.08	216.08	5292.0
2020-11-16 07:00:00	MSFT	Stock	217.75	217.75	213.63	215.7	62590.0
2020-11-16 08:00:00	MSFT	Stock	215.55	216.92	213.791	214.9	112792.0
2020-11-16 09:00:00	MSFT	Stock	214.89	216.933	214.08	216.52	3641835.0
2020-11-16 10:00:00	MSFT	Stock	216.52	217.19	215.64	217.18	2233209.0
2020-11-16 11:00:00	MSFT	Stock	217.19	217.74	216.48	216.77	1603674.0
2020-11-16 12:00:00	MSFT	Stock	216.78	216.88	215.85	215.97	1380886.0
2020-11-16 13:00:00	MSFT	Stock	215.97	216.92	215.61	216.82	1595748.0
2020-11-16 14:00:00	MSFT	Stock	216.83	217.11	215.86	215.94	1263377.0
2020-11-16 15:00:00	MSFT	Stock	215.95	217.55	215.69	217.39	3679359.0
2020-11-16 16:00:00	MSFT	Stock	217.23	217.72	217.043	217.46	4549941.0
2020-11-16 17:00:00	MSFT	Stock	217.4	217.5	217.02	217.2	8750.0
2020-11-16 18:00:00	MSFT	Stock	217.25	217.4	216.56	216.96	16464.0
2020-11-16 19:00:00	MSFT	Stock	216.93	216.94	216.51	216.94	13623.0
2020-11-16 04:00:00	NVDA	Stock	13.4062	13.4062	13.4062	13.4062	11600.0
2020-11-16 05:00:00	NVDA	Stock	13.4275	13.45	13.4275	13.4368	153320.0
2020-11-16 06:00:00	NVDA	Stock	13.425	13.4482	13.3	13.3	260960.0
2020-11-16 07:00:00	NVDA	Stock	13.447	13.447	13.1515	13.2375	2555520.0
2020-11-16 08:00:00	NVDA	Stock	13.2796	13.4	13.15	13.2015	4848400.0
2020-11-16 09:00:00	NVDA	Stock	13.2339	13.6192	13.15	13.5075	84343960.0
2020-11-16 10:00:00	NVDA	Stock	13.5126	13.6495	13.5034	13.5894	65236520.0
2020-11-16 11:00:00	NVDA	Stock	13.5918	13.6065	13.4292	13.5012	45225800.0
2020-11-16 12:00:00	NVDA	Stock	13.5068	13.535	13.4025	13.4208	34257440.0
2020-11-16 13:00:00	NVDA	Stock	13.418	13.4625	13.3325	13.3808	45067760.0
2020-11-16 14:00:00	NVDA	Stock	13.3822	13.4536	13.3475	13.4309	29157680.0
2020-11-16 15:00:00	NVDA	Stock	13.4312	13.5262	13.3919	13.5192	32015880.0
2020-11-16 16:00:00	NVDA	Stock	13.5153	13.5508	13.513	13.5355	18791920.0
2020-11-16 17:00:00	NVDA	Stock	13.55	13.55	13.525	13.5472	499720.0
2020-11-16 18:00:00	NVDA	Stock	13.5465	13.5605	13.5338	13.5338	402960.0
2020-11-16 19:00:00	NVDA	Stock	13.54	13.55	13.5325	13.5375	514280.0
2020-11-16 05:00:00	AMZN	Stock	157.19	157.25	157.05	157.05	9500.0
2020-11-16 06:00:00	AMZN	Stock	157.0495	157.15	155.0	155.0	64740.0

> showing 50 of 61,858 rows — these rows as CSV

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