PREVIEW / stock_1hour / 2018-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-03.parquet
  size:    1.1 MB
  rows:    49,827
  symbols: 2,794

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-10-03 04:00:00	AAPL	Stock	57.5	57.6125	57.5	57.6125	5864.0
2018-10-03 05:00:00	AAPL	Stock	57.59	57.5925	57.5	57.55	16832.0
2018-10-03 06:00:00	AAPL	Stock	57.575	57.575	57.5325	57.55	13248.0
2018-10-03 07:00:00	AAPL	Stock	57.525	57.5975	57.4625	57.55	106212.0
2018-10-03 08:00:00	AAPL	Stock	57.5	57.65	57.4625	57.61	386348.0
2018-10-03 09:00:00	AAPL	Stock	57.61	58.0825	57.445	57.9712	16629612.0
2018-10-03 10:00:00	AAPL	Stock	57.975	58.3675	57.9575	58.1325	20533736.0
2018-10-03 11:00:00	AAPL	Stock	58.1325	58.325	57.9375	58.1825	15740216.0
2018-10-03 12:00:00	AAPL	Stock	58.185	58.21	58.0125	58.1725	6561228.0
2018-10-03 13:00:00	AAPL	Stock	58.17	58.235	58.12	58.1275	4922440.0
2018-10-03 14:00:00	AAPL	Stock	58.1275	58.22	57.94	58.0975	8914696.0
2018-10-03 15:00:00	AAPL	Stock	58.0975	58.1375	57.8928	58.025	13580480.0
2018-10-03 16:00:00	AAPL	Stock	58.0175	58.035	57.9375	57.975	9769548.0
2018-10-03 17:00:00	AAPL	Stock	57.975	57.975	57.9375	57.9625	50836.0
2018-10-03 18:00:00	AAPL	Stock	57.9375	57.9875	57.8975	57.975	123852.0
2018-10-03 19:00:00	AAPL	Stock	57.93	57.9625	57.905	57.93	57492.0
2018-10-03 04:00:00	MSFT	Stock	115.5	115.5	115.5	115.5	420.0
2018-10-03 06:00:00	MSFT	Stock	115.37	115.37	115.36	115.37	2054.0
2018-10-03 07:00:00	MSFT	Stock	115.48	115.53	115.26	115.53	4272.0
2018-10-03 08:00:00	MSFT	Stock	115.406	115.65	115.35	115.64	13172.0
2018-10-03 09:00:00	MSFT	Stock	115.59	115.9	115.41	115.89	1882238.0
2018-10-03 10:00:00	MSFT	Stock	115.9	116.18	115.64	115.71	2333540.0
2018-10-03 11:00:00	MSFT	Stock	115.7	116.03	115.52	115.813	1736460.0
2018-10-03 12:00:00	MSFT	Stock	115.82	115.83	115.405	115.507	1119993.0
2018-10-03 13:00:00	MSFT	Stock	115.5	115.74	115.43	115.5	826515.0
2018-10-03 14:00:00	MSFT	Stock	115.506	115.63	115.14	115.22	1517794.0
2018-10-03 15:00:00	MSFT	Stock	115.22	115.38	114.93	115.16	3183708.0
2018-10-03 16:00:00	MSFT	Stock	115.17	115.7	114.91	114.91	1618735.0
2018-10-03 17:00:00	MSFT	Stock	114.873	115.11	114.867	115.11	3787.0
2018-10-03 18:00:00	MSFT	Stock	114.99	115.0	114.9	114.9	3622.0
2018-10-03 19:00:00	MSFT	Stock	114.91	115.0	114.81	114.9	5063.0
2018-10-03 06:00:00	NVDA	Stock	7.187	7.187	7.187	7.187	4000.0
2018-10-03 07:00:00	NVDA	Stock	7.1725	7.2125	7.1725	7.2098	176000.0
2018-10-03 08:00:00	NVDA	Stock	7.1875	7.2348	7.1875	7.225	1589000.0
2018-10-03 09:00:00	NVDA	Stock	7.2275	7.2405	7.0632	7.1008	54063320.0
2018-10-03 10:00:00	NVDA	Stock	7.0978	7.1521	7.0978	7.1085	32755840.0
2018-10-03 11:00:00	NVDA	Stock	7.1084	7.1825	7.0933	7.1805	25217360.0
2018-10-03 12:00:00	NVDA	Stock	7.1808	7.2125	7.1658	7.2085	25316120.0
2018-10-03 13:00:00	NVDA	Stock	7.2084	7.2297	7.1902	7.1972	20498080.0
2018-10-03 14:00:00	NVDA	Stock	7.197	7.2168	7.1463	7.1598	21752360.0
2018-10-03 15:00:00	NVDA	Stock	7.16	7.175	7.1335	7.1682	41123040.0
2018-10-03 16:00:00	NVDA	Stock	7.1682	7.1682	7.1183	7.15	1930840.0
2018-10-03 17:00:00	NVDA	Stock	7.1518	7.1588	7.1502	7.1525	582400.0
2018-10-03 18:00:00	NVDA	Stock	7.156	7.156	7.15	7.1528	36640.0
2018-10-03 19:00:00	NVDA	Stock	7.15	7.1525	7.142	7.1525	141760.0
2018-10-03 06:00:00	AMZN	Stock	99.18	99.18	99.18	99.18	6160.0
2018-10-03 07:00:00	AMZN	Stock	98.9685	99.2225	98.955	99.1055	169340.0
2018-10-03 08:00:00	AMZN	Stock	99.0675	99.3495	99.05	99.225	647600.0
2018-10-03 09:00:00	AMZN	Stock	99.225	99.485	98.7285	99.0728	17417280.0
2018-10-03 10:00:00	AMZN	Stock	99.1	99.3955	98.1215	98.2455	18375200.0

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

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