PREVIEW / stock_1hour / 2018-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-04.parquet
  size:    1.1 MB
  rows:    49,906
  symbols: 2,754

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-12-04 04:00:00	AAPL	Stock	45.4625	45.535	45.27	45.2775	31424.0
2018-12-04 05:00:00	AAPL	Stock	45.3375	45.5	45.32	45.4875	14184.0
2018-12-04 06:00:00	AAPL	Stock	45.4575	45.57	45.4125	45.4125	36328.0
2018-12-04 07:00:00	AAPL	Stock	45.38	45.4375	45.2625	45.325	309760.0
2018-12-04 08:00:00	AAPL	Stock	45.3875	45.4425	45.175	45.365	940076.0
2018-12-04 09:00:00	AAPL	Stock	45.36	45.5	45.1375	45.3275	16549084.0
2018-12-04 10:00:00	AAPL	Stock	45.325	45.5975	45.255	45.3475	15483660.0
2018-12-04 11:00:00	AAPL	Stock	45.3425	45.45	45.1025	45.1275	13450076.0
2018-12-04 12:00:00	AAPL	Stock	45.125	45.1568	44.3475	44.4375	23304412.0
2018-12-04 13:00:00	AAPL	Stock	44.4325	44.5568	44.11	44.3875	16938412.0
2018-12-04 14:00:00	AAPL	Stock	44.3825	44.57	44.2775	44.3975	13406368.0
2018-12-04 15:00:00	AAPL	Stock	44.3875	44.435	44.0675	44.1775	27164936.0
2018-12-04 16:00:00	AAPL	Stock	44.1775	44.23	44.075	44.1225	16760820.0
2018-12-04 17:00:00	AAPL	Stock	44.1225	44.1225	43.9625	43.9675	182448.0
2018-12-04 18:00:00	AAPL	Stock	44.0	44.1225	43.9925	44.0975	126072.0
2018-12-04 19:00:00	AAPL	Stock	44.1	44.2175	44.0625	44.125	291876.0
2018-12-04 04:00:00	MSFT	Stock	111.4	111.4	111.02	111.02	658.0
2018-12-04 05:00:00	MSFT	Stock	111.5	111.5	111.5	111.5	100.0
2018-12-04 07:00:00	MSFT	Stock	111.46	111.76	111.32	111.76	6973.0
2018-12-04 08:00:00	MSFT	Stock	111.32	111.98	111.32	111.98	20238.0
2018-12-04 09:00:00	MSFT	Stock	111.87	112.11	111.2	112.024	3080071.0
2018-12-04 10:00:00	MSFT	Stock	112.03	112.637	111.98	112.2	3886792.0
2018-12-04 11:00:00	MSFT	Stock	112.19	112.395	111.62	111.675	2751180.0
2018-12-04 12:00:00	MSFT	Stock	111.67	111.67	109.51	110.0	5404932.0
2018-12-04 13:00:00	MSFT	Stock	110.0	110.19	108.61	109.715	4619311.0
2018-12-04 14:00:00	MSFT	Stock	109.715	110.2	109.35	109.76	4155686.0
2018-12-04 15:00:00	MSFT	Stock	109.76	109.778	108.212	108.52	8121109.0
2018-12-04 16:00:00	MSFT	Stock	108.34	109.0	108.34	108.7	7777045.0
2018-12-04 17:00:00	MSFT	Stock	108.65	108.691	108.5	108.58	7572.0
2018-12-04 18:00:00	MSFT	Stock	108.66	108.85	108.42	108.85	14796.0
2018-12-04 19:00:00	MSFT	Stock	108.9	109.55	108.88	108.88	15037.0
2018-12-04 04:00:00	NVDA	Stock	4.2	4.201	4.2	4.201	27680.0
2018-12-04 05:00:00	NVDA	Stock	4.1882	4.2125	4.1875	4.2125	27600.0
2018-12-04 07:00:00	NVDA	Stock	4.222	4.2268	4.199	4.2013	403360.0
2018-12-04 08:00:00	NVDA	Stock	4.2163	4.2275	4.1968	4.2182	1377080.0
2018-12-04 09:00:00	NVDA	Stock	4.215	4.215	4.0985	4.1192	92663280.0
2018-12-04 10:00:00	NVDA	Stock	4.122	4.17	4.1138	4.1368	95123520.0
2018-12-04 11:00:00	NVDA	Stock	4.137	4.1425	4.0878	4.109	63225520.0
2018-12-04 12:00:00	NVDA	Stock	4.1085	4.1112	4.004	4.0242	89380320.0
2018-12-04 13:00:00	NVDA	Stock	4.0232	4.0348	3.9623	3.9998	77508320.0
2018-12-04 14:00:00	NVDA	Stock	3.9975	4.0518	3.9878	3.993	80332080.0
2018-12-04 15:00:00	NVDA	Stock	3.9924	3.993	3.9125	3.929	182798800.0
2018-12-04 16:00:00	NVDA	Stock	3.9286	3.9378	3.9225	3.9325	49335080.0
2018-12-04 17:00:00	NVDA	Stock	3.9343	3.9375	3.9202	3.925	874200.0
2018-12-04 18:00:00	NVDA	Stock	3.9263	3.945	3.9263	3.9352	660240.0
2018-12-04 19:00:00	NVDA	Stock	3.945	3.9688	3.9378	3.9555	998760.0
2018-12-04 04:00:00	AMZN	Stock	87.5	87.5	87.5	87.5	6120.0
2018-12-04 06:00:00	AMZN	Stock	87.75	87.75	87.75	87.75	2000.0
2018-12-04 07:00:00	AMZN	Stock	87.6725	88.1745	87.655	88.05	113640.0
2018-12-04 08:00:00	AMZN	Stock	87.95	88.8	87.8328	88.15	574540.0

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

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