PREVIEW / stock_1hour / 2011-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-14.parquet
  size:    954 KB
  rows:    45,843
  symbols: 3,524

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
2011-01-14 05:00:00	AAPL	Stock	12.3929	12.3929	12.3875	12.3929	47712.0
2011-01-14 06:00:00	AAPL	Stock	12.3964	12.3964	12.3929	12.3929	39200.0
2011-01-14 07:00:00	AAPL	Stock	12.3854	12.3854	12.3218	12.3357	533484.0
2011-01-14 08:00:00	AAPL	Stock	12.3393	12.3421	12.3154	12.3289	1440712.0
2011-01-14 09:00:00	AAPL	Stock	12.3268	12.3596	12.3014	12.3211	52736348.0
2011-01-14 10:00:00	AAPL	Stock	12.3207	12.3879	12.3207	12.3879	67357164.0
2011-01-14 11:00:00	AAPL	Stock	12.3879	12.4057	12.3786	12.3825	34640900.0
2011-01-14 12:00:00	AAPL	Stock	12.3821	12.4143	12.3796	12.4107	23950136.0
2011-01-14 13:00:00	AAPL	Stock	12.4118	12.4286	12.3979	12.4271	24354204.0
2011-01-14 14:00:00	AAPL	Stock	12.4271	12.4279	12.4018	12.4042	24984008.0
2011-01-14 15:00:00	AAPL	Stock	12.4046	12.4457	12.4042	12.445	64205036.0
2011-01-14 16:00:00	AAPL	Stock	12.4457	12.4464	12.3825	12.4421	12510792.0
2011-01-14 17:00:00	AAPL	Stock	12.4396	12.4457	12.4371	12.4393	755832.0
2011-01-14 18:00:00	AAPL	Stock	12.44	12.4446	12.4357	12.4371	392112.0
2011-01-14 19:00:00	AAPL	Stock	12.4361	12.4461	12.4357	12.4429	562800.0
2011-01-14 07:00:00	MSFT	Stock	28.24	28.25	28.19	28.2	8500.0
2011-01-14 08:00:00	MSFT	Stock	28.21	28.27	28.19	28.19	67373.0
2011-01-14 09:00:00	MSFT	Stock	28.19	28.27	27.91	28.0	11162270.0
2011-01-14 10:00:00	MSFT	Stock	28.0	28.15	27.99	28.09	10677551.0
2011-01-14 11:00:00	MSFT	Stock	28.088	28.13	28.07	28.12	9016484.0
2011-01-14 12:00:00	MSFT	Stock	28.11	28.23	28.07	28.18	6402196.0
2011-01-14 13:00:00	MSFT	Stock	28.181	28.26	28.165	28.25	4907380.0
2011-01-14 14:00:00	MSFT	Stock	28.258	28.38	28.24	28.325	5721690.0
2011-01-14 15:00:00	MSFT	Stock	28.32	28.358	28.2	28.3	9339485.0
2011-01-14 16:00:00	MSFT	Stock	28.3	28.32	28.13	28.25	2860065.0
2011-01-14 17:00:00	MSFT	Stock	28.28	28.3	28.25	28.25	21097.0
2011-01-14 18:00:00	MSFT	Stock	28.25	28.28	28.25	28.28	1300.0
2011-01-14 19:00:00	MSFT	Stock	28.27	28.3	28.27	28.3	2300.0
2011-01-14 05:00:00	NVDA	Stock	0.5762	0.5762	0.575	0.575	38000.0
2011-01-14 07:00:00	NVDA	Stock	0.58	0.58	0.575	0.578	168000.0
2011-01-14 08:00:00	NVDA	Stock	0.5805	0.5818	0.5725	0.5765	3857560.0
2011-01-14 09:00:00	NVDA	Stock	0.5778	0.5812	0.5712	0.578	235939360.0
2011-01-14 10:00:00	NVDA	Stock	0.578	0.5875	0.5735	0.587	285444160.0
2011-01-14 11:00:00	NVDA	Stock	0.587	0.5995	0.5868	0.5952	365918480.0
2011-01-14 12:00:00	NVDA	Stock	0.595	0.5988	0.5918	0.5933	163783000.0
2011-01-14 13:00:00	NVDA	Stock	0.5931	0.596	0.5903	0.5944	140121040.0
2011-01-14 14:00:00	NVDA	Stock	0.5943	0.5963	0.5928	0.5948	129536760.0
2011-01-14 15:00:00	NVDA	Stock	0.5948	0.598	0.5893	0.5895	248749000.0
2011-01-14 16:00:00	NVDA	Stock	0.5903	0.5975	0.5848	0.5912	16258360.0
2011-01-14 17:00:00	NVDA	Stock	0.5905	0.5912	0.5903	0.5912	412080.0
2011-01-14 18:00:00	NVDA	Stock	0.5912	0.5918	0.5905	0.5915	766800.0
2011-01-14 19:00:00	NVDA	Stock	0.5918	0.5923	0.5915	0.592	166040.0
2011-01-14 05:00:00	AMZN	Stock	9.2765	9.2765	9.2765	9.2765	20000.0
2011-01-14 08:00:00	AMZN	Stock	9.255	9.275	9.25	9.274	80600.0
2011-01-14 09:00:00	AMZN	Stock	9.275	9.315	9.246	9.3	9028800.0
2011-01-14 10:00:00	AMZN	Stock	9.3025	9.3625	9.287	9.334	15517840.0
2011-01-14 11:00:00	AMZN	Stock	9.336	9.375	9.3295	9.3653	11100080.0
2011-01-14 12:00:00	AMZN	Stock	9.366	9.368	9.3435	9.3455	5430360.0
2011-01-14 13:00:00	AMZN	Stock	9.345	9.3595	9.334	9.355	5418580.0
2011-01-14 14:00:00	AMZN	Stock	9.355	9.383	9.355	9.3765	6435360.0

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

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