PREVIEW / stock_1hour / 2020-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-04.parquet
  size:    1.4 MB
  rows:    62,328
  symbols: 2,643

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-04 04:00:00	AAPL	Stock	123.3	123.31	123.15	123.2	9668.0
2020-12-04 05:00:00	AAPL	Stock	123.23	123.23	123.12	123.18	14934.0
2020-12-04 06:00:00	AAPL	Stock	123.2	123.3	123.16	123.27	5729.0
2020-12-04 07:00:00	AAPL	Stock	123.25	123.28	122.9	122.9	96772.0
2020-12-04 08:00:00	AAPL	Stock	123.268	123.28	122.67	122.74	278008.0
2020-12-04 09:00:00	AAPL	Stock	122.75	122.861	121.54	122.07	11380806.0
2020-12-04 10:00:00	AAPL	Stock	122.06	122.18	121.52	121.79	10561690.0
2020-12-04 11:00:00	AAPL	Stock	121.788	122.665	121.62	122.373	8072852.0
2020-12-04 12:00:00	AAPL	Stock	122.38	122.4	121.825	122.153	6325460.0
2020-12-04 13:00:00	AAPL	Stock	122.155	122.21	121.81	121.835	4320262.0
2020-12-04 14:00:00	AAPL	Stock	121.835	122.18	121.67	122.075	5825753.0
2020-12-04 15:00:00	AAPL	Stock	122.08	122.3	121.88	122.24	10575129.0
2020-12-04 16:00:00	AAPL	Stock	122.25	122.3	122.01	122.03	8636875.0
2020-12-04 17:00:00	AAPL	Stock	122.02	122.25	122.0	122.02	111895.0
2020-12-04 18:00:00	AAPL	Stock	122.05	122.07	122.0	122.01	42091.0
2020-12-04 19:00:00	AAPL	Stock	122.01	122.14	122.0	122.14	48823.0
2020-12-04 04:00:00	MSFT	Stock	214.7	215.19	214.7	215.19	759.0
2020-12-04 05:00:00	MSFT	Stock	215.08	215.13	214.87	214.87	1373.0
2020-12-04 07:00:00	MSFT	Stock	214.71	214.75	214.41	214.41	9453.0
2020-12-04 08:00:00	MSFT	Stock	214.6	214.8	213.71	214.38	33162.0
2020-12-04 09:00:00	MSFT	Stock	214.41	215.31	213.92	214.795	1982608.0
2020-12-04 10:00:00	MSFT	Stock	214.78	215.38	214.08	214.89	2354627.0
2020-12-04 11:00:00	MSFT	Stock	214.89	215.01	213.99	214.08	1899083.0
2020-12-04 12:00:00	MSFT	Stock	214.09	214.38	213.92	214.146	1845202.0
2020-12-04 13:00:00	MSFT	Stock	214.142	214.29	213.51	213.51	1603653.0
2020-12-04 14:00:00	MSFT	Stock	213.51	213.71	213.18	213.604	1751321.0
2020-12-04 15:00:00	MSFT	Stock	213.61	214.4	213.23	214.4	3078265.0
2020-12-04 16:00:00	MSFT	Stock	214.39	214.4	213.82	214.18	4487399.0
2020-12-04 17:00:00	MSFT	Stock	214.18	214.36	214.0	214.175	153863.0
2020-12-04 18:00:00	MSFT	Stock	214.1	214.1	214.05	214.1	3697.0
2020-12-04 19:00:00	MSFT	Stock	214.0	214.04	213.96	214.03	9451.0
2020-12-04 07:00:00	NVDA	Stock	13.4475	13.4475	13.436	13.436	50680.0
2020-12-04 08:00:00	NVDA	Stock	13.45	13.45	13.4125	13.4225	378560.0
2020-12-04 09:00:00	NVDA	Stock	13.42	13.525	13.3887	13.51	29026480.0
2020-12-04 10:00:00	NVDA	Stock	13.5099	13.55	13.4188	13.4438	19875160.0
2020-12-04 11:00:00	NVDA	Stock	13.4386	13.5505	13.4198	13.5183	14344520.0
2020-12-04 12:00:00	NVDA	Stock	13.5195	13.5562	13.4658	13.5536	14525640.0
2020-12-04 13:00:00	NVDA	Stock	13.554	13.56	13.4685	13.4765	15013080.0
2020-12-04 14:00:00	NVDA	Stock	13.4775	13.515	13.4572	13.515	10866520.0
2020-12-04 15:00:00	NVDA	Stock	13.5168	13.5598	13.462	13.5598	41478440.0
2020-12-04 16:00:00	NVDA	Stock	13.5582	13.5588	13.5111	13.5243	18420800.0
2020-12-04 17:00:00	NVDA	Stock	13.5582	13.5582	13.5215	13.5215	202520.0
2020-12-04 18:00:00	NVDA	Stock	13.5213	13.5248	13.515	13.5238	111400.0
2020-12-04 19:00:00	NVDA	Stock	13.52	13.52	13.5188	13.52	49120.0
2020-12-04 04:00:00	AMZN	Stock	159.85	159.85	159.0	159.0	16980.0
2020-12-04 05:00:00	AMZN	Stock	159.312	159.312	159.312	159.312	4360.0
2020-12-04 06:00:00	AMZN	Stock	159.75	159.75	159.75	159.75	2000.0
2020-12-04 07:00:00	AMZN	Stock	159.8605	159.8605	159.55	159.55	79760.0
2020-12-04 08:00:00	AMZN	Stock	159.875	159.95	159.3365	159.3365	284260.0
2020-12-04 09:00:00	AMZN	Stock	159.6483	159.9105	158.6335	159.0975	5714200.0

> showing 50 of 62,328 rows — these rows as CSV

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