PREVIEW / stock_1hour / 2012-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-03.parquet
  size:    985 KB
  rows:    46,472
  symbols: 3,543

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-02-03 04:00:00	AAPL	Stock	16.2661	16.2661	16.2661	16.2661	2800.0
2012-02-03 06:00:00	AAPL	Stock	16.2714	16.2714	16.2714	16.2714	21140.0
2012-02-03 07:00:00	AAPL	Stock	16.275	16.275	16.2589	16.2589	124656.0
2012-02-03 08:00:00	AAPL	Stock	16.2639	16.3571	16.2136	16.3311	5102524.0
2012-02-03 09:00:00	AAPL	Stock	16.3375	16.3393	16.27	16.3179	38924424.0
2012-02-03 10:00:00	AAPL	Stock	16.3143	16.3893	16.3107	16.3789	60859372.0
2012-02-03 11:00:00	AAPL	Stock	16.3779	16.4179	16.3579	16.4068	39448304.0
2012-02-03 12:00:00	AAPL	Stock	16.405	16.4214	16.3943	16.4179	25871720.0
2012-02-03 13:00:00	AAPL	Stock	16.4175	16.4243	16.4036	16.4143	16701552.0
2012-02-03 14:00:00	AAPL	Stock	16.4136	16.4286	16.4096	16.4243	30777376.0
2012-02-03 15:00:00	AAPL	Stock	16.4239	16.4257	16.3892	16.4129	47566204.0
2012-02-03 16:00:00	AAPL	Stock	16.4161	16.4221	16.2543	16.3964	19930064.0
2012-02-03 17:00:00	AAPL	Stock	16.3975	16.4171	16.3929	16.3954	212156.0
2012-02-03 18:00:00	AAPL	Stock	16.3961	16.4171	16.3946	16.3989	138908.0
2012-02-03 19:00:00	AAPL	Stock	16.3968	16.4	16.3932	16.3932	170296.0
2012-02-03 06:00:00	MSFT	Stock	30.06	30.06	30.06	30.06	500.0
2012-02-03 07:00:00	MSFT	Stock	30.01	30.08	30.01	30.08	1600.0
2012-02-03 08:00:00	MSFT	Stock	30.01	30.2	29.95	30.16	197260.0
2012-02-03 09:00:00	MSFT	Stock	30.16	30.3	30.09	30.298	5394556.0
2012-02-03 10:00:00	MSFT	Stock	30.29	30.35	30.24	30.33	7047239.0
2012-02-03 11:00:00	MSFT	Stock	30.32	30.38	30.27	30.315	7000033.0
2012-02-03 12:00:00	MSFT	Stock	30.31	30.4	30.3	30.355	4740694.0
2012-02-03 13:00:00	MSFT	Stock	30.36	30.37	30.28	30.3	3490441.0
2012-02-03 14:00:00	MSFT	Stock	30.3	30.31	30.24	30.28	3645346.0
2012-02-03 15:00:00	MSFT	Stock	30.28	30.28	30.17	30.22	7401220.0
2012-02-03 16:00:00	MSFT	Stock	30.22	30.288	29.95	30.16	2595313.0
2012-02-03 17:00:00	MSFT	Stock	30.17	30.24	30.17	30.18	23194.0
2012-02-03 18:00:00	MSFT	Stock	30.2	30.24	30.19	30.2	7879.0
2012-02-03 19:00:00	MSFT	Stock	30.2	30.21	30.17	30.21	5640.0
2012-02-03 08:00:00	NVDA	Stock	0.387	0.3938	0.387	0.3922	739160.0
2012-02-03 09:00:00	NVDA	Stock	0.3925	0.3978	0.3905	0.3945	97170800.0
2012-02-03 10:00:00	NVDA	Stock	0.3945	0.398	0.3938	0.3972	92712920.0
2012-02-03 11:00:00	NVDA	Stock	0.397	0.3975	0.3953	0.3965	60912880.0
2012-02-03 12:00:00	NVDA	Stock	0.3965	0.3988	0.3962	0.3965	38105880.0
2012-02-03 13:00:00	NVDA	Stock	0.3965	0.3975	0.3965	0.3968	34325720.0
2012-02-03 14:00:00	NVDA	Stock	0.397	0.3975	0.3969	0.3975	25134120.0
2012-02-03 15:00:00	NVDA	Stock	0.3975	0.3975	0.3948	0.3955	132933320.0
2012-02-03 16:00:00	NVDA	Stock	0.3953	0.3961	0.3871	0.395	12391440.0
2012-02-03 17:00:00	NVDA	Stock	0.3955	0.3955	0.3955	0.3955	16360.0
2012-02-03 18:00:00	NVDA	Stock	0.3955	0.3968	0.3942	0.396	244320.0
2012-02-03 19:00:00	NVDA	Stock	0.3958	0.3968	0.3958	0.3968	117000.0
2012-02-03 04:00:00	AMZN	Stock	9.1025	9.1025	9.1025	9.1025	2600.0
2012-02-03 05:00:00	AMZN	Stock	9.1495	9.155	9.1495	9.155	4000.0
2012-02-03 07:00:00	AMZN	Stock	9.125	9.125	9.1055	9.1055	16000.0
2012-02-03 08:00:00	AMZN	Stock	9.11	9.204	9.0945	9.1275	1523180.0
2012-02-03 09:00:00	AMZN	Stock	9.1275	9.215	9.0945	9.1648	26937440.0
2012-02-03 10:00:00	AMZN	Stock	9.165	9.241	9.1285	9.23	28031160.0
2012-02-03 11:00:00	AMZN	Stock	9.228	9.243	9.2065	9.218	15621960.0
2012-02-03 12:00:00	AMZN	Stock	9.2175	9.285	9.2125	9.2815	17155180.0
2012-02-03 13:00:00	AMZN	Stock	9.2815	9.3225	9.2595	9.274	18525500.0

> showing 50 of 46,472 rows — these rows as CSV

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