PREVIEW / stock_1hour / 2018-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-14.parquet
  size:    1.1 MB
  rows:    49,679
  symbols: 2,858

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-05-14 04:00:00	AAPL	Stock	47.255	47.3375	47.215	47.3375	18564.0
2018-05-14 05:00:00	AAPL	Stock	47.3325	47.3325	47.28	47.2875	4584.0
2018-05-14 06:00:00	AAPL	Stock	47.325	47.3325	47.275	47.275	29828.0
2018-05-14 07:00:00	AAPL	Stock	47.28	47.3225	47.2275	47.2625	173260.0
2018-05-14 08:00:00	AAPL	Stock	47.295	47.31	47.2125	47.225	227188.0
2018-05-14 09:00:00	AAPL	Stock	47.2075	47.3825	47.0875	47.105	11366800.0
2018-05-14 10:00:00	AAPL	Stock	47.111	47.3575	47.065	47.225	12499408.0
2018-05-14 11:00:00	AAPL	Stock	47.2275	47.3625	47.2075	47.2475	6761796.0
2018-05-14 12:00:00	AAPL	Stock	47.2475	47.32	47.1902	47.2	5810480.0
2018-05-14 13:00:00	AAPL	Stock	47.2025	47.2075	47.0875	47.12	6140260.0
2018-05-14 14:00:00	AAPL	Stock	47.1185	47.125	46.9825	47.0912	6072396.0
2018-05-14 15:00:00	AAPL	Stock	47.0925	47.142	46.965	47.0425	10616508.0
2018-05-14 16:00:00	AAPL	Stock	47.0375	47.06	47.0025	47.0125	12958052.0
2018-05-14 17:00:00	AAPL	Stock	47.015	47.0375	46.98	46.98	126580.0
2018-05-14 18:00:00	AAPL	Stock	47.0	47.0175	46.9775	46.98	37272.0
2018-05-14 19:00:00	AAPL	Stock	46.9875	47.0	46.955	46.955	35740.0
2018-05-14 05:00:00	MSFT	Stock	98.0	98.24	98.0	98.24	1483.0
2018-05-14 06:00:00	MSFT	Stock	98.19	98.19	98.03	98.03	1700.0
2018-05-14 07:00:00	MSFT	Stock	98.0	98.09	97.97	97.98	4829.0
2018-05-14 08:00:00	MSFT	Stock	97.96	98.02	97.91	97.91	12114.0
2018-05-14 09:00:00	MSFT	Stock	97.95	98.43	97.31	98.23	2977371.0
2018-05-14 10:00:00	MSFT	Stock	98.23	98.58	98.04	98.38	2226936.0
2018-05-14 11:00:00	MSFT	Stock	98.37	98.69	98.29	98.36	1730917.0
2018-05-14 12:00:00	MSFT	Stock	98.35	98.49	98.01	98.065	1397532.0
2018-05-14 13:00:00	MSFT	Stock	98.065	98.16	97.77	98.12	1490317.0
2018-05-14 14:00:00	MSFT	Stock	98.12	98.15	97.76	98.019	1387476.0
2018-05-14 15:00:00	MSFT	Stock	98.019	98.079	97.68	98.04	2935831.0
2018-05-14 16:00:00	MSFT	Stock	98.03	98.03	97.94	97.95	3730745.0
2018-05-14 17:00:00	MSFT	Stock	98.0	98.03	97.95	97.95	37765.0
2018-05-14 18:00:00	MSFT	Stock	97.99	98.02	97.99	98.02	1654.0
2018-05-14 19:00:00	MSFT	Stock	97.92	98.03	97.92	98.03	1102.0
2018-05-14 04:00:00	NVDA	Stock	6.3798	6.3935	6.375	6.3935	122240.0
2018-05-14 05:00:00	NVDA	Stock	6.3945	6.3948	6.3815	6.3912	76040.0
2018-05-14 06:00:00	NVDA	Stock	6.3912	6.4028	6.39	6.3962	296560.0
2018-05-14 07:00:00	NVDA	Stock	6.3955	6.4025	6.3815	6.3828	1113640.0
2018-05-14 08:00:00	NVDA	Stock	6.3875	6.4032	6.3703	6.392	2870360.0
2018-05-14 09:00:00	NVDA	Stock	6.3925	6.456	6.3855	6.3885	113419200.0
2018-05-14 10:00:00	NVDA	Stock	6.3902	6.45	6.3884	6.4272	76418480.0
2018-05-14 11:00:00	NVDA	Stock	6.4265	6.4623	6.4175	6.4215	65423600.0
2018-05-14 12:00:00	NVDA	Stock	6.4217	6.45	6.4158	6.4245	39027200.0
2018-05-14 13:00:00	NVDA	Stock	6.4232	6.4244	6.3775	6.407	48913400.0
2018-05-14 14:00:00	NVDA	Stock	6.4062	6.4098	6.381	6.407	33075560.0
2018-05-14 15:00:00	NVDA	Stock	6.4065	6.4105	6.36	6.3843	63655120.0
2018-05-14 16:00:00	NVDA	Stock	6.3905	6.3905	6.375	6.3775	39830000.0
2018-05-14 17:00:00	NVDA	Stock	6.3775	6.384	6.3755	6.3763	837720.0
2018-05-14 18:00:00	NVDA	Stock	6.3775	6.3838	6.3775	6.383	357320.0
2018-05-14 19:00:00	NVDA	Stock	6.3835	6.3838	6.3783	6.3838	291400.0
2018-05-14 04:00:00	AMZN	Stock	80.425	80.425	80.425	80.425	24920.0
2018-05-14 05:00:00	AMZN	Stock	80.3165	80.3165	80.3165	80.3165	2960.0
2018-05-14 06:00:00	AMZN	Stock	80.3275	80.3275	80.3275	80.3275	2720.0

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

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