PREVIEW / stock_1hour / 2019-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-30.parquet
  size:    1.1 MB
  rows:    50,162
  symbols: 2,691

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-01-30 04:00:00	AAPL	Stock	40.825	40.825	40.6075	40.6275	163548.0
2019-01-30 05:00:00	AAPL	Stock	40.625	40.9225	40.625	40.825	175612.0
2019-01-30 06:00:00	AAPL	Stock	40.8375	40.875	40.75	40.8	199216.0
2019-01-30 07:00:00	AAPL	Stock	40.85	40.875	40.6425	40.675	1042172.0
2019-01-30 08:00:00	AAPL	Stock	40.6975	40.875	40.2775	40.5025	2898420.0
2019-01-30 09:00:00	AAPL	Stock	40.5	40.845	40.165	40.1945	42909364.0
2019-01-30 10:00:00	AAPL	Stock	40.1938	40.67	40.0575	40.635	34211364.0
2019-01-30 11:00:00	AAPL	Stock	40.6375	40.7838	40.4625	40.576	23259868.0
2019-01-30 12:00:00	AAPL	Stock	40.5775	40.75	40.475	40.7138	18396832.0
2019-01-30 13:00:00	AAPL	Stock	40.7138	40.8125	40.605	40.755	14688948.0
2019-01-30 14:00:00	AAPL	Stock	40.7575	41.5375	40.7475	41.5125	37527612.0
2019-01-30 15:00:00	AAPL	Stock	41.52	41.5225	40.95	41.31	33654488.0
2019-01-30 16:00:00	AAPL	Stock	41.3125	41.445	41.25	41.425	10942432.0
2019-01-30 17:00:00	AAPL	Stock	41.42	41.465	41.3125	41.345	205120.0
2019-01-30 18:00:00	AAPL	Stock	41.3475	41.4375	41.325	41.4375	118292.0
2019-01-30 19:00:00	AAPL	Stock	41.4375	41.4375	41.355	41.375	105156.0
2019-01-30 04:00:00	MSFT	Stock	103.8	104.05	103.8	103.95	1216.0
2019-01-30 05:00:00	MSFT	Stock	103.93	104.01	103.74	103.97	9791.0
2019-01-30 06:00:00	MSFT	Stock	103.9	103.91	103.71	103.85	2006.0
2019-01-30 07:00:00	MSFT	Stock	103.99	104.54	103.99	104.5	80001.0
2019-01-30 08:00:00	MSFT	Stock	104.5	104.69	104.15	104.605	131092.0
2019-01-30 09:00:00	MSFT	Stock	104.61	104.95	104.33	104.93	4250578.0
2019-01-30 10:00:00	MSFT	Stock	104.925	105.01	104.41	104.5	4289014.0
2019-01-30 11:00:00	MSFT	Stock	104.51	105.49	104.51	105.475	3810955.0
2019-01-30 12:00:00	MSFT	Stock	105.48	106.07	105.45	105.54	3854635.0
2019-01-30 13:00:00	MSFT	Stock	105.54	105.62	105.16	105.321	2504794.0
2019-01-30 14:00:00	MSFT	Stock	105.33	106.36	105.28	106.288	7256374.0
2019-01-30 15:00:00	MSFT	Stock	106.285	106.38	105.72	106.38	8096896.0
2019-01-30 16:00:00	MSFT	Stock	106.38	106.86	101.76	102.27	7276504.0
2019-01-30 17:00:00	MSFT	Stock	102.29	106.38	101.46	104.25	1279155.0
2019-01-30 18:00:00	MSFT	Stock	104.25	105.48	103.11	103.69	1309637.0
2019-01-30 19:00:00	MSFT	Stock	103.8	103.85	103.25	103.49	72309.0
2019-01-30 04:00:00	NVDA	Stock	3.35	3.3555	3.3452	3.3555	43800.0
2019-01-30 05:00:00	NVDA	Stock	3.3462	3.3508	3.3462	3.3505	18000.0
2019-01-30 06:00:00	NVDA	Stock	3.3505	3.3505	3.35	3.3505	53760.0
2019-01-30 07:00:00	NVDA	Stock	3.3618	3.3618	3.3413	3.3548	1980480.0
2019-01-30 08:00:00	NVDA	Stock	3.345	3.371	3.29	3.3658	5977040.0
2019-01-30 09:00:00	NVDA	Stock	3.3653	3.3812	3.2978	3.3048	161184600.0
2019-01-30 10:00:00	NVDA	Stock	3.3048	3.3712	3.2865	3.3532	178637440.0
2019-01-30 11:00:00	NVDA	Stock	3.3538	3.375	3.3298	3.3512	101991240.0
2019-01-30 12:00:00	NVDA	Stock	3.3512	3.3848	3.3475	3.374	81989560.0
2019-01-30 13:00:00	NVDA	Stock	3.3741	3.3943	3.3677	3.3908	60409320.0
2019-01-30 14:00:00	NVDA	Stock	3.3903	3.4492	3.3875	3.443	133965600.0
2019-01-30 15:00:00	NVDA	Stock	3.4428	3.444	3.417	3.4365	134329560.0
2019-01-30 16:00:00	NVDA	Stock	3.4348	3.4422	3.3928	3.4288	41884560.0
2019-01-30 17:00:00	NVDA	Stock	3.4318	3.4412	3.4288	3.4412	816640.0
2019-01-30 18:00:00	NVDA	Stock	3.4408	3.4438	3.4325	3.4403	682560.0
2019-01-30 19:00:00	NVDA	Stock	3.4408	3.4498	3.4405	3.4488	624920.0
2019-01-30 04:00:00	AMZN	Stock	80.75	81.0425	80.75	81.0425	18760.0
2019-01-30 05:00:00	AMZN	Stock	80.932	80.997	80.828	80.9005	26660.0

> showing 50 of 50,162 rows — these rows as CSV

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