PREVIEW / stock_1hour / 2020-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-11.parquet
  size:    1.4 MB
  rows:    63,056
  symbols: 2,679

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-11 04:00:00	AAPL	Stock	122.92	122.99	122.8	122.8	22244.0
2020-12-11 05:00:00	AAPL	Stock	122.6	122.84	122.07	122.07	16380.0
2020-12-11 06:00:00	AAPL	Stock	122.07	122.32	121.5	122.04	41636.0
2020-12-11 07:00:00	AAPL	Stock	122.13	122.52	122.0	122.48	158719.0
2020-12-11 08:00:00	AAPL	Stock	122.48	122.94	122.01	122.65	318216.0
2020-12-11 09:00:00	AAPL	Stock	122.64	122.76	120.88	121.25	13677881.0
2020-12-11 10:00:00	AAPL	Stock	121.25	122.011	121.17	121.33	9871519.0
2020-12-11 11:00:00	AAPL	Stock	121.325	121.715	120.8	120.99	7861087.0
2020-12-11 12:00:00	AAPL	Stock	120.995	121.45	120.55	121.4	7446231.0
2020-12-11 13:00:00	AAPL	Stock	121.4	121.835	121.22	121.72	6523927.0
2020-12-11 14:00:00	AAPL	Stock	121.73	122.16	121.62	121.972	7409514.0
2020-12-11 15:00:00	AAPL	Stock	121.97	122.5	121.73	122.49	12229460.0
2020-12-11 16:00:00	AAPL	Stock	122.48	122.49	121.726	122.3	11594401.0
2020-12-11 17:00:00	AAPL	Stock	122.28	122.41	122.2	122.21	50661.0
2020-12-11 18:00:00	AAPL	Stock	122.19	122.29	122.15	122.15	27152.0
2020-12-11 19:00:00	AAPL	Stock	122.17	122.28	122.15	122.28	45856.0
2020-12-11 04:00:00	MSFT	Stock	210.45	210.82	210.07	210.25	6629.0
2020-12-11 05:00:00	MSFT	Stock	210.09	210.25	209.51	209.51	17143.0
2020-12-11 06:00:00	MSFT	Stock	209.85	209.89	209.01	209.6	9385.0
2020-12-11 07:00:00	MSFT	Stock	209.77	210.0	209.4	209.77	14241.0
2020-12-11 08:00:00	MSFT	Stock	209.785	210.1	209.516	210.1	56726.0
2020-12-11 09:00:00	MSFT	Stock	210.1	210.78	209.11	210.55	3001528.0
2020-12-11 10:00:00	MSFT	Stock	210.58	212.11	210.04	211.05	3855033.0
2020-12-11 11:00:00	MSFT	Stock	211.07	211.77	210.23	210.87	2080052.0
2020-12-11 12:00:00	MSFT	Stock	210.87	211.76	210.84	211.545	2117525.0
2020-12-11 13:00:00	MSFT	Stock	211.545	212.96	211.5	212.44	1861368.0
2020-12-11 14:00:00	MSFT	Stock	212.45	212.63	211.88	212.37	1690725.0
2020-12-11 15:00:00	MSFT	Stock	212.36	213.32	212.15	213.27	3911286.0
2020-12-11 16:00:00	MSFT	Stock	213.26	213.29	209.522	213.22	5110485.0
2020-12-11 17:00:00	MSFT	Stock	213.22	213.25	213.08	213.1	8429.0
2020-12-11 18:00:00	MSFT	Stock	213.06	213.2	212.0	213.01	3877.0
2020-12-11 19:00:00	MSFT	Stock	213.0	213.24	212.98	213.0	1921.0
2020-12-11 04:00:00	NVDA	Stock	12.9623	12.9623	12.9305	12.9305	12600.0
2020-12-11 05:00:00	NVDA	Stock	12.9225	12.9225	12.86	12.86	54600.0
2020-12-11 06:00:00	NVDA	Stock	12.86	12.86	12.86	12.86	5000.0
2020-12-11 07:00:00	NVDA	Stock	12.925	12.925	12.8788	12.9125	267760.0
2020-12-11 08:00:00	NVDA	Stock	12.9	13.0045	12.876	12.9118	683600.0
2020-12-11 09:00:00	NVDA	Stock	12.9125	13.02	12.8474	12.9232	22210520.0
2020-12-11 10:00:00	NVDA	Stock	12.916	13.0088	12.905	12.9375	25609880.0
2020-12-11 11:00:00	NVDA	Stock	12.9382	12.9673	12.8578	12.8666	13701960.0
2020-12-11 12:00:00	NVDA	Stock	12.8678	12.9027	12.823	12.8855	21172440.0
2020-12-11 13:00:00	NVDA	Stock	12.8873	12.986	12.884	12.9683	20379320.0
2020-12-11 14:00:00	NVDA	Stock	12.97	13.014	12.9548	12.976	15346240.0
2020-12-11 15:00:00	NVDA	Stock	12.9762	13.0188	12.9485	13.0162	27929960.0
2020-12-11 16:00:00	NVDA	Stock	13.0132	13.0325	12.9577	13.0125	19452200.0
2020-12-11 17:00:00	NVDA	Stock	13.0125	13.0132	13.006	13.0132	181200.0
2020-12-11 18:00:00	NVDA	Stock	13.0125	13.0125	13.0063	13.0075	33560.0
2020-12-11 19:00:00	NVDA	Stock	13.0088	13.0088	13.005	13.005	13920.0
2020-12-11 04:00:00	AMZN	Stock	154.75	154.76	154.75	154.75	36740.0
2020-12-11 05:00:00	AMZN	Stock	154.3965	154.3965	153.9	153.9	11460.0

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

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