PREVIEW / stock_1hour / 2018-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-21.parquet
  size:    1.1 MB
  rows:    49,287
  symbols: 2,849

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-21 04:00:00	AAPL	Stock	46.8025	46.925	46.8025	46.9225	22032.0
2018-05-21 05:00:00	AAPL	Stock	46.9075	46.93	46.9075	46.93	4200.0
2018-05-21 06:00:00	AAPL	Stock	46.93	46.9475	46.85	46.9025	12192.0
2018-05-21 07:00:00	AAPL	Stock	46.935	46.9875	46.8925	46.9875	122292.0
2018-05-21 08:00:00	AAPL	Stock	46.975	47.0175	46.93	47.01	389676.0
2018-05-21 09:00:00	AAPL	Stock	47.01	47.3175	46.945	47.2475	13287500.0
2018-05-21 10:00:00	AAPL	Stock	47.25	47.3175	47.085	47.145	11831136.0
2018-05-21 11:00:00	AAPL	Stock	47.1442	47.175	46.775	46.9025	10017992.0
2018-05-21 12:00:00	AAPL	Stock	46.905	47.0175	46.8875	46.96	4528584.0
2018-05-21 13:00:00	AAPL	Stock	46.9625	47.065	46.935	46.965	4091968.0
2018-05-21 14:00:00	AAPL	Stock	46.9662	46.9685	46.7278	46.83	5436540.0
2018-05-21 15:00:00	AAPL	Stock	46.83	47.07	46.77	46.9025	9501780.0
2018-05-21 16:00:00	AAPL	Stock	46.9075	46.9325	46.8525	46.895	6047484.0
2018-05-21 17:00:00	AAPL	Stock	46.9	46.9125	46.895	46.9075	26980.0
2018-05-21 18:00:00	AAPL	Stock	46.9075	46.9125	46.9	46.9125	14804.0
2018-05-21 19:00:00	AAPL	Stock	46.9	46.92	46.8975	46.8975	17480.0
2018-05-21 04:00:00	MSFT	Stock	97.36	97.36	97.32	97.32	1100.0
2018-05-21 05:00:00	MSFT	Stock	97.5	97.67	97.5	97.67	204.0
2018-05-21 06:00:00	MSFT	Stock	97.49	97.49	97.49	97.49	224.0
2018-05-21 07:00:00	MSFT	Stock	97.15	97.15	96.8	97.12	6578.0
2018-05-21 08:00:00	MSFT	Stock	97.13	97.2	97.0	97.2	10068.0
2018-05-21 09:00:00	MSFT	Stock	97.11	97.8	96.93	97.75	2689370.0
2018-05-21 10:00:00	MSFT	Stock	97.76	98.01	97.42	97.9	2006987.0
2018-05-21 11:00:00	MSFT	Stock	97.9	97.99	96.8	97.29	1817892.0
2018-05-21 12:00:00	MSFT	Stock	97.29	97.64	97.22	97.55	1392326.0
2018-05-21 13:00:00	MSFT	Stock	97.55	97.775	97.51	97.685	1319731.0
2018-05-21 14:00:00	MSFT	Stock	97.68	97.69	97.155	97.47	1355569.0
2018-05-21 15:00:00	MSFT	Stock	97.47	97.67	97.22	97.64	2366106.0
2018-05-21 16:00:00	MSFT	Stock	97.6	97.7	97.54	97.6	4125357.0
2018-05-21 17:00:00	MSFT	Stock	97.6	97.63	97.45	97.45	4993.0
2018-05-21 18:00:00	MSFT	Stock	97.42	97.44	97.42	97.44	1320.0
2018-05-21 19:00:00	MSFT	Stock	97.45	97.45	97.44	97.45	3208.0
2018-05-21 04:00:00	NVDA	Stock	6.2475	6.248	6.2475	6.248	29720.0
2018-05-21 05:00:00	NVDA	Stock	6.2675	6.2675	6.25	6.25	90520.0
2018-05-21 06:00:00	NVDA	Stock	6.2465	6.2498	6.2465	6.2483	28000.0
2018-05-21 07:00:00	NVDA	Stock	6.2375	6.2375	6.2125	6.2288	808360.0
2018-05-21 08:00:00	NVDA	Stock	6.225	6.256	6.2225	6.2495	3634960.0
2018-05-21 09:00:00	NVDA	Stock	6.2448	6.2508	6.1603	6.1942	86461560.0
2018-05-21 10:00:00	NVDA	Stock	6.1945	6.2038	6.121	6.1595	90985480.0
2018-05-21 11:00:00	NVDA	Stock	6.1578	6.1595	6.045	6.0928	75413080.0
2018-05-21 12:00:00	NVDA	Stock	6.0926	6.1088	6.0785	6.0938	36550160.0
2018-05-21 13:00:00	NVDA	Stock	6.0945	6.117	6.088	6.1008	31237120.0
2018-05-21 14:00:00	NVDA	Stock	6.1002	6.101	6.0123	6.0545	77174880.0
2018-05-21 15:00:00	NVDA	Stock	6.0539	6.1083	6.0478	6.1065	94876320.0
2018-05-21 16:00:00	NVDA	Stock	6.1062	6.1112	6.0975	6.1025	3395360.0
2018-05-21 17:00:00	NVDA	Stock	6.1062	6.1145	6.1025	6.1145	2986960.0
2018-05-21 18:00:00	NVDA	Stock	6.1115	6.1175	6.1115	6.1175	383480.0
2018-05-21 19:00:00	NVDA	Stock	6.1175	6.1313	6.1175	6.1313	416600.0
2018-05-21 07:00:00	AMZN	Stock	79.2925	79.395	79.2125	79.395	23400.0
2018-05-21 08:00:00	AMZN	Stock	79.35	79.404	79.3295	79.37	191180.0

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

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