PREVIEW / stock_1hour / 2017-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-06.parquet
  size:    1.0 MB
  rows:    48,089
  symbols: 2,983

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-09-06 04:00:00	AAPL	Stock	40.605	40.6725	40.605	40.6725	17544.0
2017-09-06 05:00:00	AAPL	Stock	40.6275	40.6275	40.605	40.6175	11644.0
2017-09-06 06:00:00	AAPL	Stock	40.6725	40.6875	40.5625	40.5625	27336.0
2017-09-06 07:00:00	AAPL	Stock	40.5825	40.6475	40.5775	40.625	77864.0
2017-09-06 08:00:00	AAPL	Stock	40.6375	40.675	40.5875	40.6625	320620.0
2017-09-06 09:00:00	AAPL	Stock	40.6625	40.7475	40.5125	40.595	11191664.0
2017-09-06 10:00:00	AAPL	Stock	40.5938	40.645	40.215	40.345	15061124.0
2017-09-06 11:00:00	AAPL	Stock	40.3425	40.345	40.13	40.2975	11425748.0
2017-09-06 12:00:00	AAPL	Stock	40.295	40.495	40.2475	40.4652	7784308.0
2017-09-06 13:00:00	AAPL	Stock	40.4675	40.5425	40.455	40.4738	5540600.0
2017-09-06 14:00:00	AAPL	Stock	40.4725	40.545	40.4075	40.4685	6343900.0
2017-09-06 15:00:00	AAPL	Stock	40.47	40.525	40.445	40.48	11007152.0
2017-09-06 16:00:00	AAPL	Stock	40.4775	40.48	40.3925	40.405	8083020.0
2017-09-06 17:00:00	AAPL	Stock	40.41	40.4775	40.4	40.4175	16260.0
2017-09-06 18:00:00	AAPL	Stock	40.4	40.4125	40.3625	40.39	72036.0
2017-09-06 19:00:00	AAPL	Stock	40.3775	40.4	40.3625	40.375	61320.0
2017-09-06 08:00:00	MSFT	Stock	73.64	73.87	73.64	73.85	918.0
2017-09-06 09:00:00	MSFT	Stock	73.81	74.04	73.605	73.685	2056544.0
2017-09-06 10:00:00	MSFT	Stock	73.685	73.87	73.421	73.63	1695587.0
2017-09-06 11:00:00	MSFT	Stock	73.635	73.788	73.39	73.69	1371885.0
2017-09-06 12:00:00	MSFT	Stock	73.68	73.73	73.6	73.66	1267380.0
2017-09-06 13:00:00	MSFT	Stock	73.66	73.74	73.56	73.59	845272.0
2017-09-06 14:00:00	MSFT	Stock	73.585	73.72	73.52	73.6	1142959.0
2017-09-06 15:00:00	MSFT	Stock	73.61	73.66	73.35	73.4	3344018.0
2017-09-06 16:00:00	MSFT	Stock	73.4	73.5	73.3	73.5	2800619.0
2017-09-06 17:00:00	MSFT	Stock	73.44	73.44	73.4	73.4	2056.0
2017-09-06 18:00:00	MSFT	Stock	73.3	73.3	73.25	73.29	900.0
2017-09-06 06:00:00	NVDA	Stock	4.1615	4.1625	4.1615	4.1625	16000.0
2017-09-06 07:00:00	NVDA	Stock	4.162	4.18	4.162	4.1788	219480.0
2017-09-06 08:00:00	NVDA	Stock	4.175	4.1865	4.17	4.1732	1225240.0
2017-09-06 09:00:00	NVDA	Stock	4.1835	4.195	4.1505	4.1725	66876320.0
2017-09-06 10:00:00	NVDA	Stock	4.1718	4.185	4.1255	4.1355	83963200.0
2017-09-06 11:00:00	NVDA	Stock	4.1346	4.1435	4.11	4.1383	52094600.0
2017-09-06 12:00:00	NVDA	Stock	4.1386	4.1523	4.1343	4.142	30633600.0
2017-09-06 13:00:00	NVDA	Stock	4.1425	4.1507	4.1328	4.1375	28122960.0
2017-09-06 14:00:00	NVDA	Stock	4.1375	4.1612	4.1373	4.1505	39117800.0
2017-09-06 15:00:00	NVDA	Stock	4.1501	4.1678	4.142	4.145	61569320.0
2017-09-06 16:00:00	NVDA	Stock	4.1448	4.1452	4.133	4.133	10141640.0
2017-09-06 17:00:00	NVDA	Stock	4.1428	4.1452	4.1358	4.1428	140400.0
2017-09-06 18:00:00	NVDA	Stock	4.14	4.1428	4.135	4.135	232080.0
2017-09-06 19:00:00	NVDA	Stock	4.1375	4.1412	4.1355	4.1365	189800.0
2017-09-06 07:00:00	AMZN	Stock	48.412	48.435	48.412	48.43	16840.0
2017-09-06 08:00:00	AMZN	Stock	48.43	48.45	48.4125	48.45	40180.0
2017-09-06 09:00:00	AMZN	Stock	48.455	48.592	48.2505	48.372	6360120.0
2017-09-06 10:00:00	AMZN	Stock	48.3715	48.4205	48.055	48.1665	5995140.0
2017-09-06 11:00:00	AMZN	Stock	48.1663	48.2435	48.03	48.19	3131420.0
2017-09-06 12:00:00	AMZN	Stock	48.18	48.3625	48.1151	48.349	3358180.0
2017-09-06 13:00:00	AMZN	Stock	48.354	48.377	48.2418	48.3145	2685160.0
2017-09-06 14:00:00	AMZN	Stock	48.3095	48.505	48.3095	48.4968	3808940.0
2017-09-06 15:00:00	AMZN	Stock	48.505	48.5725	48.366	48.3975	6871900.0

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

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