PREVIEW / stock_1hour / 2018-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-13.parquet
  size:    1.1 MB
  rows:    49,096
  symbols: 2,725

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-13 04:00:00	AAPL	Stock	42.625	42.625	42.45	42.5475	11500.0
2018-12-13 05:00:00	AAPL	Stock	42.55	42.55	42.51	42.51	5568.0
2018-12-13 06:00:00	AAPL	Stock	42.475	42.475	42.355	42.355	15476.0
2018-12-13 07:00:00	AAPL	Stock	42.375	42.4875	42.365	42.4475	97300.0
2018-12-13 08:00:00	AAPL	Stock	42.4125	42.6575	42.375	42.5175	569084.0
2018-12-13 09:00:00	AAPL	Stock	42.525	42.7422	42.3875	42.595	13269420.0
2018-12-13 10:00:00	AAPL	Stock	42.6025	43.1425	42.5955	42.8675	28181712.0
2018-12-13 11:00:00	AAPL	Stock	42.865	43.0575	42.645	42.8288	15488920.0
2018-12-13 12:00:00	AAPL	Stock	42.8225	42.875	42.5475	42.635	11089860.0
2018-12-13 13:00:00	AAPL	Stock	42.6325	42.885	42.525	42.675	9580784.0
2018-12-13 14:00:00	AAPL	Stock	42.6775	42.7325	42.4625	42.7025	11589924.0
2018-12-13 15:00:00	AAPL	Stock	42.7025	42.825	42.4725	42.71	15851632.0
2018-12-13 16:00:00	AAPL	Stock	42.7375	42.75	42.625	42.6375	8770568.0
2018-12-13 17:00:00	AAPL	Stock	42.6375	42.6625	42.58	42.5875	58984.0
2018-12-13 18:00:00	AAPL	Stock	42.5875	42.65	42.5375	42.6225	45920.0
2018-12-13 19:00:00	AAPL	Stock	42.625	42.6375	42.585	42.6075	68972.0
2018-12-13 04:00:00	MSFT	Stock	109.8	109.8	109.6	109.6	400.0
2018-12-13 06:00:00	MSFT	Stock	109.47	109.47	109.3	109.3	850.0
2018-12-13 07:00:00	MSFT	Stock	109.4	109.75	109.3	109.74	14344.0
2018-12-13 08:00:00	MSFT	Stock	109.5	110.05	109.35	109.91	28682.0
2018-12-13 09:00:00	MSFT	Stock	109.92	110.17	108.93	109.61	3002735.0
2018-12-13 10:00:00	MSFT	Stock	109.62	110.87	108.64	109.21	4707468.0
2018-12-13 11:00:00	MSFT	Stock	109.2	109.65	108.87	109.01	3603948.0
2018-12-13 12:00:00	MSFT	Stock	109.0	109.35	108.7	109.13	2448612.0
2018-12-13 13:00:00	MSFT	Stock	109.12	109.77	108.783	109.23	2452296.0
2018-12-13 14:00:00	MSFT	Stock	109.24	109.29	108.63	109.117	2478750.0
2018-12-13 15:00:00	MSFT	Stock	109.12	109.73	108.9	109.41	4619823.0
2018-12-13 16:00:00	MSFT	Stock	109.41	109.5	109.11	109.31	4585600.0
2018-12-13 17:00:00	MSFT	Stock	109.38	109.45	109.31	109.31	7247.0
2018-12-13 18:00:00	MSFT	Stock	109.42	109.54	109.24	109.54	6615.0
2018-12-13 19:00:00	MSFT	Stock	109.5	109.5	109.09	109.09	6170.0
2018-12-13 05:00:00	NVDA	Stock	3.7562	3.7562	3.75	3.75	18400.0
2018-12-13 06:00:00	NVDA	Stock	3.7625	3.7625	3.7403	3.7403	66720.0
2018-12-13 07:00:00	NVDA	Stock	3.7445	3.775	3.7438	3.7632	634600.0
2018-12-13 08:00:00	NVDA	Stock	3.75	3.7962	3.747	3.7845	1960320.0
2018-12-13 09:00:00	NVDA	Stock	3.783	3.8345	3.7375	3.7489	91325760.0
2018-12-13 10:00:00	NVDA	Stock	3.751	3.8095	3.6903	3.7255	102304400.0
2018-12-13 11:00:00	NVDA	Stock	3.7261	3.7375	3.686	3.7025	50989320.0
2018-12-13 12:00:00	NVDA	Stock	3.7022	3.7282	3.6895	3.7185	36502600.0
2018-12-13 13:00:00	NVDA	Stock	3.718	3.768	3.7153	3.7459	51327240.0
2018-12-13 14:00:00	NVDA	Stock	3.7453	3.7535	3.7275	3.7459	28280680.0
2018-12-13 15:00:00	NVDA	Stock	3.7455	3.7492	3.7175	3.722	50993080.0
2018-12-13 16:00:00	NVDA	Stock	3.722	3.7222	3.705	3.705	22386160.0
2018-12-13 17:00:00	NVDA	Stock	3.71	3.715	3.7062	3.715	258480.0
2018-12-13 18:00:00	NVDA	Stock	3.7102	3.7222	3.7102	3.7222	151720.0
2018-12-13 19:00:00	NVDA	Stock	3.7222	3.725	3.7025	3.7025	193440.0
2018-12-13 04:00:00	AMZN	Stock	83.9	83.9	83.9	83.9	2000.0
2018-12-13 06:00:00	AMZN	Stock	83.9575	83.9575	83.8505	83.8505	8000.0
2018-12-13 07:00:00	AMZN	Stock	83.9	83.9395	83.75	83.9395	123460.0
2018-12-13 08:00:00	AMZN	Stock	83.85	84.3	83.7	84.1	283640.0

> showing 50 of 49,096 rows — these rows as CSV

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