PREVIEW / stock_1hour / 2017-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-01.parquet
  size:    1.1 MB
  rows:    48,070
  symbols: 2,995

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
2017-08-01 04:00:00	AAPL	Stock	37.2625	37.3225	37.1875	37.3225	22344.0
2017-08-01 05:00:00	AAPL	Stock	37.325	37.3525	37.325	37.33	16988.0
2017-08-01 06:00:00	AAPL	Stock	37.3275	37.3275	37.2875	37.3025	52060.0
2017-08-01 07:00:00	AAPL	Stock	37.3125	37.3125	37.2125	37.275	95084.0
2017-08-01 08:00:00	AAPL	Stock	37.3225	37.3225	37.1825	37.27	366836.0
2017-08-01 09:00:00	AAPL	Stock	37.275	37.355	37.1675	37.2025	11188856.0
2017-08-01 10:00:00	AAPL	Stock	37.1975	37.33	37.15	37.31	13422072.0
2017-08-01 11:00:00	AAPL	Stock	37.31	37.3125	37.1025	37.2418	10305008.0
2017-08-01 12:00:00	AAPL	Stock	37.241	37.2625	37.175	37.2625	6543128.0
2017-08-01 13:00:00	AAPL	Stock	37.2612	37.295	37.2275	37.2575	6979144.0
2017-08-01 14:00:00	AAPL	Stock	37.2562	37.3375	37.2475	37.335	9683508.0
2017-08-01 15:00:00	AAPL	Stock	37.335	37.555	37.2425	37.5125	26237112.0
2017-08-01 16:00:00	AAPL	Stock	37.5125	39.6925	37.3375	39.45	28797056.0
2017-08-01 17:00:00	AAPL	Stock	39.455	39.975	39.4525	39.9	11216096.0
2017-08-01 18:00:00	AAPL	Stock	39.895	39.96	39.75	39.7825	1971308.0
2017-08-01 19:00:00	AAPL	Stock	39.7875	39.9	39.755	39.875	1216196.0
2017-08-01 04:00:00	MSFT	Stock	72.99	72.99	72.99	72.99	200.0
2017-08-01 06:00:00	MSFT	Stock	72.9	72.9	72.9	72.9	1500.0
2017-08-01 07:00:00	MSFT	Stock	72.9	72.95	72.9	72.95	4999.0
2017-08-01 08:00:00	MSFT	Stock	72.81	72.95	72.7	72.7	5129.0
2017-08-01 09:00:00	MSFT	Stock	73.0	73.42	72.88	73.03	2348604.0
2017-08-01 10:00:00	MSFT	Stock	73.02	73.05	72.78	72.98	2914835.0
2017-08-01 11:00:00	MSFT	Stock	72.971	73.0	72.76	72.84	1934296.0
2017-08-01 12:00:00	MSFT	Stock	72.84	72.88	72.72	72.725	1566259.0
2017-08-01 13:00:00	MSFT	Stock	72.725	72.82	72.71	72.795	1884925.0
2017-08-01 14:00:00	MSFT	Stock	72.797	72.81	72.635	72.695	1455575.0
2017-08-01 15:00:00	MSFT	Stock	72.69	72.719	72.49	72.55	3853968.0
2017-08-01 16:00:00	MSFT	Stock	72.58	72.8	72.58	72.8	3206546.0
2017-08-01 17:00:00	MSFT	Stock	72.8	72.88	72.72	72.85	21372.0
2017-08-01 18:00:00	MSFT	Stock	72.8	72.8	72.65	72.8	3296.0
2017-08-01 19:00:00	MSFT	Stock	72.72	72.75	72.58	72.74	7077.0
2017-08-01 04:00:00	NVDA	Stock	4.075	4.075	4.0625	4.075	72680.0
2017-08-01 05:00:00	NVDA	Stock	4.075	4.075	4.075	4.075	14800.0
2017-08-01 06:00:00	NVDA	Stock	4.0745	4.0745	4.0575	4.0575	164280.0
2017-08-01 07:00:00	NVDA	Stock	4.0525	4.0658	4.0525	4.0595	227960.0
2017-08-01 08:00:00	NVDA	Stock	4.0568	4.075	4.0502	4.0612	1005360.0
2017-08-01 09:00:00	NVDA	Stock	4.0612	4.0883	4.025	4.0833	86378240.0
2017-08-01 10:00:00	NVDA	Stock	4.0838	4.106	4.0632	4.0945	93647760.0
2017-08-01 11:00:00	NVDA	Stock	4.094	4.1123	4.0835	4.1098	50216480.0
2017-08-01 12:00:00	NVDA	Stock	4.1098	4.1123	4.0803	4.1015	35260720.0
2017-08-01 13:00:00	NVDA	Stock	4.1008	4.114	4.098	4.1094	29937320.0
2017-08-01 14:00:00	NVDA	Stock	4.1092	4.1125	4.0978	4.098	25712080.0
2017-08-01 15:00:00	NVDA	Stock	4.098	4.1138	4.088	4.1121	45458840.0
2017-08-01 16:00:00	NVDA	Stock	4.1123	4.1325	4.104	4.1325	21628440.0
2017-08-01 17:00:00	NVDA	Stock	4.1325	4.1482	4.1325	4.1425	1571640.0
2017-08-01 18:00:00	NVDA	Stock	4.1438	4.1475	4.14	4.1405	561200.0
2017-08-01 19:00:00	NVDA	Stock	4.142	4.1495	4.142	4.1495	287480.0
2017-08-01 04:00:00	AMZN	Stock	49.75	49.75	49.705	49.705	6000.0
2017-08-01 05:00:00	AMZN	Stock	49.655	49.7295	49.655	49.665	14320.0
2017-08-01 06:00:00	AMZN	Stock	49.675	49.675	49.5875	49.5875	17660.0

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

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