PREVIEW / stock_1hour / 2016-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-23.parquet
  size:    1.0 MB
  rows:    47,943
  symbols: 3,290

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
2016-05-23 04:00:00	AAPL	Stock	23.875	23.975	23.875	23.9425	28388.0
2016-05-23 05:00:00	AAPL	Stock	23.9675	23.9675	23.915	23.915	8220.0
2016-05-23 06:00:00	AAPL	Stock	23.8875	23.9125	23.855	23.8925	57536.0
2016-05-23 07:00:00	AAPL	Stock	23.88	24.0475	23.8775	24.0175	430564.0
2016-05-23 08:00:00	AAPL	Stock	24.0175	24.025	23.8875	23.95	574552.0
2016-05-23 09:00:00	AAPL	Stock	23.95	24.225	23.9175	24.17	31680040.0
2016-05-23 10:00:00	AAPL	Stock	24.17	24.2975	24.1625	24.24	26283904.0
2016-05-23 11:00:00	AAPL	Stock	24.2375	24.245	24.1325	24.145	14993844.0
2016-05-23 12:00:00	AAPL	Stock	24.1475	24.2175	24.1178	24.2	10592972.0
2016-05-23 13:00:00	AAPL	Stock	24.201	24.2425	24.1675	24.2188	8771880.0
2016-05-23 14:00:00	AAPL	Stock	24.2198	24.2375	24.1375	24.1575	9716084.0
2016-05-23 15:00:00	AAPL	Stock	24.1575	24.175	24.08	24.105	22262632.0
2016-05-23 16:00:00	AAPL	Stock	24.1075	24.2087	24.095	24.1	12964140.0
2016-05-23 17:00:00	AAPL	Stock	24.1	24.1225	24.095	24.1225	90648.0
2016-05-23 18:00:00	AAPL	Stock	24.125	24.135	24.115	24.135	39748.0
2016-05-23 19:00:00	AAPL	Stock	24.135	24.1525	24.125	24.1375	97644.0
2016-05-23 04:00:00	MSFT	Stock	50.45	50.45	50.45	50.45	930.0
2016-05-23 05:00:00	MSFT	Stock	50.51	50.51	50.51	50.51	200.0
2016-05-23 07:00:00	MSFT	Stock	50.61	50.61	50.61	50.61	300.0
2016-05-23 08:00:00	MSFT	Stock	50.62	50.63	50.58	50.58	714.0
2016-05-23 09:00:00	MSFT	Stock	50.53	50.68	50.33	50.47	2643738.0
2016-05-23 10:00:00	MSFT	Stock	50.465	50.55	50.18	50.2	3554365.0
2016-05-23 11:00:00	MSFT	Stock	50.2	50.33	50.17	50.22	2146721.0
2016-05-23 12:00:00	MSFT	Stock	50.22	50.25	50.15	50.18	1993628.0
2016-05-23 13:00:00	MSFT	Stock	50.18	50.25	50.12	50.2	2245048.0
2016-05-23 14:00:00	MSFT	Stock	50.2	50.28	50.18	50.195	2322580.0
2016-05-23 15:00:00	MSFT	Stock	50.195	50.22	49.98	50.03	4559456.0
2016-05-23 16:00:00	MSFT	Stock	50.03	50.03	50.0	50.02	4501422.0
2016-05-23 17:00:00	MSFT	Stock	50.02	50.04	50.02	50.04	3100.0
2016-05-23 18:00:00	MSFT	Stock	50.03	50.08	50.03	50.08	4000.0
2016-05-23 19:00:00	MSFT	Stock	50.08	50.08	50.08	50.08	3588.0
2016-05-23 06:00:00	NVDA	Stock	1.1182	1.1182	1.1062	1.1062	64000.0
2016-05-23 07:00:00	NVDA	Stock	1.1088	1.1172	1.1075	1.108	56000.0
2016-05-23 08:00:00	NVDA	Stock	1.11	1.1132	1.1088	1.1098	236720.0
2016-05-23 09:00:00	NVDA	Stock	1.1098	1.1172	1.1065	1.1065	65838240.0
2016-05-23 10:00:00	NVDA	Stock	1.1066	1.11	1.1032	1.1045	75701680.0
2016-05-23 11:00:00	NVDA	Stock	1.1043	1.109	1.1038	1.1085	43496120.0
2016-05-23 12:00:00	NVDA	Stock	1.1088	1.112	1.1066	1.1115	26469720.0
2016-05-23 13:00:00	NVDA	Stock	1.1112	1.1129	1.1101	1.1115	28694240.0
2016-05-23 14:00:00	NVDA	Stock	1.1112	1.1152	1.1105	1.1138	36248600.0
2016-05-23 15:00:00	NVDA	Stock	1.1138	1.1151	1.1092	1.11	79537800.0
2016-05-23 16:00:00	NVDA	Stock	1.11	1.11	1.1098	1.11	23789320.0
2016-05-23 17:00:00	NVDA	Stock	1.1085	1.1123	1.1085	1.1123	172000.0
2016-05-23 19:00:00	NVDA	Stock	1.1102	1.1102	1.1095	1.1095	16000.0
2016-05-23 07:00:00	AMZN	Stock	35.14	35.275	35.14	35.2535	54980.0
2016-05-23 08:00:00	AMZN	Stock	35.231	35.275	35.1765	35.225	191160.0
2016-05-23 09:00:00	AMZN	Stock	35.2	35.35	34.894	35.0395	12208600.0
2016-05-23 10:00:00	AMZN	Stock	35.0395	35.092	34.875	34.9265	7446360.0
2016-05-23 11:00:00	AMZN	Stock	34.925	34.9938	34.84	34.95	6401320.0
2016-05-23 12:00:00	AMZN	Stock	34.951	34.998	34.87	34.972	3807680.0

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

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