PREVIEW / stock_1hour / 2017-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-08.parquet
  size:    1.1 MB
  rows:    48,752
  symbols: 2,932

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-08 04:00:00	AAPL	Stock	43.6	43.675	43.6	43.675	1592.0
2017-11-08 05:00:00	AAPL	Stock	43.5925	43.5925	43.55	43.5875	15520.0
2017-11-08 06:00:00	AAPL	Stock	43.5875	43.625	43.575	43.625	18780.0
2017-11-08 07:00:00	AAPL	Stock	43.6125	43.6225	43.5625	43.575	124048.0
2017-11-08 08:00:00	AAPL	Stock	43.6125	43.62	43.575	43.6	197028.0
2017-11-08 09:00:00	AAPL	Stock	43.605	43.7575	43.5825	43.6525	13470792.0
2017-11-08 10:00:00	AAPL	Stock	43.6525	43.845	43.6525	43.81	14323600.0
2017-11-08 11:00:00	AAPL	Stock	43.8125	43.945	43.775	43.8575	9873800.0
2017-11-08 12:00:00	AAPL	Stock	43.858	43.9175	43.83	43.8907	8865000.0
2017-11-08 13:00:00	AAPL	Stock	43.8925	43.9475	43.8725	43.935	7548456.0
2017-11-08 14:00:00	AAPL	Stock	43.9338	44.0075	43.905	43.995	8623856.0
2017-11-08 15:00:00	AAPL	Stock	43.9925	44.06	43.9525	44.06	12487900.0
2017-11-08 16:00:00	AAPL	Stock	44.06	44.1875	43.8858	44.165	10632672.0
2017-11-08 17:00:00	AAPL	Stock	44.1825	44.275	44.145	44.1525	228956.0
2017-11-08 18:00:00	AAPL	Stock	44.145	44.175	44.1375	44.15	43300.0
2017-11-08 19:00:00	AAPL	Stock	44.1575	44.2	44.14	44.1875	85108.0
2017-11-08 04:00:00	MSFT	Stock	84.25	84.25	84.2	84.25	400.0
2017-11-08 05:00:00	MSFT	Stock	84.24	84.24	84.24	84.24	100.0
2017-11-08 08:00:00	MSFT	Stock	84.16	84.18	84.16	84.18	590.0
2017-11-08 09:00:00	MSFT	Stock	84.15	84.35	83.83	83.98	1687854.0
2017-11-08 10:00:00	MSFT	Stock	83.98	84.17	83.91	84.14	1598067.0
2017-11-08 11:00:00	MSFT	Stock	84.13	84.35	84.06	84.13	1412313.0
2017-11-08 12:00:00	MSFT	Stock	84.135	84.215	83.87	84.21	1392014.0
2017-11-08 13:00:00	MSFT	Stock	84.21	84.39	84.2	84.38	1157922.0
2017-11-08 14:00:00	MSFT	Stock	84.379	84.495	84.34	84.455	1247904.0
2017-11-08 15:00:00	MSFT	Stock	84.45	84.61	84.37	84.57	2770986.0
2017-11-08 16:00:00	MSFT	Stock	84.57	84.75	84.339	84.68	5106188.0
2017-11-08 17:00:00	MSFT	Stock	84.68	84.72	84.63	84.63	5353.0
2017-11-08 19:00:00	MSFT	Stock	84.7	84.72	84.68	84.68	1914.0
2017-11-08 05:00:00	NVDA	Stock	5.3008	5.3008	5.3008	5.3008	8000.0
2017-11-08 06:00:00	NVDA	Stock	5.3038	5.307	5.29	5.2975	133040.0
2017-11-08 07:00:00	NVDA	Stock	5.297	5.3	5.2862	5.2862	311360.0
2017-11-08 08:00:00	NVDA	Stock	5.297	5.3112	5.2875	5.31	1850600.0
2017-11-08 09:00:00	NVDA	Stock	5.3075	5.3088	5.2125	5.2282	102340560.0
2017-11-08 10:00:00	NVDA	Stock	5.23	5.2724	5.2205	5.249	83917040.0
2017-11-08 11:00:00	NVDA	Stock	5.2502	5.2613	5.181	5.196	91618920.0
2017-11-08 12:00:00	NVDA	Stock	5.1954	5.2202	5.1952	5.2142	48110920.0
2017-11-08 13:00:00	NVDA	Stock	5.215	5.2231	5.187	5.1991	47904200.0
2017-11-08 14:00:00	NVDA	Stock	5.1992	5.2227	5.1935	5.2222	34064520.0
2017-11-08 15:00:00	NVDA	Stock	5.222	5.2462	5.2145	5.2275	67929040.0
2017-11-08 16:00:00	NVDA	Stock	5.229	5.234	5.2253	5.2288	14610760.0
2017-11-08 17:00:00	NVDA	Stock	5.2265	5.23	5.215	5.215	661280.0
2017-11-08 18:00:00	NVDA	Stock	5.2168	5.2225	5.2155	5.2172	395520.0
2017-11-08 19:00:00	NVDA	Stock	5.2163	5.2163	5.2078	5.2163	550640.0
2017-11-08 05:00:00	AMZN	Stock	56.06	56.06	56.06	56.06	6000.0
2017-11-08 07:00:00	AMZN	Stock	56.145	56.145	56.0915	56.0915	29640.0
2017-11-08 08:00:00	AMZN	Stock	56.1145	56.1145	56.1	56.1	27840.0
2017-11-08 09:00:00	AMZN	Stock	56.1	56.321	55.9555	56.1128	5884120.0
2017-11-08 10:00:00	AMZN	Stock	56.107	56.269	56.089	56.201	4892420.0
2017-11-08 11:00:00	AMZN	Stock	56.2085	56.448	56.1975	56.385	6157700.0

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

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