PREVIEW / stock_1hour / 2018-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-20.parquet
  size:    1.1 MB
  rows:    51,265
  symbols: 2,763

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
2018-12-20 04:00:00	AAPL	Stock	40.0475	40.25	40.0475	40.235	11908.0
2018-12-20 05:00:00	AAPL	Stock	40.155	40.25	40.1	40.175	23808.0
2018-12-20 06:00:00	AAPL	Stock	40.21	40.3125	40.21	40.3	24252.0
2018-12-20 07:00:00	AAPL	Stock	40.3025	40.4225	40.2875	40.3675	203352.0
2018-12-20 08:00:00	AAPL	Stock	40.4375	40.4375	39.98	40.0125	887352.0
2018-12-20 09:00:00	AAPL	Stock	40.0	40.5275	39.935	40.385	25764112.0
2018-12-20 10:00:00	AAPL	Stock	40.385	40.5175	40.045	40.1412	24744076.0
2018-12-20 11:00:00	AAPL	Stock	40.1375	40.2	39.66	39.8475	28533876.0
2018-12-20 12:00:00	AAPL	Stock	39.8475	39.91	39.385	39.5938	26353056.0
2018-12-20 13:00:00	AAPL	Stock	39.5938	39.6135	39.1025	39.1375	24450424.0
2018-12-20 14:00:00	AAPL	Stock	39.135	39.645	38.825	39.3925	38206152.0
2018-12-20 15:00:00	AAPL	Stock	39.39	39.585	39.0075	39.225	43049632.0
2018-12-20 16:00:00	AAPL	Stock	39.225	39.5	39.175	39.47	20466388.0
2018-12-20 17:00:00	AAPL	Stock	39.4375	39.4875	39.3875	39.46	80540.0
2018-12-20 18:00:00	AAPL	Stock	39.46	39.535	39.3875	39.4	110120.0
2018-12-20 19:00:00	AAPL	Stock	39.39	39.39	39.3025	39.375	83552.0
2018-12-20 04:00:00	MSFT	Stock	103.2	103.7	103.2	103.6	2047.0
2018-12-20 05:00:00	MSFT	Stock	103.6	103.68	103.5	103.5	3010.0
2018-12-20 06:00:00	MSFT	Stock	103.55	104.08	103.55	104.08	4164.0
2018-12-20 07:00:00	MSFT	Stock	104.02	104.3	103.85	104.05	18704.0
2018-12-20 08:00:00	MSFT	Stock	104.17	104.3	103.2	103.25	42588.0
2018-12-20 09:00:00	MSFT	Stock	103.25	104.31	102.48	103.15	4938989.0
2018-12-20 10:00:00	MSFT	Stock	103.15	103.98	102.32	102.585	6354572.0
2018-12-20 11:00:00	MSFT	Stock	102.56	102.647	98.78	100.33	11133818.0
2018-12-20 12:00:00	MSFT	Stock	100.35	101.4	99.8	101.2	7128284.0
2018-12-20 13:00:00	MSFT	Stock	101.19	101.23	100.33	100.54	4417890.0
2018-12-20 14:00:00	MSFT	Stock	100.53	102.54	99.48	101.945	8057214.0
2018-12-20 15:00:00	MSFT	Stock	101.94	102.38	100.55	101.68	10326570.0
2018-12-20 16:00:00	MSFT	Stock	101.68	102.78	101.27	102.39	11052156.0
2018-12-20 17:00:00	MSFT	Stock	102.35	102.75	102.32	102.4	33029.0
2018-12-20 18:00:00	MSFT	Stock	102.5	102.87	102.42	102.6	14045.0
2018-12-20 19:00:00	MSFT	Stock	102.45	102.49	102.12	102.49	13393.0
2018-12-20 04:00:00	NVDA	Stock	3.45	3.4625	3.45	3.4623	100880.0
2018-12-20 05:00:00	NVDA	Stock	3.4575	3.4575	3.4495	3.45	357040.0
2018-12-20 06:00:00	NVDA	Stock	3.46	3.4873	3.4562	3.4708	96320.0
2018-12-20 07:00:00	NVDA	Stock	3.472	3.4855	3.4625	3.48	554200.0
2018-12-20 08:00:00	NVDA	Stock	3.48	3.4962	3.4438	3.45	2181160.0
2018-12-20 09:00:00	NVDA	Stock	3.4558	3.524	3.4432	3.5195	95785320.0
2018-12-20 10:00:00	NVDA	Stock	3.5208	3.545	3.465	3.4658	105153720.0
2018-12-20 11:00:00	NVDA	Stock	3.468	3.468	3.343	3.3785	97717720.0
2018-12-20 12:00:00	NVDA	Stock	3.3792	3.392	3.33	3.3724	89362200.0
2018-12-20 13:00:00	NVDA	Stock	3.372	3.3764	3.3172	3.3642	67167320.0
2018-12-20 14:00:00	NVDA	Stock	3.365	3.4222	3.3333	3.4135	82611680.0
2018-12-20 15:00:00	NVDA	Stock	3.4128	3.4178	3.367	3.379	88129000.0
2018-12-20 16:00:00	NVDA	Stock	3.3775	3.4062	3.3775	3.4	20272280.0
2018-12-20 17:00:00	NVDA	Stock	3.406	3.4062	3.392	3.392	848680.0
2018-12-20 18:00:00	NVDA	Stock	3.3992	3.4062	3.3875	3.3875	548360.0
2018-12-20 19:00:00	NVDA	Stock	3.3925	3.3925	3.38	3.3868	357400.0
2018-12-20 04:00:00	AMZN	Stock	74.25	74.25	74.25	74.25	2000.0
2018-12-20 05:00:00	AMZN	Stock	74.518	74.518	74.4005	74.4005	6780.0

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

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