PREVIEW / stock_1hour / 2017-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-23.parquet
  size:    1.0 MB
  rows:    47,681
  symbols: 3,044

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-05-23 04:00:00	AAPL	Stock	38.5075	38.575	38.5	38.5	8688.0
2017-05-23 05:00:00	AAPL	Stock	38.595	38.6	38.595	38.6	2800.0
2017-05-23 06:00:00	AAPL	Stock	38.5375	38.575	38.5375	38.575	16628.0
2017-05-23 07:00:00	AAPL	Stock	38.5825	38.7	38.5825	38.65	73404.0
2017-05-23 08:00:00	AAPL	Stock	38.65	38.725	38.625	38.6975	272408.0
2017-05-23 09:00:00	AAPL	Stock	38.6975	38.7475	38.445	38.465	13882020.0
2017-05-23 10:00:00	AAPL	Stock	38.465	38.5775	38.4325	38.4975	12122924.0
2017-05-23 11:00:00	AAPL	Stock	38.495	38.545	38.4625	38.4812	6959684.0
2017-05-23 12:00:00	AAPL	Stock	38.4825	38.4912	38.3275	38.3862	9903696.0
2017-05-23 13:00:00	AAPL	Stock	38.385	38.4425	38.3425	38.3778	8115524.0
2017-05-23 14:00:00	AAPL	Stock	38.379	38.4288	38.345	38.3715	6250632.0
2017-05-23 15:00:00	AAPL	Stock	38.37	38.45	38.3625	38.45	9142020.0
2017-05-23 16:00:00	AAPL	Stock	38.445	38.4675	38.3825	38.43	5467268.0
2017-05-23 17:00:00	AAPL	Stock	38.4325	38.455	38.43	38.43	15008.0
2017-05-23 18:00:00	AAPL	Stock	38.43	38.4425	38.425	38.425	13924.0
2017-05-23 19:00:00	AAPL	Stock	38.425	38.4425	38.4175	38.4225	20296.0
2017-05-23 05:00:00	MSFT	Stock	68.51	68.51	68.51	68.51	151.0
2017-05-23 06:00:00	MSFT	Stock	68.5	68.5	68.5	68.5	249.0
2017-05-23 07:00:00	MSFT	Stock	68.59	68.59	68.59	68.59	150.0
2017-05-23 08:00:00	MSFT	Stock	68.5	68.58	68.5	68.55	5054.0
2017-05-23 09:00:00	MSFT	Stock	68.59	68.9	68.43	68.495	1799449.0
2017-05-23 10:00:00	MSFT	Stock	68.495	68.62	68.38	68.525	1878237.0
2017-05-23 11:00:00	MSFT	Stock	68.53	68.65	68.45	68.645	1781377.0
2017-05-23 12:00:00	MSFT	Stock	68.65	68.666	68.385	68.435	2229381.0
2017-05-23 13:00:00	MSFT	Stock	68.44	68.6	68.431	68.56	1297656.0
2017-05-23 14:00:00	MSFT	Stock	68.555	68.66	68.506	68.624	1067254.0
2017-05-23 15:00:00	MSFT	Stock	68.625	68.71	68.58	68.69	2350087.0
2017-05-23 16:00:00	MSFT	Stock	68.69	68.69	68.6	68.66	1698649.0
2017-05-23 17:00:00	MSFT	Stock	68.6	68.6	68.58	68.58	512.0
2017-05-23 19:00:00	MSFT	Stock	68.58	68.58	68.55	68.55	1500.0
2017-05-23 04:00:00	NVDA	Stock	3.4748	3.4848	3.4748	3.4848	169480.0
2017-05-23 05:00:00	NVDA	Stock	3.49	3.49	3.4875	3.4875	22000.0
2017-05-23 06:00:00	NVDA	Stock	3.4925	3.4925	3.4788	3.4875	90080.0
2017-05-23 07:00:00	NVDA	Stock	3.484	3.491	3.4822	3.4825	755480.0
2017-05-23 08:00:00	NVDA	Stock	3.4838	3.4913	3.4788	3.4812	2334640.0
2017-05-23 09:00:00	NVDA	Stock	3.4825	3.4948	3.4078	3.4177	163674400.0
2017-05-23 10:00:00	NVDA	Stock	3.4168	3.4365	3.4025	3.423	134333880.0
2017-05-23 11:00:00	NVDA	Stock	3.4232	3.4485	3.4142	3.4398	99929400.0
2017-05-23 12:00:00	NVDA	Stock	3.4405	3.4425	3.3962	3.4002	89636360.0
2017-05-23 13:00:00	NVDA	Stock	3.3999	3.4119	3.3928	3.4078	45694760.0
2017-05-23 14:00:00	NVDA	Stock	3.4076	3.4308	3.4018	3.4232	47413560.0
2017-05-23 15:00:00	NVDA	Stock	3.4235	3.4495	3.4185	3.4255	65117600.0
2017-05-23 16:00:00	NVDA	Stock	3.4258	3.4265	3.4188	3.421	2543680.0
2017-05-23 17:00:00	NVDA	Stock	3.419	3.4208	3.4162	3.4165	143360.0
2017-05-23 18:00:00	NVDA	Stock	3.416	3.42	3.416	3.4178	310520.0
2017-05-23 19:00:00	NVDA	Stock	3.4198	3.4208	3.4175	3.4185	270720.0
2017-05-23 05:00:00	AMZN	Stock	48.6985	48.6985	48.6985	48.6985	2000.0
2017-05-23 06:00:00	AMZN	Stock	48.654	48.654	48.6485	48.6485	10260.0
2017-05-23 07:00:00	AMZN	Stock	48.65	48.696	48.65	48.696	109540.0
2017-05-23 08:00:00	AMZN	Stock	48.6875	48.76	48.6875	48.75	610020.0

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

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