PREVIEW / stock_1hour / 2016-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-21.parquet
  size:    1.0 MB
  rows:    48,495
  symbols: 3,168

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-12-21 06:00:00	AAPL	Stock	29.2175	29.2175	29.2175	29.2175	400.0
2016-12-21 07:00:00	AAPL	Stock	29.2125	29.2175	29.165	29.1775	18724.0
2016-12-21 08:00:00	AAPL	Stock	29.2125	29.2325	29.1875	29.2275	64912.0
2016-12-21 09:00:00	AAPL	Stock	29.225	29.3375	29.195	29.2762	11622536.0
2016-12-21 10:00:00	AAPL	Stock	29.2758	29.2945	29.205	29.2275	9831164.0
2016-12-21 11:00:00	AAPL	Stock	29.23	29.2775	29.2175	29.2485	7053548.0
2016-12-21 12:00:00	AAPL	Stock	29.2485	29.29	29.242	29.2825	7133856.0
2016-12-21 13:00:00	AAPL	Stock	29.2825	29.31	29.205	29.28	9176340.0
2016-12-21 14:00:00	AAPL	Stock	29.2775	29.35	29.2775	29.31	6967996.0
2016-12-21 15:00:00	AAPL	Stock	29.3125	29.3165	29.2375	29.265	9869632.0
2016-12-21 16:00:00	AAPL	Stock	29.265	29.285	29.255	29.2575	7275736.0
2016-12-21 17:00:00	AAPL	Stock	29.265	29.265	29.2575	29.2625	9636.0
2016-12-21 18:00:00	AAPL	Stock	29.255	29.26	29.255	29.26	8068.0
2016-12-21 19:00:00	AAPL	Stock	29.255	29.265	29.25	29.25	53832.0
2016-12-21 06:00:00	MSFT	Stock	63.2	63.2	63.2	63.2	400.0
2016-12-21 07:00:00	MSFT	Stock	63.49	63.5	63.49	63.5	2300.0
2016-12-21 08:00:00	MSFT	Stock	63.61	63.61	63.3	63.5	5325.0
2016-12-21 09:00:00	MSFT	Stock	63.44	63.7	63.21	63.3	2412525.0
2016-12-21 10:00:00	MSFT	Stock	63.3	63.54	63.24	63.25	2955932.0
2016-12-21 11:00:00	MSFT	Stock	63.255	63.45	63.12	63.42	2424288.0
2016-12-21 12:00:00	MSFT	Stock	63.425	63.54	63.41	63.52	1197772.0
2016-12-21 13:00:00	MSFT	Stock	63.51	63.57	63.47	63.49	1280104.0
2016-12-21 14:00:00	MSFT	Stock	63.48	63.56	63.41	63.555	1543442.0
2016-12-21 15:00:00	MSFT	Stock	63.555	63.62	63.48	63.55	2267960.0
2016-12-21 16:00:00	MSFT	Stock	63.54	63.64	63.48	63.48	1723905.0
2016-12-21 17:00:00	MSFT	Stock	63.5	63.61	63.5	63.54	12680.0
2016-12-21 18:00:00	MSFT	Stock	63.55	63.62	63.55	63.57	2529.0
2016-12-21 19:00:00	MSFT	Stock	63.57	63.6	63.57	63.59	1171.0
2016-12-21 04:00:00	NVDA	Stock	2.6375	2.6375	2.6375	2.6375	8000.0
2016-12-21 05:00:00	NVDA	Stock	2.6402	2.6402	2.64	2.64	40000.0
2016-12-21 06:00:00	NVDA	Stock	2.6402	2.6402	2.635	2.635	40000.0
2016-12-21 07:00:00	NVDA	Stock	2.63	2.636	2.6255	2.636	175400.0
2016-12-21 08:00:00	NVDA	Stock	2.63	2.6425	2.63	2.642	1279960.0
2016-12-21 09:00:00	NVDA	Stock	2.6418	2.6488	2.5958	2.6	115959480.0
2016-12-21 10:00:00	NVDA	Stock	2.5996	2.629	2.5928	2.617	123184080.0
2016-12-21 11:00:00	NVDA	Stock	2.6168	2.6468	2.6145	2.6413	83270080.0
2016-12-21 12:00:00	NVDA	Stock	2.6414	2.6488	2.638	2.645	45922000.0
2016-12-21 13:00:00	NVDA	Stock	2.6453	2.6476	2.6348	2.6391	42992440.0
2016-12-21 14:00:00	NVDA	Stock	2.639	2.6478	2.6383	2.6438	54898040.0
2016-12-21 15:00:00	NVDA	Stock	2.6435	2.6478	2.632	2.6458	76991760.0
2016-12-21 16:00:00	NVDA	Stock	2.6455	2.65	2.6413	2.65	7972080.0
2016-12-21 17:00:00	NVDA	Stock	2.6463	2.65	2.6458	2.65	183400.0
2016-12-21 18:00:00	NVDA	Stock	2.65	2.65	2.6493	2.65	150000.0
2016-12-21 19:00:00	NVDA	Stock	2.6508	2.6545	2.65	2.6512	171120.0
2016-12-21 05:00:00	AMZN	Stock	38.594	38.594	38.594	38.594	2000.0
2016-12-21 08:00:00	AMZN	Stock	38.6	38.6	38.379	38.379	124820.0
2016-12-21 09:00:00	AMZN	Stock	38.4185	38.5175	38.3065	38.416	6835220.0
2016-12-21 10:00:00	AMZN	Stock	38.401	38.4395	38.285	38.3333	7245200.0
2016-12-21 11:00:00	AMZN	Stock	38.3425	38.362	38.285	38.3495	4219080.0
2016-12-21 12:00:00	AMZN	Stock	38.346	38.4225	38.319	38.3905	3308900.0

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

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