PREVIEW / stock_1hour / 2013-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-01.parquet
  size:    1.0 MB
  rows:    47,993
  symbols: 3,538

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
2013-10-01 04:00:00	AAPL	Stock	17.0996	17.1029	17.0479	17.0839	72800.0
2013-10-01 05:00:00	AAPL	Stock	17.0893	17.0893	17.0725	17.0882	30800.0
2013-10-01 06:00:00	AAPL	Stock	17.0714	17.0714	17.0571	17.0714	33600.0
2013-10-01 07:00:00	AAPL	Stock	17.0904	17.1279	17.0393	17.0507	605556.0
2013-10-01 08:00:00	AAPL	Stock	17.0482	17.1179	17.0268	17.0557	1821064.0
2013-10-01 09:00:00	AAPL	Stock	17.0564	17.2014	17.055	17.1239	43903244.0
2013-10-01 10:00:00	AAPL	Stock	17.1243	17.3475	17.1179	17.3161	78784496.0
2013-10-01 11:00:00	AAPL	Stock	17.3246	17.375	17.3068	17.3614	37269904.0
2013-10-01 12:00:00	AAPL	Stock	17.3602	17.4693	17.3575	17.4589	49538020.0
2013-10-01 13:00:00	AAPL	Stock	17.46	17.4686	17.3657	17.3907	33244204.0
2013-10-01 14:00:00	AAPL	Stock	17.3921	17.4375	17.3768	17.3968	27626760.0
2013-10-01 15:00:00	AAPL	Stock	17.3946	17.4318	17.3318	17.4284	47200300.0
2013-10-01 16:00:00	AAPL	Stock	17.4268	17.4518	17.0268	17.0268	21306208.0
2013-10-01 17:00:00	AAPL	Stock	17.4464	17.4564	17.4289	17.4446	581644.0
2013-10-01 18:00:00	AAPL	Stock	17.445	17.4461	17.4157	17.4393	593404.0
2013-10-01 19:00:00	AAPL	Stock	17.4429	17.4464	17.4271	17.4429	269164.0
2013-10-01 04:00:00	MSFT	Stock	33.1	33.1	33.1	33.1	100.0
2013-10-01 06:00:00	MSFT	Stock	33.3	33.3	33.3	33.3	200.0
2013-10-01 07:00:00	MSFT	Stock	33.26	33.3	33.16	33.3	800.0
2013-10-01 08:00:00	MSFT	Stock	33.25	33.44	33.25	33.37	73764.0
2013-10-01 09:00:00	MSFT	Stock	33.37	33.55	33.3	33.41	5827430.0
2013-10-01 10:00:00	MSFT	Stock	33.41	33.6	33.33	33.59	6264157.0
2013-10-01 11:00:00	MSFT	Stock	33.58	33.61	33.45	33.51	3614988.0
2013-10-01 12:00:00	MSFT	Stock	33.51	33.565	33.35	33.409	3126664.0
2013-10-01 13:00:00	MSFT	Stock	33.41	33.52	33.365	33.38	2469285.0
2013-10-01 14:00:00	MSFT	Stock	33.39	33.46	33.34	33.415	2792252.0
2013-10-01 15:00:00	MSFT	Stock	33.41	33.6	33.355	33.58	7610703.0
2013-10-01 16:00:00	MSFT	Stock	33.58	33.63	33.38	33.55	2822747.0
2013-10-01 17:00:00	MSFT	Stock	33.53	33.59	33.492	33.492	41208.0
2013-10-01 18:00:00	MSFT	Stock	33.57	33.57	33.31	33.56	17899.0
2013-10-01 19:00:00	MSFT	Stock	33.56	33.58	33.56	33.56	8908.0
2013-10-01 08:00:00	NVDA	Stock	0.389	0.389	0.389	0.389	508000.0
2013-10-01 09:00:00	NVDA	Stock	0.3882	0.391	0.3878	0.3895	17470720.0
2013-10-01 10:00:00	NVDA	Stock	0.3894	0.391	0.3882	0.3901	26041000.0
2013-10-01 11:00:00	NVDA	Stock	0.3901	0.3914	0.3898	0.3908	21598800.0
2013-10-01 12:00:00	NVDA	Stock	0.3909	0.3913	0.389	0.389	18843200.0
2013-10-01 13:00:00	NVDA	Stock	0.389	0.3893	0.388	0.388	12430960.0
2013-10-01 14:00:00	NVDA	Stock	0.388	0.3882	0.3868	0.3874	44138160.0
2013-10-01 15:00:00	NVDA	Stock	0.3875	0.3888	0.3866	0.3888	73076680.0
2013-10-01 16:00:00	NVDA	Stock	0.3888	0.3898	0.3878	0.3888	2644680.0
2013-10-01 18:00:00	NVDA	Stock	0.389	0.389	0.389	0.389	121680.0
2013-10-01 04:00:00	AMZN	Stock	15.6965	15.71	15.695	15.695	10000.0
2013-10-01 05:00:00	AMZN	Stock	15.695	15.695	15.695	15.695	2000.0
2013-10-01 06:00:00	AMZN	Stock	15.695	15.695	15.695	15.695	2000.0
2013-10-01 07:00:00	AMZN	Stock	15.6925	15.694	15.6875	15.694	26000.0
2013-10-01 08:00:00	AMZN	Stock	15.6975	15.725	15.6	15.7	1021280.0
2013-10-01 09:00:00	AMZN	Stock	15.706	15.8875	15.6825	15.7338	8788400.0
2013-10-01 10:00:00	AMZN	Stock	15.7338	15.9078	15.71	15.8775	8927880.0
2013-10-01 11:00:00	AMZN	Stock	15.8825	15.916	15.8284	15.887	4045680.0
2013-10-01 12:00:00	AMZN	Stock	15.8865	15.909	15.8501	15.872	1884640.0

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

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