PREVIEW / stock_1hour / 2017-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-09.parquet
  size:    1.1 MB
  rows:    50,963
  symbols: 2,929

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-11-09 04:00:00	AAPL	Stock	44.075	44.1725	44.075	44.145	9052.0
2017-11-09 05:00:00	AAPL	Stock	44.1125	44.1425	44.1125	44.1425	5576.0
2017-11-09 06:00:00	AAPL	Stock	44.08	44.15	43.95	43.9875	96760.0
2017-11-09 07:00:00	AAPL	Stock	44.0125	44.075	43.875	43.875	258072.0
2017-11-09 08:00:00	AAPL	Stock	43.8925	44.05	43.7275	43.7825	936876.0
2017-11-09 09:00:00	AAPL	Stock	43.8	43.98	43.7	43.8425	16536768.0
2017-11-09 10:00:00	AAPL	Stock	43.845	44.0238	43.795	43.9275	13537476.0
2017-11-09 11:00:00	AAPL	Stock	43.93	43.9358	43.6675	43.7162	12346660.0
2017-11-09 12:00:00	AAPL	Stock	43.71	43.7582	43.285	43.465	20340316.0
2017-11-09 13:00:00	AAPL	Stock	43.4625	43.7075	43.355	43.7025	9178840.0
2017-11-09 14:00:00	AAPL	Stock	43.705	43.85	43.6775	43.825	9144024.0
2017-11-09 15:00:00	AAPL	Stock	43.825	43.98	43.745	43.9675	14373884.0
2017-11-09 16:00:00	AAPL	Stock	43.975	44.0025	43.925	43.9875	5288328.0
2017-11-09 17:00:00	AAPL	Stock	43.995	44.02	43.97	43.9875	142744.0
2017-11-09 18:00:00	AAPL	Stock	43.9875	43.9975	43.9775	43.995	80304.0
2017-11-09 19:00:00	AAPL	Stock	43.995	44.0	43.9525	44.0	119144.0
2017-11-09 04:00:00	MSFT	Stock	84.83	84.83	84.83	84.83	333.0
2017-11-09 07:00:00	MSFT	Stock	84.54	84.54	84.21	84.21	4652.0
2017-11-09 08:00:00	MSFT	Stock	84.31	84.54	84.01	84.08	25571.0
2017-11-09 09:00:00	MSFT	Stock	84.2	84.27	83.47	83.633	2018568.0
2017-11-09 10:00:00	MSFT	Stock	83.64	84.27	83.62	84.03	2535169.0
2017-11-09 11:00:00	MSFT	Stock	84.02	84.025	83.09	83.33	2756699.0
2017-11-09 12:00:00	MSFT	Stock	83.326	83.39	82.9	83.29	2861986.0
2017-11-09 13:00:00	MSFT	Stock	83.3	83.86	83.14	83.624	1899453.0
2017-11-09 14:00:00	MSFT	Stock	83.625	83.91	83.605	83.84	1633626.0
2017-11-09 15:00:00	MSFT	Stock	83.83	84.17	83.73	84.09	3138229.0
2017-11-09 16:00:00	MSFT	Stock	84.1	84.1	84.02	84.07	2037312.0
2017-11-09 17:00:00	MSFT	Stock	84.06	84.09	84.02	84.07	6720.0
2017-11-09 18:00:00	MSFT	Stock	84.07	84.07	84.0	84.0	2124.0
2017-11-09 19:00:00	MSFT	Stock	84.07	84.07	84.06	84.06	220.0
2017-11-09 04:00:00	NVDA	Stock	5.2175	5.2248	5.2175	5.2248	28120.0
2017-11-09 05:00:00	NVDA	Stock	5.2213	5.2213	5.2213	5.2213	13040.0
2017-11-09 06:00:00	NVDA	Stock	5.22	5.22	5.2075	5.2075	13800.0
2017-11-09 07:00:00	NVDA	Stock	5.2	5.2005	5.1625	5.1625	1003800.0
2017-11-09 08:00:00	NVDA	Stock	5.2	5.2038	5.1228	5.137	7108800.0
2017-11-09 09:00:00	NVDA	Stock	5.1375	5.15	5.075	5.0918	133745160.0
2017-11-09 10:00:00	NVDA	Stock	5.0922	5.13	5.0885	5.1198	112103080.0
2017-11-09 11:00:00	NVDA	Stock	5.1202	5.1265	5.079	5.086	77237360.0
2017-11-09 12:00:00	NVDA	Stock	5.0857	5.0928	5.0093	5.0618	143312840.0
2017-11-09 13:00:00	NVDA	Stock	5.0621	5.0828	5.0458	5.0645	57295200.0
2017-11-09 14:00:00	NVDA	Stock	5.0645	5.1012	5.0605	5.0915	61669920.0
2017-11-09 15:00:00	NVDA	Stock	5.0918	5.1583	5.0813	5.129	158476080.0
2017-11-09 16:00:00	NVDA	Stock	5.1315	5.2975	5.0398	5.175	103360600.0
2017-11-09 17:00:00	NVDA	Stock	5.175	5.2715	5.165	5.2308	38282120.0
2017-11-09 18:00:00	NVDA	Stock	5.2388	5.2675	5.2375	5.2638	8716080.0
2017-11-09 19:00:00	NVDA	Stock	5.2625	5.2975	5.258	5.2975	7073840.0
2017-11-09 06:00:00	AMZN	Stock	56.5	56.5	56.4515	56.4515	14000.0
2017-11-09 07:00:00	AMZN	Stock	56.3715	56.413	56.35	56.3535	160900.0
2017-11-09 08:00:00	AMZN	Stock	56.3735	56.375	56.175	56.2995	334440.0
2017-11-09 09:00:00	AMZN	Stock	56.2995	56.4	56.0725	56.253	10256600.0

> showing 50 of 50,963 rows — these rows as CSV

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