PREVIEW / stock_1hour / 2012-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-27.parquet
  size:    935 KB
  rows:    44,233
  symbols: 3,483

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-07-27 04:00:00	AAPL	Stock	20.5611	20.6425	20.5575	20.5575	62160.0
2012-07-27 05:00:00	AAPL	Stock	20.5414	20.6071	20.5414	20.6071	28000.0
2012-07-27 06:00:00	AAPL	Stock	20.6068	20.6071	20.6036	20.6071	30520.0
2012-07-27 07:00:00	AAPL	Stock	20.6054	20.6071	20.5571	20.5571	268072.0
2012-07-27 08:00:00	AAPL	Stock	20.5536	20.5571	20.4911	20.4946	1613248.0
2012-07-27 09:00:00	AAPL	Stock	20.4964	20.55	20.4139	20.4721	50650264.0
2012-07-27 10:00:00	AAPL	Stock	20.4718	20.5693	20.4361	20.5579	50185520.0
2012-07-27 11:00:00	AAPL	Stock	20.5586	20.6957	20.55	20.6739	60385780.0
2012-07-27 12:00:00	AAPL	Stock	20.675	20.6868	20.6325	20.6643	27244308.0
2012-07-27 13:00:00	AAPL	Stock	20.6666	20.8446	20.6357	20.7793	69943888.0
2012-07-27 14:00:00	AAPL	Stock	20.7764	20.8393	20.76	20.8171	33864180.0
2012-07-27 15:00:00	AAPL	Stock	20.8164	20.9225	20.8143	20.9029	80214064.0
2012-07-27 16:00:00	AAPL	Stock	20.9089	20.9089	20.6925	20.8946	15967644.0
2012-07-27 17:00:00	AAPL	Stock	20.8946	20.8996	20.8921	20.8968	327740.0
2012-07-27 18:00:00	AAPL	Stock	20.8996	20.9018	20.8964	20.8964	58380.0
2012-07-27 19:00:00	AAPL	Stock	20.8946	20.9	20.8911	20.9	118776.0
2012-07-27 07:00:00	MSFT	Stock	29.21	29.34	29.21	29.34	1000.0
2012-07-27 08:00:00	MSFT	Stock	29.23	29.32	29.23	29.23	4551.0
2012-07-27 09:00:00	MSFT	Stock	29.28	29.5	29.18	29.3	3553004.0
2012-07-27 10:00:00	MSFT	Stock	29.29	29.5	29.24	29.49	5748165.0
2012-07-27 11:00:00	MSFT	Stock	29.49	29.57	29.42	29.495	4017959.0
2012-07-27 12:00:00	MSFT	Stock	29.5	29.58	29.47	29.505	3204671.0
2012-07-27 13:00:00	MSFT	Stock	29.51	29.81	29.49	29.76	7001228.0
2012-07-27 14:00:00	MSFT	Stock	29.75	29.77	29.64	29.66	5473866.0
2012-07-27 15:00:00	MSFT	Stock	29.66	29.85	29.65	29.77	10312237.0
2012-07-27 16:00:00	MSFT	Stock	29.76	29.8	29.48	29.75	4584933.0
2012-07-27 17:00:00	MSFT	Stock	29.74	29.74	29.74	29.74	850.0
2012-07-27 18:00:00	MSFT	Stock	29.74	29.75	29.74	29.75	1606.0
2012-07-27 19:00:00	MSFT	Stock	29.77	29.78	29.77	29.78	632.0
2012-07-27 09:00:00	NVDA	Stock	0.3303	0.3335	0.3275	0.3333	33666120.0
2012-07-27 10:00:00	NVDA	Stock	0.3335	0.3345	0.331	0.334	37784360.0
2012-07-27 11:00:00	NVDA	Stock	0.334	0.3346	0.3314	0.332	44959800.0
2012-07-27 12:00:00	NVDA	Stock	0.3322	0.3333	0.3305	0.3325	25436240.0
2012-07-27 13:00:00	NVDA	Stock	0.3328	0.3346	0.3318	0.3338	60929520.0
2012-07-27 14:00:00	NVDA	Stock	0.3338	0.3365	0.3325	0.3365	52408240.0
2012-07-27 15:00:00	NVDA	Stock	0.3365	0.338	0.336	0.337	108258680.0
2012-07-27 16:00:00	NVDA	Stock	0.337	0.3378	0.3368	0.3368	3100800.0
2012-07-27 17:00:00	NVDA	Stock	0.3365	0.3365	0.3362	0.3362	24000.0
2012-07-27 04:00:00	AMZN	Stock	11.082	11.082	11.055	11.055	25400.0
2012-07-27 05:00:00	AMZN	Stock	11.0085	11.05	10.995	11.05	24000.0
2012-07-27 06:00:00	AMZN	Stock	11.0	11.0525	10.9935	11.0275	73160.0
2012-07-27 07:00:00	AMZN	Stock	11.045	11.0925	11.0145	11.05	220960.0
2012-07-27 08:00:00	AMZN	Stock	11.05	11.1845	11.05	11.1605	1781920.0
2012-07-27 09:00:00	AMZN	Stock	11.1605	11.733	11.1605	11.711	67345540.0
2012-07-27 10:00:00	AMZN	Stock	11.7115	11.754	11.586	11.594	36182160.0
2012-07-27 11:00:00	AMZN	Stock	11.5965	11.74	11.548	11.7075	21878520.0
2012-07-27 12:00:00	AMZN	Stock	11.705	11.825	11.684	11.8175	23083660.0
2012-07-27 13:00:00	AMZN	Stock	11.815	11.845	11.7545	11.8105	22207640.0
2012-07-27 14:00:00	AMZN	Stock	11.8105	11.884	11.8	11.8571	17301740.0
2012-07-27 15:00:00	AMZN	Stock	11.861	11.917	11.815	11.871	29926280.0

> showing 50 of 44,233 rows — these rows as CSV

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