PREVIEW / stock_1hour / 2017-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-04.parquet
  size:    1.0 MB
  rows:    47,022
  symbols: 2,987

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-04 04:00:00	AAPL	Stock	38.925	38.9725	38.925	38.9725	2272.0
2017-08-04 06:00:00	AAPL	Stock	38.9725	38.975	38.945	38.955	11644.0
2017-08-04 07:00:00	AAPL	Stock	38.9375	38.9675	38.93	38.955	25884.0
2017-08-04 08:00:00	AAPL	Stock	38.95	39.0625	38.945	38.9525	297228.0
2017-08-04 09:00:00	AAPL	Stock	38.955	39.35	38.8925	39.1775	16043156.0
2017-08-04 10:00:00	AAPL	Stock	39.1825	39.3125	39.0125	39.1095	17694020.0
2017-08-04 11:00:00	AAPL	Stock	39.1125	39.2325	39.0525	39.1115	8378408.0
2017-08-04 12:00:00	AAPL	Stock	39.115	39.1375	38.9525	39.025	6037460.0
2017-08-04 13:00:00	AAPL	Stock	39.0272	39.0625	38.945	39.0425	5510632.0
2017-08-04 14:00:00	AAPL	Stock	39.0438	39.065	38.9838	39.0025	4365840.0
2017-08-04 15:00:00	AAPL	Stock	39.005	39.105	38.9875	39.085	11532772.0
2017-08-04 16:00:00	AAPL	Stock	39.0975	39.2	39.075	39.1875	5338800.0
2017-08-04 17:00:00	AAPL	Stock	39.18	39.1875	39.1375	39.14	71668.0
2017-08-04 18:00:00	AAPL	Stock	39.145	39.1575	39.1425	39.1475	43444.0
2017-08-04 19:00:00	AAPL	Stock	39.1475	39.1725	39.1475	39.1625	76672.0
2017-08-04 04:00:00	MSFT	Stock	72.18	72.18	72.0	72.0	2244.0
2017-08-04 08:00:00	MSFT	Stock	72.37	72.38	72.21	72.28	2472.0
2017-08-04 09:00:00	MSFT	Stock	72.26	72.77	72.15	72.44	3177279.0
2017-08-04 10:00:00	MSFT	Stock	72.445	72.7	72.24	72.66	2433149.0
2017-08-04 11:00:00	MSFT	Stock	72.656	73.04	72.59	72.975	2297283.0
2017-08-04 12:00:00	MSFT	Stock	72.97	72.975	72.54	72.62	2325690.0
2017-08-04 13:00:00	MSFT	Stock	72.62	72.69	72.49	72.677	2058184.0
2017-08-04 14:00:00	MSFT	Stock	72.67	72.69	72.5	72.53	2074532.0
2017-08-04 15:00:00	MSFT	Stock	72.53	72.7	72.45	72.66	5285109.0
2017-08-04 16:00:00	MSFT	Stock	72.68	72.74	72.59	72.68	1786968.0
2017-08-04 17:00:00	MSFT	Stock	72.65	72.65	72.6	72.6	292.0
2017-08-04 19:00:00	MSFT	Stock	72.65	72.65	72.65	72.65	150.0
2017-08-04 04:00:00	NVDA	Stock	4.1515	4.175	4.1515	4.175	24000.0
2017-08-04 05:00:00	NVDA	Stock	4.175	4.175	4.1735	4.1735	16000.0
2017-08-04 06:00:00	NVDA	Stock	4.17	4.17	4.17	4.17	26200.0
2017-08-04 07:00:00	NVDA	Stock	4.1688	4.174	4.1663	4.174	203160.0
2017-08-04 08:00:00	NVDA	Stock	4.1738	4.1862	4.165	4.1725	1179000.0
2017-08-04 09:00:00	NVDA	Stock	4.1697	4.2209	4.162	4.1938	114222160.0
2017-08-04 10:00:00	NVDA	Stock	4.1928	4.2333	4.1925	4.2331	101283280.0
2017-08-04 11:00:00	NVDA	Stock	4.2333	4.2518	4.2178	4.2298	109991960.0
2017-08-04 12:00:00	NVDA	Stock	4.2299	4.2333	4.1938	4.2035	58008160.0
2017-08-04 13:00:00	NVDA	Stock	4.2032	4.2133	4.188	4.1983	54496200.0
2017-08-04 14:00:00	NVDA	Stock	4.198	4.206	4.1788	4.1818	47192320.0
2017-08-04 15:00:00	NVDA	Stock	4.182	4.1898	4.162	4.1791	76146040.0
2017-08-04 16:00:00	NVDA	Stock	4.1808	4.187	4.175	4.1808	2248320.0
2017-08-04 17:00:00	NVDA	Stock	4.1808	4.1812	4.179	4.1812	255600.0
2017-08-04 18:00:00	NVDA	Stock	4.1812	4.186	4.175	4.1752	401760.0
2017-08-04 19:00:00	NVDA	Stock	4.1825	4.1825	4.1795	4.182	205920.0
2017-08-04 04:00:00	AMZN	Stock	49.4025	49.4025	49.4025	49.4025	5660.0
2017-08-04 05:00:00	AMZN	Stock	49.454	49.454	49.454	49.454	4000.0
2017-08-04 07:00:00	AMZN	Stock	49.4525	49.4525	49.4525	49.4525	2000.0
2017-08-04 08:00:00	AMZN	Stock	49.43	49.55	49.4	49.4	199140.0
2017-08-04 09:00:00	AMZN	Stock	49.4	49.5836	49.1505	49.1575	10158520.0
2017-08-04 10:00:00	AMZN	Stock	49.1585	49.4438	49.1	49.343	9649860.0
2017-08-04 11:00:00	AMZN	Stock	49.3623	49.487	49.3065	49.377	4891880.0

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

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