PREVIEW / stock_1hour / 2019-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-23.parquet
  size:    1.1 MB
  rows:    51,215
  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
2019-09-23 04:00:00	AAPL	Stock	54.5625	54.7225	54.35	54.35	28660.0
2019-09-23 05:00:00	AAPL	Stock	54.35	54.5275	54.35	54.5275	8796.0
2019-09-23 06:00:00	AAPL	Stock	54.5625	54.6175	54.515	54.515	14548.0
2019-09-23 07:00:00	AAPL	Stock	54.65	54.7175	54.515	54.515	160672.0
2019-09-23 08:00:00	AAPL	Stock	54.625	54.7175	54.4325	54.6275	270376.0
2019-09-23 09:00:00	AAPL	Stock	54.62	54.8725	54.5125	54.6338	11467080.0
2019-09-23 10:00:00	AAPL	Stock	54.64	54.685	54.4125	54.53	11246456.0
2019-09-23 11:00:00	AAPL	Stock	54.53	54.7825	54.5175	54.68	7900572.0
2019-09-23 12:00:00	AAPL	Stock	54.6825	54.805	54.635	54.69	4798960.0
2019-09-23 13:00:00	AAPL	Stock	54.69	54.8438	54.6425	54.8125	3932016.0
2019-09-23 14:00:00	AAPL	Stock	54.815	54.9375	54.7925	54.8525	4527916.0
2019-09-23 15:00:00	AAPL	Stock	54.85	54.96	54.65	54.67	10064904.0
2019-09-23 16:00:00	AAPL	Stock	54.68	54.8125	54.6125	54.8125	9298620.0
2019-09-23 17:00:00	AAPL	Stock	54.775	54.8175	54.68	54.68	26492.0
2019-09-23 18:00:00	AAPL	Stock	54.8175	54.85	54.8125	54.815	43140.0
2019-09-23 19:00:00	AAPL	Stock	54.8375	54.98	54.8375	54.9625	95704.0
2019-09-23 04:00:00	MSFT	Stock	139.5	139.5	139.01	139.01	2100.0
2019-09-23 05:00:00	MSFT	Stock	139.0	139.3	139.0	139.3	4085.0
2019-09-23 06:00:00	MSFT	Stock	139.31	139.4	139.31	139.4	4229.0
2019-09-23 07:00:00	MSFT	Stock	139.25	139.6	139.25	139.3	5974.0
2019-09-23 08:00:00	MSFT	Stock	139.69	139.69	139.1	139.26	22211.0
2019-09-23 09:00:00	MSFT	Stock	139.3	139.46	138.44	138.77	1724688.0
2019-09-23 10:00:00	MSFT	Stock	138.78	139.47	138.51	139.0	1777041.0
2019-09-23 11:00:00	MSFT	Stock	139.01	139.63	138.96	139.37	1543610.0
2019-09-23 12:00:00	MSFT	Stock	139.39	139.62	139.12	139.22	1237508.0
2019-09-23 13:00:00	MSFT	Stock	139.21	139.57	139.205	139.324	987124.0
2019-09-23 14:00:00	MSFT	Stock	139.33	139.4	139.07	139.355	970738.0
2019-09-23 15:00:00	MSFT	Stock	139.35	139.59	139.05	139.09	2458355.0
2019-09-23 16:00:00	MSFT	Stock	139.14	139.64	139.05	139.59	3862065.0
2019-09-23 17:00:00	MSFT	Stock	139.53	139.6	139.14	139.45	9638.0
2019-09-23 18:00:00	MSFT	Stock	139.58	139.74	139.51	139.65	14236.0
2019-09-23 19:00:00	MSFT	Stock	139.64	139.93	139.64	139.9	29071.0
2019-09-23 04:00:00	NVDA	Stock	4.3	4.3125	4.2875	4.2875	111040.0
2019-09-23 05:00:00	NVDA	Stock	4.2875	4.2875	4.2875	4.2875	18720.0
2019-09-23 06:00:00	NVDA	Stock	4.3062	4.308	4.3062	4.3068	26240.0
2019-09-23 07:00:00	NVDA	Stock	4.305	4.3228	4.3015	4.3225	956040.0
2019-09-23 08:00:00	NVDA	Stock	4.3115	4.325	4.3	4.3175	1353120.0
2019-09-23 09:00:00	NVDA	Stock	4.3175	4.3952	4.3138	4.3739	47385000.0
2019-09-23 10:00:00	NVDA	Stock	4.375	4.3922	4.3375	4.3792	40714160.0
2019-09-23 11:00:00	NVDA	Stock	4.3783	4.394	4.3708	4.3835	24616440.0
2019-09-23 12:00:00	NVDA	Stock	4.3847	4.4167	4.38	4.4035	26184520.0
2019-09-23 13:00:00	NVDA	Stock	4.4038	4.4125	4.3965	4.3988	18255840.0
2019-09-23 14:00:00	NVDA	Stock	4.3995	4.3995	4.3792	4.3845	14347320.0
2019-09-23 15:00:00	NVDA	Stock	4.3835	4.397	4.3678	4.371	38371480.0
2019-09-23 16:00:00	NVDA	Stock	4.371	4.3888	4.3675	4.385	12556520.0
2019-09-23 17:00:00	NVDA	Stock	4.391	4.3916	4.391	4.3916	16000.0
2019-09-23 18:00:00	NVDA	Stock	4.3908	4.394	4.3898	4.394	87200.0
2019-09-23 19:00:00	NVDA	Stock	4.3938	4.412	4.3938	4.412	306080.0
2019-09-23 04:00:00	AMZN	Stock	89.3035	89.3035	89.3035	89.3035	2000.0
2019-09-23 05:00:00	AMZN	Stock	89.183	89.3955	89.183	89.3955	16780.0

> showing 50 of 51,215 rows — these rows as CSV

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