PREVIEW / stock_1hour / 2017-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-17.parquet
  size:    1.0 MB
  rows:    47,736
  symbols: 3,005

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-07-17 04:00:00	AAPL	Stock	37.3	37.3	37.3	37.3	2400.0
2017-07-17 05:00:00	AAPL	Stock	37.275	37.31	37.2625	37.31	7192.0
2017-07-17 06:00:00	AAPL	Stock	37.325	37.3875	37.31	37.375	24280.0
2017-07-17 07:00:00	AAPL	Stock	37.375	37.3825	37.275	37.3225	100912.0
2017-07-17 08:00:00	AAPL	Stock	37.3025	37.4	37.23	37.2575	319116.0
2017-07-17 09:00:00	AAPL	Stock	37.2575	37.675	37.1425	37.653	19024892.0
2017-07-17 10:00:00	AAPL	Stock	37.6552	37.725	37.475	37.4988	17665748.0
2017-07-17 11:00:00	AAPL	Stock	37.5	37.5388	37.385	37.4025	9803624.0
2017-07-17 12:00:00	AAPL	Stock	37.4	37.5325	37.38	37.515	5948204.0
2017-07-17 13:00:00	AAPL	Stock	37.5175	37.5325	37.3975	37.4225	5878800.0
2017-07-17 14:00:00	AAPL	Stock	37.4238	37.4475	37.3575	37.41	6313852.0
2017-07-17 15:00:00	AAPL	Stock	37.415	37.475	37.375	37.4	10420768.0
2017-07-17 16:00:00	AAPL	Stock	37.4	37.4625	37.39	37.4375	7518764.0
2017-07-17 17:00:00	AAPL	Stock	37.435	37.4625	37.425	37.445	63048.0
2017-07-17 18:00:00	AAPL	Stock	37.4375	37.465	37.425	37.465	24612.0
2017-07-17 19:00:00	AAPL	Stock	37.4525	37.4725	37.4375	37.4375	56500.0
2017-07-17 04:00:00	MSFT	Stock	72.98	72.98	72.98	72.98	340.0
2017-07-17 05:00:00	MSFT	Stock	72.89	72.89	72.8	72.8	5837.0
2017-07-17 06:00:00	MSFT	Stock	72.82	72.95	72.82	72.95	300.0
2017-07-17 07:00:00	MSFT	Stock	72.88	73.08	72.88	73.02	2840.0
2017-07-17 08:00:00	MSFT	Stock	73.0	73.13	72.98	73.08	27013.0
2017-07-17 09:00:00	MSFT	Stock	73.07	73.1	72.72	72.84	2495250.0
2017-07-17 10:00:00	MSFT	Stock	72.85	73.23	72.84	72.985	3508450.0
2017-07-17 11:00:00	MSFT	Stock	72.99	73.05	72.84	72.98	2418978.0
2017-07-17 12:00:00	MSFT	Stock	72.979	73.31	72.87	73.255	2498108.0
2017-07-17 13:00:00	MSFT	Stock	73.255	73.3	72.95	73.025	1576143.0
2017-07-17 14:00:00	MSFT	Stock	73.025	73.21	72.99	73.17	1674646.0
2017-07-17 15:00:00	MSFT	Stock	73.17	73.45	73.16	73.35	4087726.0
2017-07-17 16:00:00	MSFT	Stock	73.35	73.58	73.062	73.58	1649312.0
2017-07-17 17:00:00	MSFT	Stock	73.58	73.74	73.58	73.74	18419.0
2017-07-17 18:00:00	MSFT	Stock	73.61	73.71	73.6	73.7	5916.0
2017-07-17 19:00:00	MSFT	Stock	73.72	73.74	73.62	73.72	4425.0
2017-07-17 04:00:00	NVDA	Stock	4.1325	4.1325	4.1085	4.1162	91360.0
2017-07-17 05:00:00	NVDA	Stock	4.1083	4.1138	4.1075	4.1138	59800.0
2017-07-17 06:00:00	NVDA	Stock	4.1148	4.1248	4.1125	4.1212	361080.0
2017-07-17 07:00:00	NVDA	Stock	4.1238	4.1525	4.1238	4.1508	1528080.0
2017-07-17 08:00:00	NVDA	Stock	4.1515	4.1722	4.1125	4.1695	8290240.0
2017-07-17 09:00:00	NVDA	Stock	4.1695	4.1875	4.126	4.1502	185218240.0
2017-07-17 10:00:00	NVDA	Stock	4.1503	4.1523	4.0438	4.082	258357760.0
2017-07-17 11:00:00	NVDA	Stock	4.0825	4.0913	4.0608	4.0852	92319880.0
2017-07-17 12:00:00	NVDA	Stock	4.0854	4.1072	4.0752	4.1002	64368360.0
2017-07-17 13:00:00	NVDA	Stock	4.1	4.1295	4.0968	4.102	76376440.0
2017-07-17 14:00:00	NVDA	Stock	4.1025	4.1128	4.0812	4.1008	74857920.0
2017-07-17 15:00:00	NVDA	Stock	4.1015	4.1228	4.0945	4.1065	93848280.0
2017-07-17 16:00:00	NVDA	Stock	4.1062	4.1438	4.0963	4.1275	19733640.0
2017-07-17 17:00:00	NVDA	Stock	4.1275	4.1288	4.12	4.1225	3259040.0
2017-07-17 18:00:00	NVDA	Stock	4.125	4.1328	4.125	4.1288	1748040.0
2017-07-17 19:00:00	NVDA	Stock	4.1275	4.1315	4.1275	4.1315	630520.0
2017-07-17 04:00:00	AMZN	Stock	50.15	50.15	50.15	50.15	2200.0
2017-07-17 05:00:00	AMZN	Stock	50.1	50.1425	50.069	50.1425	9440.0

> showing 50 of 47,736 rows — these rows as CSV

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