PREVIEW / stock_1hour / 2018-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-15.parquet
  size:    1.1 MB
  rows:    49,653
  symbols: 2,854

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-15 04:00:00	AAPL	Stock	46.86	46.86	46.755	46.755	800.0
2018-05-15 05:00:00	AAPL	Stock	46.795	46.8275	46.795	46.8075	21844.0
2018-05-15 06:00:00	AAPL	Stock	46.8125	46.8275	46.8125	46.8275	6400.0
2018-05-15 07:00:00	AAPL	Stock	46.875	46.9225	46.8	46.85	156944.0
2018-05-15 08:00:00	AAPL	Stock	46.85	47.1375	46.6975	46.745	631792.0
2018-05-15 09:00:00	AAPL	Stock	46.7325	46.7925	46.4075	46.515	14494008.0
2018-05-15 10:00:00	AAPL	Stock	46.5175	46.7675	46.4775	46.525	13136460.0
2018-05-15 11:00:00	AAPL	Stock	46.5225	46.62	46.4425	46.52	8530400.0
2018-05-15 12:00:00	AAPL	Stock	46.5212	46.6025	46.4625	46.51	7541160.0
2018-05-15 13:00:00	AAPL	Stock	46.51	46.525	46.275	46.305	8805128.0
2018-05-15 14:00:00	AAPL	Stock	46.305	46.55	46.28	46.4075	9620880.0
2018-05-15 15:00:00	AAPL	Stock	46.415	46.6175	46.3925	46.61	11648224.0
2018-05-15 16:00:00	AAPL	Stock	46.61	46.61	46.525	46.5825	8940644.0
2018-05-15 17:00:00	AAPL	Stock	46.5875	46.5875	46.55	46.5625	30492.0
2018-05-15 18:00:00	AAPL	Stock	46.5575	46.5575	46.25	46.465	121272.0
2018-05-15 19:00:00	AAPL	Stock	46.475	46.525	46.45	46.45	72828.0
2018-05-15 04:00:00	MSFT	Stock	97.75	97.8	97.75	97.8	300.0
2018-05-15 05:00:00	MSFT	Stock	97.9	97.9	97.9	97.9	108.0
2018-05-15 07:00:00	MSFT	Stock	97.85	98.03	97.51	97.51	3349.0
2018-05-15 08:00:00	MSFT	Stock	97.61	97.9	97.11	97.11	31489.0
2018-05-15 09:00:00	MSFT	Stock	97.19	97.85	96.34	96.46	3849929.0
2018-05-15 10:00:00	MSFT	Stock	96.47	97.436	96.38	96.835	2990787.0
2018-05-15 11:00:00	MSFT	Stock	96.82	97.22	96.68	96.96	2111817.0
2018-05-15 12:00:00	MSFT	Stock	96.96	97.2	96.67	97.006	1762005.0
2018-05-15 13:00:00	MSFT	Stock	97.0	97.08	96.57	96.62	1599504.0
2018-05-15 14:00:00	MSFT	Stock	96.61	97.21	96.51	97.01	2081333.0
2018-05-15 15:00:00	MSFT	Stock	97.005	97.34	96.73	97.32	3827040.0
2018-05-15 16:00:00	MSFT	Stock	97.32	97.32	96.825	97.32	4377310.0
2018-05-15 17:00:00	MSFT	Stock	97.32	97.35	97.23	97.23	4222.0
2018-05-15 18:00:00	MSFT	Stock	97.3	97.3	97.23	97.23	1100.0
2018-05-15 19:00:00	MSFT	Stock	97.27	97.27	97.27	97.27	225.0
2018-05-15 04:00:00	NVDA	Stock	6.375	6.375	6.375	6.375	4000.0
2018-05-15 05:00:00	NVDA	Stock	6.3612	6.3625	6.3612	6.3625	27800.0
2018-05-15 06:00:00	NVDA	Stock	6.3625	6.3625	6.3625	6.3625	79960.0
2018-05-15 07:00:00	NVDA	Stock	6.374	6.3783	6.3338	6.3425	576320.0
2018-05-15 08:00:00	NVDA	Stock	6.3373	6.375	6.3188	6.328	3452200.0
2018-05-15 09:00:00	NVDA	Stock	6.33	6.335	6.1812	6.1878	141824400.0
2018-05-15 10:00:00	NVDA	Stock	6.1885	6.215	6.1332	6.1358	159690840.0
2018-05-15 11:00:00	NVDA	Stock	6.1368	6.158	6.0375	6.095	204748600.0
2018-05-15 12:00:00	NVDA	Stock	6.0975	6.147	6.0788	6.1178	94113000.0
2018-05-15 13:00:00	NVDA	Stock	6.1181	6.125	6.09	6.0932	69821560.0
2018-05-15 14:00:00	NVDA	Stock	6.092	6.1248	6.0905	6.1135	45002960.0
2018-05-15 15:00:00	NVDA	Stock	6.114	6.1472	6.097	6.1378	108927800.0
2018-05-15 16:00:00	NVDA	Stock	6.139	6.14	6.1268	6.1325	21039920.0
2018-05-15 17:00:00	NVDA	Stock	6.1313	6.1348	6.1275	6.132	646800.0
2018-05-15 18:00:00	NVDA	Stock	6.1288	6.1288	6.085	6.088	1276480.0
2018-05-15 19:00:00	NVDA	Stock	6.0925	6.1	6.0908	6.1	657240.0
2018-05-15 06:00:00	AMZN	Stock	80.077	80.077	80.077	80.077	2000.0
2018-05-15 07:00:00	AMZN	Stock	80.012	80.012	79.755	79.8125	41880.0
2018-05-15 08:00:00	AMZN	Stock	80.0005	80.1	79.4175	79.4985	370980.0

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

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