PREVIEW / stock_1hour / 2015-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-01.parquet
  size:    1.1 MB
  rows:    49,426
  symbols: 3,504

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
2015-04-01 04:00:00	AAPL	Stock	31.075	31.1025	31.075	31.0825	8000.0
2015-04-01 05:00:00	AAPL	Stock	31.12	31.125	31.1075	31.1075	32668.0
2015-04-01 06:00:00	AAPL	Stock	31.11	31.1675	31.1075	31.1625	43368.0
2015-04-01 07:00:00	AAPL	Stock	31.15	31.175	31.0175	31.06	125852.0
2015-04-01 08:00:00	AAPL	Stock	31.075	31.2125	31.0175	31.2025	888644.0
2015-04-01 09:00:00	AAPL	Stock	31.2075	31.28	30.7775	30.8675	31229812.0
2015-04-01 10:00:00	AAPL	Stock	30.8675	31.045	30.775	30.9875	31157640.0
2015-04-01 11:00:00	AAPL	Stock	30.985	31.1275	30.92	31.02	18965340.0
2015-04-01 12:00:00	AAPL	Stock	31.0175	31.0575	30.925	30.9625	10288120.0
2015-04-01 13:00:00	AAPL	Stock	30.9625	31.1725	30.9225	31.1055	14142892.0
2015-04-01 14:00:00	AAPL	Stock	31.1075	31.1222	30.935	31.019	15060328.0
2015-04-01 15:00:00	AAPL	Stock	31.02	31.0625	30.9125	31.0575	21778292.0
2015-04-01 16:00:00	AAPL	Stock	31.0625	31.1225	30.9938	31.105	7582224.0
2015-04-01 17:00:00	AAPL	Stock	31.1125	31.135	31.0132	31.135	414868.0
2015-04-01 18:00:00	AAPL	Stock	31.1375	31.185	31.135	31.1675	271152.0
2015-04-01 19:00:00	AAPL	Stock	31.1675	31.1775	31.115	31.135	94448.0
2015-04-01 04:00:00	MSFT	Stock	40.6	40.6	40.59	40.59	215.0
2015-04-01 06:00:00	MSFT	Stock	40.73	40.73	40.73	40.73	100.0
2015-04-01 07:00:00	MSFT	Stock	40.73	40.73	40.41	40.41	15701.0
2015-04-01 08:00:00	MSFT	Stock	40.47	40.655	40.47	40.61	33487.0
2015-04-01 09:00:00	MSFT	Stock	40.655	40.76	40.31	40.43	6394518.0
2015-04-01 10:00:00	MSFT	Stock	40.42	40.67	40.38	40.605	5374179.0
2015-04-01 11:00:00	MSFT	Stock	40.6	40.665	40.51	40.54	3859610.0
2015-04-01 12:00:00	MSFT	Stock	40.54	40.61	40.5	40.57	3459914.0
2015-04-01 13:00:00	MSFT	Stock	40.57	40.69	40.56	40.67	2524003.0
2015-04-01 14:00:00	MSFT	Stock	40.675	40.716	40.61	40.646	4159066.0
2015-04-01 15:00:00	MSFT	Stock	40.645	40.73	40.56	40.71	7056742.0
2015-04-01 16:00:00	MSFT	Stock	40.72	40.93	40.58	40.596	2612421.0
2015-04-01 17:00:00	MSFT	Stock	40.72	40.72	40.565	40.72	56956.0
2015-04-01 18:00:00	MSFT	Stock	40.7	40.71	40.7	40.7	2659.0
2015-04-01 19:00:00	MSFT	Stock	40.7	40.73	40.689	40.73	2745.0
2015-04-01 08:00:00	NVDA	Stock	0.524	0.5242	0.5225	0.5225	3236600.0
2015-04-01 09:00:00	NVDA	Stock	0.5225	0.5253	0.5162	0.5188	39221040.0
2015-04-01 10:00:00	NVDA	Stock	0.5188	0.527	0.5184	0.5219	89517320.0
2015-04-01 11:00:00	NVDA	Stock	0.5222	0.5247	0.5198	0.5222	26939280.0
2015-04-01 12:00:00	NVDA	Stock	0.5224	0.5253	0.5218	0.5247	19689040.0
2015-04-01 13:00:00	NVDA	Stock	0.5247	0.526	0.5232	0.5241	29521400.0
2015-04-01 14:00:00	NVDA	Stock	0.5242	0.5258	0.5222	0.525	37463240.0
2015-04-01 15:00:00	NVDA	Stock	0.5249	0.5259	0.5228	0.5253	55198960.0
2015-04-01 16:00:00	NVDA	Stock	0.5253	0.5258	0.5234	0.5258	18415480.0
2015-04-01 17:00:00	NVDA	Stock	0.5262	0.5262	0.5253	0.5253	957320.0
2015-04-01 18:00:00	NVDA	Stock	0.5255	0.5255	0.5255	0.5255	16000.0
2015-04-01 05:00:00	AMZN	Stock	18.6	18.6	18.6	18.6	18000.0
2015-04-01 07:00:00	AMZN	Stock	18.625	18.625	18.556	18.575	50000.0
2015-04-01 08:00:00	AMZN	Stock	18.5765	18.605	18.5475	18.605	57280.0
2015-04-01 09:00:00	AMZN	Stock	18.59	18.658	18.417	18.4872	8127440.0
2015-04-01 10:00:00	AMZN	Stock	18.482	18.5875	18.438	18.544	8173020.0
2015-04-01 11:00:00	AMZN	Stock	18.55	18.579	18.481	18.4988	4304760.0
2015-04-01 12:00:00	AMZN	Stock	18.5	18.536	18.4405	18.509	5473000.0
2015-04-01 13:00:00	AMZN	Stock	18.5098	18.5185	18.4512	18.4935	2423960.0

> showing 50 of 49,426 rows — these rows as CSV

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