PREVIEW / stock_1hour / 2018-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-01.parquet
  size:    1.1 MB
  rows:    48,394
  symbols: 2,840

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-01 04:00:00	AAPL	Stock	41.55	41.5975	41.495	41.5	21692.0
2018-05-01 06:00:00	AAPL	Stock	41.47	41.5275	41.425	41.475	6000.0
2018-05-01 07:00:00	AAPL	Stock	41.5	41.7525	41.5	41.58	398264.0
2018-05-01 08:00:00	AAPL	Stock	41.7235	41.75	41.55	41.565	513568.0
2018-05-01 09:00:00	AAPL	Stock	41.575	41.7925	41.3175	41.715	19694632.0
2018-05-01 10:00:00	AAPL	Stock	41.7025	42.0325	41.6875	41.7425	27390680.0
2018-05-01 11:00:00	AAPL	Stock	41.7425	41.82	41.625	41.773	14998196.0
2018-05-01 12:00:00	AAPL	Stock	41.7738	42.05	41.7685	41.8925	18814456.0
2018-05-01 13:00:00	AAPL	Stock	41.8925	42.02	41.7325	42.01	12350560.0
2018-05-01 14:00:00	AAPL	Stock	42.0105	42.0335	41.885	41.9838	14433068.0
2018-05-01 15:00:00	AAPL	Stock	41.9825	42.3	41.9525	42.25	36261624.0
2018-05-01 16:00:00	AAPL	Stock	42.275	44.5	41.95	43.8625	31901300.0
2018-05-01 17:00:00	AAPL	Stock	43.87	43.9	42.275	43.75	10008076.0
2018-05-01 18:00:00	AAPL	Stock	43.7275	43.975	43.65	43.7125	2099024.0
2018-05-01 19:00:00	AAPL	Stock	43.6925	43.85	43.6925	43.8225	637460.0
2018-05-01 07:00:00	MSFT	Stock	93.55	93.6	93.25	93.25	7342.0
2018-05-01 08:00:00	MSFT	Stock	93.55	93.62	93.28	93.54	14867.0
2018-05-01 09:00:00	MSFT	Stock	93.54	93.69	92.79	93.64	2731593.0
2018-05-01 10:00:00	MSFT	Stock	93.64	94.22	93.33	93.94	5807665.0
2018-05-01 11:00:00	MSFT	Stock	93.93	94.035	93.45	93.52	3323969.0
2018-05-01 12:00:00	MSFT	Stock	93.515	94.07	93.515	94.01	3256193.0
2018-05-01 13:00:00	MSFT	Stock	94.01	94.539	93.72	94.539	2497174.0
2018-05-01 14:00:00	MSFT	Stock	94.53	94.95	94.485	94.87	2854659.0
2018-05-01 15:00:00	MSFT	Stock	94.87	95.29	94.65	94.98	5716575.0
2018-05-01 16:00:00	MSFT	Stock	94.98	95.5	94.3	95.3	2953356.0
2018-05-01 17:00:00	MSFT	Stock	95.4	95.4	95.03	95.16	25813.0
2018-05-01 18:00:00	MSFT	Stock	95.25	95.32	95.2	95.32	2476.0
2018-05-01 19:00:00	MSFT	Stock	95.32	95.32	95.25	95.3	1214.0
2018-05-01 04:00:00	NVDA	Stock	5.6225	5.6225	5.6075	5.6075	24000.0
2018-05-01 05:00:00	NVDA	Stock	5.6075	5.6075	5.6075	5.6075	4000.0
2018-05-01 06:00:00	NVDA	Stock	5.6	5.6	5.6	5.6	4000.0
2018-05-01 07:00:00	NVDA	Stock	5.6228	5.6228	5.6	5.6125	113400.0
2018-05-01 08:00:00	NVDA	Stock	5.63	5.63	5.6012	5.6158	126200.0
2018-05-01 09:00:00	NVDA	Stock	5.6125	5.6195	5.555	5.6112	33923200.0
2018-05-01 10:00:00	NVDA	Stock	5.609	5.6373	5.5745	5.5975	33526400.0
2018-05-01 11:00:00	NVDA	Stock	5.5978	5.6255	5.5855	5.5963	18487840.0
2018-05-01 12:00:00	NVDA	Stock	5.5958	5.6212	5.587	5.6012	15313280.0
2018-05-01 13:00:00	NVDA	Stock	5.6036	5.6075	5.5703	5.6066	19031720.0
2018-05-01 14:00:00	NVDA	Stock	5.6062	5.6375	5.603	5.6275	25335880.0
2018-05-01 15:00:00	NVDA	Stock	5.6283	5.6812	5.619	5.6775	44416280.0
2018-05-01 16:00:00	NVDA	Stock	5.6785	5.7248	5.66	5.709	8818800.0
2018-05-01 17:00:00	NVDA	Stock	5.705	5.705	5.6763	5.6825	766840.0
2018-05-01 18:00:00	NVDA	Stock	5.6875	5.7093	5.6785	5.7093	538960.0
2018-05-01 19:00:00	NVDA	Stock	5.7098	5.72	5.7075	5.715	412840.0
2018-05-01 07:00:00	AMZN	Stock	78.55	78.7065	78.5	78.5	48640.0
2018-05-01 08:00:00	AMZN	Stock	78.6245	78.6875	78.4665	78.6335	206480.0
2018-05-01 09:00:00	AMZN	Stock	78.5843	78.5843	77.609	78.3415	13376840.0
2018-05-01 10:00:00	AMZN	Stock	78.3125	78.816	78.0185	78.3095	13410980.0
2018-05-01 11:00:00	AMZN	Stock	78.2983	78.536	78.0765	78.1205	6633900.0
2018-05-01 12:00:00	AMZN	Stock	78.1505	78.38	78.081	78.1755	2924480.0

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

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