PREVIEW / stock_1hour / 2018-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-26.parquet
  size:    1.1 MB
  rows:    49,560
  symbols: 2,789

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-09-26 04:00:00	AAPL	Stock	55.675	55.745	55.675	55.7375	4672.0
2018-09-26 05:00:00	AAPL	Stock	55.6625	55.665	55.6625	55.665	2000.0
2018-09-26 06:00:00	AAPL	Stock	55.7375	55.7475	55.495	55.495	26608.0
2018-09-26 07:00:00	AAPL	Stock	55.4975	55.5725	55.4125	55.455	143064.0
2018-09-26 08:00:00	AAPL	Stock	55.5625	55.59	55.4325	55.5375	327180.0
2018-09-26 09:00:00	AAPL	Stock	55.55	55.81	55.25	55.775	11673472.0
2018-09-26 10:00:00	AAPL	Stock	55.7775	55.9375	55.5975	55.7	11986784.0
2018-09-26 11:00:00	AAPL	Stock	55.7	55.8125	55.635	55.7112	5640496.0
2018-09-26 12:00:00	AAPL	Stock	55.71	55.7125	55.4925	55.5938	5300472.0
2018-09-26 13:00:00	AAPL	Stock	55.5925	55.6	55.415	55.495	4857940.0
2018-09-26 14:00:00	AAPL	Stock	55.49	55.7725	55.47	55.5708	9522408.0
2018-09-26 15:00:00	AAPL	Stock	55.5725	55.635	54.94	55.1275	19836260.0
2018-09-26 16:00:00	AAPL	Stock	55.1425	55.1525	55.03	55.1375	12188340.0
2018-09-26 17:00:00	AAPL	Stock	55.125	55.15	55.1125	55.1425	41504.0
2018-09-26 18:00:00	AAPL	Stock	55.14	55.175	55.11	55.1625	79264.0
2018-09-26 19:00:00	AAPL	Stock	55.1875	55.225	55.175	55.1925	46620.0
2018-09-26 07:00:00	MSFT	Stock	114.88	114.9	114.71	114.83	4801.0
2018-09-26 08:00:00	MSFT	Stock	114.9	114.9	114.51	114.7	16370.0
2018-09-26 09:00:00	MSFT	Stock	114.69	114.81	113.939	114.52	2031600.0
2018-09-26 10:00:00	MSFT	Stock	114.52	114.71	114.135	114.5	1879069.0
2018-09-26 11:00:00	MSFT	Stock	114.5	114.77	114.46	114.715	1245830.0
2018-09-26 12:00:00	MSFT	Stock	114.72	114.79	114.505	114.655	927661.0
2018-09-26 13:00:00	MSFT	Stock	114.657	114.82	114.48	114.59	800573.0
2018-09-26 14:00:00	MSFT	Stock	114.58	115.055	114.51	114.77	2627568.0
2018-09-26 15:00:00	MSFT	Stock	114.78	114.87	113.74	114.13	4667507.0
2018-09-26 16:00:00	MSFT	Stock	114.13	114.17	113.89	113.96	3583150.0
2018-09-26 17:00:00	MSFT	Stock	113.96	114.116	113.916	114.0	1763.0
2018-09-26 18:00:00	MSFT	Stock	114.0	114.12	114.0	114.12	1197.0
2018-09-26 19:00:00	MSFT	Stock	114.12	114.39	114.05	114.39	2966.0
2018-09-26 07:00:00	NVDA	Stock	6.7132	6.7138	6.7075	6.7125	147000.0
2018-09-26 08:00:00	NVDA	Stock	6.725	6.735	6.6963	6.7038	281760.0
2018-09-26 09:00:00	NVDA	Stock	6.7	6.756	6.695	6.7345	36837320.0
2018-09-26 10:00:00	NVDA	Stock	6.7348	6.7373	6.6728	6.6875	34190160.0
2018-09-26 11:00:00	NVDA	Stock	6.6862	6.698	6.6592	6.6915	30206400.0
2018-09-26 12:00:00	NVDA	Stock	6.691	6.6951	6.6725	6.6885	13955800.0
2018-09-26 13:00:00	NVDA	Stock	6.689	6.7038	6.667	6.6785	16106600.0
2018-09-26 14:00:00	NVDA	Stock	6.6759	6.709	6.6735	6.6865	26585080.0
2018-09-26 15:00:00	NVDA	Stock	6.6855	6.7165	6.657	6.673	46184160.0
2018-09-26 16:00:00	NVDA	Stock	6.673	6.6838	6.6725	6.6812	14713240.0
2018-09-26 17:00:00	NVDA	Stock	6.685	6.6862	6.685	6.6862	15400.0
2018-09-26 18:00:00	NVDA	Stock	6.6862	6.7	6.6862	6.7	167520.0
2018-09-26 19:00:00	NVDA	Stock	6.7	6.7075	6.6988	6.6988	126320.0
2018-09-26 04:00:00	AMZN	Stock	99.2185	99.2185	99.2185	99.2185	3300.0
2018-09-26 05:00:00	AMZN	Stock	99.1	99.1	99.1	99.1	4000.0
2018-09-26 06:00:00	AMZN	Stock	99.1	99.1	99.1	99.1	9680.0
2018-09-26 07:00:00	AMZN	Stock	99.1	99.1	98.8105	98.887	94300.0
2018-09-26 08:00:00	AMZN	Stock	99.1498	99.1498	98.752	98.8045	306780.0
2018-09-26 09:00:00	AMZN	Stock	98.82	98.825	98.076	98.626	8768880.0
2018-09-26 10:00:00	AMZN	Stock	98.6223	98.8458	98.3	98.816	5979560.0
2018-09-26 11:00:00	AMZN	Stock	98.8391	99.602	98.827	99.4122	7704280.0

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

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