PREVIEW / stock_1hour / 2016-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-16.parquet
  size:    1.0 MB
  rows:    47,982
  symbols: 3,313

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-03-16 04:00:00	AAPL	Stock	26.175	26.175	26.15	26.15	4340.0
2016-03-16 05:00:00	AAPL	Stock	26.165	26.1975	26.165	26.175	7728.0
2016-03-16 06:00:00	AAPL	Stock	26.175	26.215	26.1625	26.21	24268.0
2016-03-16 07:00:00	AAPL	Stock	26.1875	26.195	26.1375	26.1375	37168.0
2016-03-16 08:00:00	AAPL	Stock	26.165	26.2	26.1025	26.1375	215140.0
2016-03-16 09:00:00	AAPL	Stock	26.145	26.3075	26.0875	26.3	16404388.0
2016-03-16 10:00:00	AAPL	Stock	26.3	26.35	26.24	26.3132	17812804.0
2016-03-16 11:00:00	AAPL	Stock	26.3138	26.355	26.3025	26.3445	13784984.0
2016-03-16 12:00:00	AAPL	Stock	26.344	26.445	26.315	26.3678	15792536.0
2016-03-16 13:00:00	AAPL	Stock	26.37	26.3925	26.2525	26.325	11335480.0
2016-03-16 14:00:00	AAPL	Stock	26.325	26.545	26.325	26.48	26868016.0
2016-03-16 15:00:00	AAPL	Stock	26.48	26.5775	26.43	26.4925	29556404.0
2016-03-16 16:00:00	AAPL	Stock	26.4925	26.505	26.125	26.3125	7094368.0
2016-03-16 17:00:00	AAPL	Stock	26.3125	26.4925	26.2825	26.3	186316.0
2016-03-16 18:00:00	AAPL	Stock	26.315	26.3625	26.315	26.35	121648.0
2016-03-16 19:00:00	AAPL	Stock	26.37	26.375	26.35	26.36	72688.0
2016-03-16 05:00:00	MSFT	Stock	53.7	53.74	53.7	53.74	400.0
2016-03-16 06:00:00	MSFT	Stock	53.73	53.73	53.73	53.73	700.0
2016-03-16 07:00:00	MSFT	Stock	53.69	53.69	53.69	53.69	150.0
2016-03-16 08:00:00	MSFT	Stock	53.58	53.7	53.24	53.53	44516.0
2016-03-16 09:00:00	MSFT	Stock	53.53	53.65	53.39	53.57	2101354.0
2016-03-16 10:00:00	MSFT	Stock	53.57	53.829	53.465	53.79	3268903.0
2016-03-16 11:00:00	MSFT	Stock	53.782	54.31	53.755	54.01	3890427.0
2016-03-16 12:00:00	MSFT	Stock	54.011	54.06	53.6	53.68	2194516.0
2016-03-16 13:00:00	MSFT	Stock	53.68	53.88	53.63	53.86	1761046.0
2016-03-16 14:00:00	MSFT	Stock	53.87	54.44	53.86	54.135	4846751.0
2016-03-16 15:00:00	MSFT	Stock	54.135	54.6	54.13	54.35	8394407.0
2016-03-16 16:00:00	MSFT	Stock	54.35	54.42	53.524	54.36	3167364.0
2016-03-16 17:00:00	MSFT	Stock	54.35	54.35	54.34	54.34	149954.0
2016-03-16 18:00:00	MSFT	Stock	54.34	54.55	54.3	54.3	4102.0
2016-03-16 19:00:00	MSFT	Stock	54.35	54.35	54.35	54.35	179.0
2016-03-16 08:00:00	NVDA	Stock	0.8085	0.8085	0.8	0.8	40400.0
2016-03-16 09:00:00	NVDA	Stock	0.7972	0.8113	0.7938	0.809	19777400.0
2016-03-16 10:00:00	NVDA	Stock	0.8088	0.8096	0.802	0.8055	41364680.0
2016-03-16 11:00:00	NVDA	Stock	0.8055	0.8105	0.8036	0.81	24421760.0
2016-03-16 12:00:00	NVDA	Stock	0.8098	0.814	0.8095	0.8108	23285480.0
2016-03-16 13:00:00	NVDA	Stock	0.8105	0.8182	0.8099	0.8181	43374800.0
2016-03-16 14:00:00	NVDA	Stock	0.8182	0.8273	0.8152	0.8248	69594000.0
2016-03-16 15:00:00	NVDA	Stock	0.8248	0.8302	0.8235	0.8278	121399400.0
2016-03-16 16:00:00	NVDA	Stock	0.8275	0.8288	0.8275	0.828	291480.0
2016-03-16 17:00:00	NVDA	Stock	0.828	0.828	0.8225	0.8238	120520.0
2016-03-16 18:00:00	NVDA	Stock	0.8238	0.8238	0.8218	0.8218	39000.0
2016-03-16 07:00:00	AMZN	Stock	28.8	28.8	28.7915	28.7915	23000.0
2016-03-16 08:00:00	AMZN	Stock	28.9	28.9	28.7945	28.8	127660.0
2016-03-16 09:00:00	AMZN	Stock	28.787	28.91	28.6342	28.7865	4436300.0
2016-03-16 10:00:00	AMZN	Stock	28.7855	28.796	28.662	28.7072	5111380.0
2016-03-16 11:00:00	AMZN	Stock	28.701	28.8185	28.675	28.775	3289320.0
2016-03-16 12:00:00	AMZN	Stock	28.775	28.8005	28.5815	28.6465	4201120.0
2016-03-16 13:00:00	AMZN	Stock	28.6385	28.725	28.557	28.725	5110380.0
2016-03-16 14:00:00	AMZN	Stock	28.73	29.0215	28.7025	28.8448	14567820.0

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

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