PREVIEW / stock_1hour / 2017-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-13.parquet
  size:    1.1 MB
  rows:    48,835
  symbols: 2,956

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
2017-11-13 04:00:00	AAPL	Stock	43.675	43.75	43.65	43.65	6800.0
2017-11-13 06:00:00	AAPL	Stock	43.625	43.625	43.5625	43.5625	1600.0
2017-11-13 07:00:00	AAPL	Stock	43.5625	43.5825	43.475	43.475	146456.0
2017-11-13 08:00:00	AAPL	Stock	43.595	43.6025	43.425	43.4375	344068.0
2017-11-13 09:00:00	AAPL	Stock	43.43	43.5375	43.35	43.4675	13114368.0
2017-11-13 10:00:00	AAPL	Stock	43.4675	43.625	43.44	43.55	12031932.0
2017-11-13 11:00:00	AAPL	Stock	43.5488	43.605	43.52	43.56	5849156.0
2017-11-13 12:00:00	AAPL	Stock	43.5612	43.5975	43.515	43.585	5143016.0
2017-11-13 13:00:00	AAPL	Stock	43.5825	43.6	43.5285	43.5925	3944076.0
2017-11-13 14:00:00	AAPL	Stock	43.5948	43.5975	43.5148	43.5275	4437780.0
2017-11-13 15:00:00	AAPL	Stock	43.5275	43.565	43.43	43.495	10473852.0
2017-11-13 16:00:00	AAPL	Stock	43.4925	43.6675	43.4625	43.4625	4176412.0
2017-11-13 17:00:00	AAPL	Stock	43.4725	43.4825	43.455	43.47	52180.0
2017-11-13 18:00:00	AAPL	Stock	43.47	43.485	43.45	43.4725	33008.0
2017-11-13 19:00:00	AAPL	Stock	43.47	43.47	43.45	43.455	31004.0
2017-11-13 05:00:00	MSFT	Stock	83.8	83.8	83.8	83.8	179.0
2017-11-13 07:00:00	MSFT	Stock	83.61	83.61	83.6	83.6	2193.0
2017-11-13 08:00:00	MSFT	Stock	83.75	83.8	83.6	83.61	13585.0
2017-11-13 09:00:00	MSFT	Stock	83.61	83.75	83.46	83.53	1490017.0
2017-11-13 10:00:00	MSFT	Stock	83.535	83.76	83.53	83.61	1426292.0
2017-11-13 11:00:00	MSFT	Stock	83.61	83.68	83.53	83.564	1190892.0
2017-11-13 12:00:00	MSFT	Stock	83.57	83.655	83.51	83.605	800245.0
2017-11-13 13:00:00	MSFT	Stock	83.6	83.72	83.53	83.71	829286.0
2017-11-13 14:00:00	MSFT	Stock	83.705	83.87	83.63	83.653	1157377.0
2017-11-13 15:00:00	MSFT	Stock	83.66	83.94	83.66	83.93	2214447.0
2017-11-13 16:00:00	MSFT	Stock	83.93	83.97	83.81	83.9	3839657.0
2017-11-13 17:00:00	MSFT	Stock	83.9	83.92	83.85	83.85	2338.0
2017-11-13 18:00:00	MSFT	Stock	83.92	83.95	83.92	83.95	5795.0
2017-11-13 19:00:00	MSFT	Stock	83.93	83.99	83.93	83.99	3900.0
2017-11-13 04:00:00	NVDA	Stock	5.4375	5.4462	5.425	5.425	147520.0
2017-11-13 05:00:00	NVDA	Stock	5.4213	5.4248	5.4213	5.4238	82640.0
2017-11-13 06:00:00	NVDA	Stock	5.405	5.4238	5.39	5.4085	224200.0
2017-11-13 07:00:00	NVDA	Stock	5.4	5.412	5.3905	5.3948	1012920.0
2017-11-13 08:00:00	NVDA	Stock	5.398	5.4125	5.3875	5.3903	2415600.0
2017-11-13 09:00:00	NVDA	Stock	5.392	5.4292	5.3578	5.3736	107212360.0
2017-11-13 10:00:00	NVDA	Stock	5.374	5.382	5.3108	5.3399	132177000.0
2017-11-13 11:00:00	NVDA	Stock	5.3398	5.355	5.318	5.3315	69378440.0
2017-11-13 12:00:00	NVDA	Stock	5.3315	5.3415	5.3223	5.3278	41738400.0
2017-11-13 13:00:00	NVDA	Stock	5.328	5.334	5.3125	5.3255	45675040.0
2017-11-13 14:00:00	NVDA	Stock	5.3257	5.3515	5.3233	5.3455	45144160.0
2017-11-13 15:00:00	NVDA	Stock	5.3452	5.3493	5.3002	5.3145	84839440.0
2017-11-13 16:00:00	NVDA	Stock	5.3158	5.3238	5.305	5.3238	7011560.0
2017-11-13 17:00:00	NVDA	Stock	5.322	5.3245	5.3175	5.324	636560.0
2017-11-13 18:00:00	NVDA	Stock	5.3235	5.34	5.3235	5.3303	527960.0
2017-11-13 19:00:00	NVDA	Stock	5.335	5.335	5.3258	5.3298	232440.0
2017-11-13 06:00:00	AMZN	Stock	56.269	56.269	56.229	56.229	10000.0
2017-11-13 07:00:00	AMZN	Stock	56.1625	56.1625	56.1	56.15	47300.0
2017-11-13 08:00:00	AMZN	Stock	56.245	56.245	56.105	56.182	47000.0
2017-11-13 09:00:00	AMZN	Stock	56.1055	56.7715	56.05	56.7185	8719780.0
2017-11-13 10:00:00	AMZN	Stock	56.7145	56.775	56.5135	56.65	5753900.0

> showing 50 of 48,835 rows — these rows as CSV

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