PREVIEW / stock_1hour / 2012-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-26.parquet
  size:    942 KB
  rows:    45,087
  symbols: 3,459

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
2012-09-26 04:00:00	AAPL	Stock	24.1025	24.1025	24.0075	24.0714	92820.0
2012-09-26 05:00:00	AAPL	Stock	24.0857	24.0893	24.0857	24.0893	25200.0
2012-09-26 06:00:00	AAPL	Stock	24.0643	24.0643	24.0211	24.0211	40460.0
2012-09-26 07:00:00	AAPL	Stock	24.0357	24.0511	23.8982	23.9432	684516.0
2012-09-26 08:00:00	AAPL	Stock	23.9518	24.0661	23.9143	23.9464	2812656.0
2012-09-26 09:00:00	AAPL	Stock	23.9446	23.9643	23.625	23.767	136502184.0
2012-09-26 10:00:00	AAPL	Stock	23.7655	23.8839	23.6143	23.6429	103293456.0
2012-09-26 11:00:00	AAPL	Stock	23.6429	23.75	23.6429	23.6939	56245672.0
2012-09-26 12:00:00	AAPL	Stock	23.6897	23.8336	23.6662	23.7289	63154448.0
2012-09-26 13:00:00	AAPL	Stock	23.7289	23.8831	23.6893	23.7752	44149504.0
2012-09-26 14:00:00	AAPL	Stock	23.7779	24.0246	23.7737	23.921	83523076.0
2012-09-26 15:00:00	AAPL	Stock	23.9164	23.9279	23.75	23.7511	67752552.0
2012-09-26 16:00:00	AAPL	Stock	23.75	23.8622	23.711	23.7746	10813096.0
2012-09-26 17:00:00	AAPL	Stock	23.7732	23.7775	23.75	23.7714	684264.0
2012-09-26 18:00:00	AAPL	Stock	23.7764	23.8036	23.7764	23.7925	131124.0
2012-09-26 19:00:00	AAPL	Stock	23.7929	23.8036	23.7646	23.8036	183456.0
2012-09-26 07:00:00	MSFT	Stock	30.31	30.38	30.25	30.3	17800.0
2012-09-26 08:00:00	MSFT	Stock	30.3	30.36	30.28	30.36	46365.0
2012-09-26 09:00:00	MSFT	Stock	30.34	30.6	30.23	30.25	9041640.0
2012-09-26 10:00:00	MSFT	Stock	30.25	30.3	30.04	30.07	10269765.0
2012-09-26 11:00:00	MSFT	Stock	30.075	30.2	30.06	30.165	5037028.0
2012-09-26 12:00:00	MSFT	Stock	30.165	30.19	30.07	30.11	5996574.0
2012-09-26 13:00:00	MSFT	Stock	30.11	30.2	30.09	30.1	3755946.0
2012-09-26 14:00:00	MSFT	Stock	30.1	30.16	30.085	30.11	3538378.0
2012-09-26 15:00:00	MSFT	Stock	30.115	30.185	30.06	30.18	10177772.0
2012-09-26 16:00:00	MSFT	Stock	30.175	30.22	30.11	30.11	1772029.0
2012-09-26 17:00:00	MSFT	Stock	30.2	30.21	30.16	30.17	88357.0
2012-09-26 18:00:00	MSFT	Stock	30.19	30.24	30.17	30.21	9319.0
2012-09-26 19:00:00	MSFT	Stock	30.21	30.21	30.17	30.2	1942.0
2012-09-26 06:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	4000.0
2012-09-26 07:00:00	NVDA	Stock	0.3375	0.3375	0.3375	0.3375	40000.0
2012-09-26 08:00:00	NVDA	Stock	0.337	0.337	0.3345	0.3345	60000.0
2012-09-26 09:00:00	NVDA	Stock	0.3345	0.3345	0.3295	0.331	61167560.0
2012-09-26 10:00:00	NVDA	Stock	0.331	0.3311	0.3255	0.3261	75960280.0
2012-09-26 11:00:00	NVDA	Stock	0.3263	0.3293	0.3258	0.3283	74345720.0
2012-09-26 12:00:00	NVDA	Stock	0.3284	0.331	0.328	0.3285	51812760.0
2012-09-26 13:00:00	NVDA	Stock	0.3288	0.3303	0.3283	0.3283	38196080.0
2012-09-26 14:00:00	NVDA	Stock	0.3283	0.3303	0.3283	0.33	30268880.0
2012-09-26 15:00:00	NVDA	Stock	0.33	0.3303	0.3283	0.3294	90102480.0
2012-09-26 16:00:00	NVDA	Stock	0.3293	0.3295	0.3289	0.3293	12249480.0
2012-09-26 17:00:00	NVDA	Stock	0.3351	0.3351	0.3293	0.3293	229200.0
2012-09-26 18:00:00	NVDA	Stock	0.3293	0.3293	0.3293	0.3293	40000.0
2012-09-26 19:00:00	NVDA	Stock	0.3298	0.3298	0.3298	0.3298	4000.0
2012-09-26 05:00:00	AMZN	Stock	12.55	12.55	12.55	12.55	2000.0
2012-09-26 08:00:00	AMZN	Stock	12.575	12.625	12.575	12.6	139820.0
2012-09-26 09:00:00	AMZN	Stock	12.6125	12.7305	12.564	12.5838	9799200.0
2012-09-26 10:00:00	AMZN	Stock	12.584	12.5849	12.4115	12.4383	14718140.0
2012-09-26 11:00:00	AMZN	Stock	12.436	12.53	12.4345	12.5185	6044160.0
2012-09-26 12:00:00	AMZN	Stock	12.5135	12.5415	12.484	12.529	5179400.0
2012-09-26 13:00:00	AMZN	Stock	12.529	12.558	12.464	12.4705	6088620.0

> showing 50 of 45,087 rows — these rows as CSV

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