PREVIEW / stock_1hour / 2017-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-11.parquet
  size:    1.1 MB
  rows:    48,817
  symbols: 2,972

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-11 04:00:00	AAPL	Stock	40.1025	40.2225	40.0875	40.2175	68248.0
2017-09-11 05:00:00	AAPL	Stock	40.2175	40.2575	40.2125	40.2575	39980.0
2017-09-11 06:00:00	AAPL	Stock	40.26	40.26	40.1525	40.175	125208.0
2017-09-11 07:00:00	AAPL	Stock	40.175	40.1875	40.115	40.1625	264244.0
2017-09-11 08:00:00	AAPL	Stock	40.165	40.25	40.1	40.1225	572064.0
2017-09-11 09:00:00	AAPL	Stock	40.1225	40.3725	39.9725	40.35	21157232.0
2017-09-11 10:00:00	AAPL	Stock	40.3475	40.5125	40.305	40.335	19627260.0
2017-09-11 11:00:00	AAPL	Stock	40.335	40.405	40.215	40.395	13067244.0
2017-09-11 12:00:00	AAPL	Stock	40.395	40.435	40.3475	40.375	8889360.0
2017-09-11 13:00:00	AAPL	Stock	40.3775	40.405	40.3075	40.3625	7557336.0
2017-09-11 14:00:00	AAPL	Stock	40.365	40.3725	40.1775	40.29	10652768.0
2017-09-11 15:00:00	AAPL	Stock	40.29	40.3865	40.2525	40.3725	17917696.0
2017-09-11 16:00:00	AAPL	Stock	40.37	40.375	40.325	40.3575	12012252.0
2017-09-11 17:00:00	AAPL	Stock	40.3575	40.3875	40.35	40.3675	1358252.0
2017-09-11 18:00:00	AAPL	Stock	40.3675	40.3875	40.365	40.37	78496.0
2017-09-11 19:00:00	AAPL	Stock	40.37	40.4225	40.3675	40.415	86560.0
2017-09-11 04:00:00	MSFT	Stock	74.4	74.4	74.4	74.4	100.0
2017-09-11 05:00:00	MSFT	Stock	74.68	74.68	74.4	74.4	900.0
2017-09-11 06:00:00	MSFT	Stock	74.48	74.48	74.48	74.48	100.0
2017-09-11 07:00:00	MSFT	Stock	74.45	74.45	74.45	74.45	294.0
2017-09-11 08:00:00	MSFT	Stock	74.48	74.49	74.4	74.49	5773.0
2017-09-11 09:00:00	MSFT	Stock	74.45	74.89	74.31	74.829	2257519.0
2017-09-11 10:00:00	MSFT	Stock	74.82	74.945	74.56	74.58	2187673.0
2017-09-11 11:00:00	MSFT	Stock	74.584	74.69	74.555	74.635	1471699.0
2017-09-11 12:00:00	MSFT	Stock	74.635	74.76	74.615	74.69	1547170.0
2017-09-11 13:00:00	MSFT	Stock	74.7	74.76	74.66	74.73	1032265.0
2017-09-11 14:00:00	MSFT	Stock	74.73	74.775	74.6	74.62	1186478.0
2017-09-11 15:00:00	MSFT	Stock	74.625	74.76	74.58	74.74	2669050.0
2017-09-11 16:00:00	MSFT	Stock	74.74	74.76	74.7	74.76	3235084.0
2017-09-11 17:00:00	MSFT	Stock	74.72	74.76	74.68	74.68	437989.0
2017-09-11 18:00:00	MSFT	Stock	74.7	74.78	74.7	74.78	300.0
2017-09-11 19:00:00	MSFT	Stock	74.7	74.77	74.7	74.77	415.0
2017-09-11 04:00:00	NVDA	Stock	4.1153	4.1388	4.1153	4.1388	18800.0
2017-09-11 05:00:00	NVDA	Stock	4.1403	4.1403	4.1375	4.1375	83720.0
2017-09-11 06:00:00	NVDA	Stock	4.1375	4.1448	4.133	4.1443	305160.0
2017-09-11 07:00:00	NVDA	Stock	4.1443	4.1445	4.1338	4.1338	362080.0
2017-09-11 08:00:00	NVDA	Stock	4.1328	4.1438	4.127	4.1305	1177840.0
2017-09-11 09:00:00	NVDA	Stock	4.1288	4.1968	4.1275	4.1921	104481520.0
2017-09-11 10:00:00	NVDA	Stock	4.1928	4.2085	4.1912	4.1972	88764840.0
2017-09-11 11:00:00	NVDA	Stock	4.1972	4.2125	4.1878	4.209	52650480.0
2017-09-11 12:00:00	NVDA	Stock	4.2088	4.2218	4.2062	4.2103	44441840.0
2017-09-11 13:00:00	NVDA	Stock	4.2108	4.233	4.2098	4.2294	56748480.0
2017-09-11 14:00:00	NVDA	Stock	4.2295	4.2358	4.2235	4.2243	57469480.0
2017-09-11 15:00:00	NVDA	Stock	4.224	4.2358	4.2193	4.2232	85437680.0
2017-09-11 16:00:00	NVDA	Stock	4.2215	4.2252	4.2195	4.2195	14641080.0
2017-09-11 17:00:00	NVDA	Stock	4.224	4.225	4.2208	4.2225	1548400.0
2017-09-11 18:00:00	NVDA	Stock	4.2208	4.225	4.2208	4.225	353760.0
2017-09-11 19:00:00	NVDA	Stock	4.2273	4.23	4.227	4.23	471840.0
2017-09-11 04:00:00	AMZN	Stock	48.6515	48.6515	48.6515	48.6515	2000.0
2017-09-11 07:00:00	AMZN	Stock	48.7845	48.836	48.703	48.703	22980.0

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

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