PREVIEW / stock_1hour / 2016-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-01.parquet
  size:    1.0 MB
  rows:    48,569
  symbols: 3,270

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-08-01 04:00:00	AAPL	Stock	26.1	26.13	26.1	26.13	6720.0
2016-08-01 05:00:00	AAPL	Stock	26.1325	26.155	26.1325	26.1475	4920.0
2016-08-01 06:00:00	AAPL	Stock	26.1475	26.1475	26.125	26.125	34848.0
2016-08-01 07:00:00	AAPL	Stock	26.125	26.245	26.125	26.225	77248.0
2016-08-01 08:00:00	AAPL	Stock	26.1625	26.2225	26.1275	26.1575	430164.0
2016-08-01 09:00:00	AAPL	Stock	26.16	26.2875	26.1025	26.2612	24654020.0
2016-08-01 10:00:00	AAPL	Stock	26.26	26.375	26.25	26.3575	21593216.0
2016-08-01 11:00:00	AAPL	Stock	26.3575	26.385	26.3275	26.335	14177160.0
2016-08-01 12:00:00	AAPL	Stock	26.3325	26.3375	26.2625	26.2938	15419384.0
2016-08-01 13:00:00	AAPL	Stock	26.295	26.3625	26.2875	26.3525	10665528.0
2016-08-01 14:00:00	AAPL	Stock	26.35	26.4762	26.34	26.475	15398152.0
2016-08-01 15:00:00	AAPL	Stock	26.4725	26.5375	26.42	26.515	30116748.0
2016-08-01 16:00:00	AAPL	Stock	26.5125	26.535	26.151	26.5225	6092532.0
2016-08-01 17:00:00	AAPL	Stock	26.52	26.5325	26.5125	26.5175	145788.0
2016-08-01 18:00:00	AAPL	Stock	26.5175	26.56	26.5175	26.5425	340792.0
2016-08-01 19:00:00	AAPL	Stock	26.55	26.55	26.5325	26.5475	88160.0
2016-08-01 07:00:00	MSFT	Stock	56.8	56.8	56.7	56.7	1176.0
2016-08-01 08:00:00	MSFT	Stock	56.54	56.8	56.54	56.68	3749.0
2016-08-01 09:00:00	MSFT	Stock	56.62	56.76	56.38	56.47	2616664.0
2016-08-01 10:00:00	MSFT	Stock	56.46	56.615	56.43	56.555	3259231.0
2016-08-01 11:00:00	MSFT	Stock	56.55	56.74	56.45	56.455	2518697.0
2016-08-01 12:00:00	MSFT	Stock	56.45	56.455	56.2	56.255	3046476.0
2016-08-01 13:00:00	MSFT	Stock	56.26	56.35	56.14	56.282	2146398.0
2016-08-01 14:00:00	MSFT	Stock	56.285	56.355	56.16	56.355	2659451.0
2016-08-01 15:00:00	MSFT	Stock	56.34	56.59	56.295	56.58	5569144.0
2016-08-01 16:00:00	MSFT	Stock	56.58	56.65	56.43	56.58	1614117.0
2016-08-01 17:00:00	MSFT	Stock	56.58	56.62	56.58	56.62	500.0
2016-08-01 18:00:00	MSFT	Stock	56.53	56.53	56.53	56.53	100.0
2016-08-01 07:00:00	NVDA	Stock	1.4278	1.431	1.4275	1.431	46000.0
2016-08-01 08:00:00	NVDA	Stock	1.4313	1.4345	1.431	1.4315	537520.0
2016-08-01 09:00:00	NVDA	Stock	1.4315	1.4388	1.4213	1.425	44484360.0
2016-08-01 10:00:00	NVDA	Stock	1.4242	1.426	1.4175	1.42	39978000.0
2016-08-01 11:00:00	NVDA	Stock	1.4198	1.424	1.4164	1.4176	28483320.0
2016-08-01 12:00:00	NVDA	Stock	1.4173	1.4178	1.4095	1.4148	32970400.0
2016-08-01 13:00:00	NVDA	Stock	1.4148	1.4165	1.409	1.4131	30040560.0
2016-08-01 14:00:00	NVDA	Stock	1.4131	1.416	1.4108	1.416	23167240.0
2016-08-01 15:00:00	NVDA	Stock	1.416	1.4182	1.4134	1.4182	58613440.0
2016-08-01 16:00:00	NVDA	Stock	1.4182	1.425	1.4182	1.421	5849680.0
2016-08-01 17:00:00	NVDA	Stock	1.4213	1.4288	1.4205	1.4288	313760.0
2016-08-01 18:00:00	NVDA	Stock	1.4285	1.4298	1.4182	1.427	1295360.0
2016-08-01 19:00:00	NVDA	Stock	1.427	1.4283	1.425	1.4283	89400.0
2016-08-01 04:00:00	AMZN	Stock	38.075	38.1	38.074	38.075	18400.0
2016-08-01 05:00:00	AMZN	Stock	38.0455	38.0455	38.043	38.043	7180.0
2016-08-01 06:00:00	AMZN	Stock	38.019	38.019	38.019	38.019	2000.0
2016-08-01 07:00:00	AMZN	Stock	37.9635	38.0	37.9635	38.0	39480.0
2016-08-01 08:00:00	AMZN	Stock	37.985	38.0	37.8815	37.8815	63280.0
2016-08-01 09:00:00	AMZN	Stock	37.88	38.248	37.853	38.175	13086620.0
2016-08-01 10:00:00	AMZN	Stock	38.1535	38.525	38.1365	38.5175	15436220.0
2016-08-01 11:00:00	AMZN	Stock	38.5085	38.525	38.3565	38.4185	6243260.0
2016-08-01 12:00:00	AMZN	Stock	38.403	38.448	38.256	38.4188	7002160.0

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

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