PREVIEW / stock_1hour / 2020-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-08.parquet
  size:    1.4 MB
  rows:    63,095
  symbols: 2,657

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-12-08 04:00:00	AAPL	Stock	123.65	123.88	123.45	123.49	10312.0
2020-12-08 05:00:00	AAPL	Stock	123.51	123.59	123.3	123.54	14240.0
2020-12-08 06:00:00	AAPL	Stock	123.58	123.6	123.0	123.0	19569.0
2020-12-08 07:00:00	AAPL	Stock	122.99	123.4	122.99	123.4	82585.0
2020-12-08 08:00:00	AAPL	Stock	123.339	124.96	123.0	124.56	1093300.0
2020-12-08 09:00:00	AAPL	Stock	124.56	124.69	123.45	123.89	11358859.0
2020-12-08 10:00:00	AAPL	Stock	123.89	124.22	123.09	123.339	11351542.0
2020-12-08 11:00:00	AAPL	Stock	123.335	123.92	123.17	123.89	6699132.0
2020-12-08 12:00:00	AAPL	Stock	123.885	124.405	123.855	124.296	6547333.0
2020-12-08 13:00:00	AAPL	Stock	124.295	124.87	124.23	124.76	8747268.0
2020-12-08 14:00:00	AAPL	Stock	124.761	124.96	124.39	124.95	7953385.0
2020-12-08 15:00:00	AAPL	Stock	124.96	124.98	124.325	124.33	9874619.0
2020-12-08 16:00:00	AAPL	Stock	124.37	124.4	124.21	124.33	6639648.0
2020-12-08 17:00:00	AAPL	Stock	124.3	124.33	124.21	124.32	69089.0
2020-12-08 18:00:00	AAPL	Stock	124.33	124.56	124.16	124.2	122532.0
2020-12-08 19:00:00	AAPL	Stock	124.19	124.5	124.19	124.28	128729.0
2020-12-08 04:00:00	MSFT	Stock	214.5	214.5	214.04	214.18	6142.0
2020-12-08 05:00:00	MSFT	Stock	214.15	214.36	214.15	214.36	683.0
2020-12-08 06:00:00	MSFT	Stock	214.11	214.24	213.78	213.78	6268.0
2020-12-08 07:00:00	MSFT	Stock	213.78	213.78	213.34	213.47	6504.0
2020-12-08 08:00:00	MSFT	Stock	213.567	213.78	213.41	213.62	34273.0
2020-12-08 09:00:00	MSFT	Stock	213.654	214.99	212.89	213.53	2345943.0
2020-12-08 10:00:00	MSFT	Stock	213.51	214.965	213.26	214.82	2624356.0
2020-12-08 11:00:00	MSFT	Stock	214.814	216.03	214.48	215.96	2379702.0
2020-12-08 12:00:00	MSFT	Stock	215.97	216.36	215.8	216.18	1713166.0
2020-12-08 13:00:00	MSFT	Stock	216.19	216.95	216.12	216.57	1596867.0
2020-12-08 14:00:00	MSFT	Stock	216.56	216.74	216.1	216.42	1283741.0
2020-12-08 15:00:00	MSFT	Stock	216.43	216.618	215.77	215.99	2471057.0
2020-12-08 16:00:00	MSFT	Stock	216.01	216.1	215.76	215.94	4026233.0
2020-12-08 17:00:00	MSFT	Stock	215.91	216.0	215.89	215.95	5195.0
2020-12-08 18:00:00	MSFT	Stock	216.0	216.26	215.85	215.96	19780.0
2020-12-08 19:00:00	MSFT	Stock	216.07	216.7	216.05	216.5	6309.0
2020-12-08 04:00:00	NVDA	Stock	13.5762	13.5762	13.5762	13.5762	8600.0
2020-12-08 05:00:00	NVDA	Stock	13.5808	13.5808	13.5808	13.5808	11680.0
2020-12-08 06:00:00	NVDA	Stock	13.525	13.525	13.525	13.525	11920.0
2020-12-08 07:00:00	NVDA	Stock	13.5195	13.555	13.5195	13.53	120760.0
2020-12-08 08:00:00	NVDA	Stock	13.572	13.572	13.5269	13.5269	369600.0
2020-12-08 09:00:00	NVDA	Stock	13.5275	13.5988	13.2962	13.3854	43129760.0
2020-12-08 10:00:00	NVDA	Stock	13.3875	13.4245	13.2815	13.3905	32183320.0
2020-12-08 11:00:00	NVDA	Stock	13.388	13.3988	13.335	13.3838	15839520.0
2020-12-08 12:00:00	NVDA	Stock	13.3839	13.4284	13.373	13.4175	18005080.0
2020-12-08 13:00:00	NVDA	Stock	13.4158	13.4918	13.4076	13.4605	19443640.0
2020-12-08 14:00:00	NVDA	Stock	13.459	13.4948	13.445	13.4502	16835800.0
2020-12-08 15:00:00	NVDA	Stock	13.45	13.4572	13.341	13.346	44932640.0
2020-12-08 16:00:00	NVDA	Stock	13.35	13.3625	13.3375	13.351	20509200.0
2020-12-08 17:00:00	NVDA	Stock	13.3615	13.3615	13.3505	13.3572	75440.0
2020-12-08 18:00:00	NVDA	Stock	13.3625	13.372	13.3625	13.372	122360.0
2020-12-08 19:00:00	NVDA	Stock	13.3618	13.371	13.3618	13.371	70080.0
2020-12-08 06:00:00	AMZN	Stock	157.99	157.99	157.99	157.99	2000.0
2020-12-08 07:00:00	AMZN	Stock	157.645	157.6505	157.645	157.6505	17340.0

> showing 50 of 63,095 rows — these rows as CSV

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