PREVIEW / stock_1hour / 2012-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-05.parquet
  size:    920 KB
  rows:    43,857
  symbols: 3,513

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-06-05 05:00:00	AAPL	Stock	20.0179	20.0536	20.0179	20.0286	45080.0
2012-06-05 06:00:00	AAPL	Stock	20.07	20.07	20.0632	20.0632	5600.0
2012-06-05 07:00:00	AAPL	Stock	20.0475	20.0961	20.02	20.0961	401660.0
2012-06-05 08:00:00	AAPL	Stock	20.0929	20.1536	20.0629	20.1407	1336412.0
2012-06-05 09:00:00	AAPL	Stock	20.135	20.2275	20.0196	20.1148	65179688.0
2012-06-05 10:00:00	AAPL	Stock	20.1152	20.2311	20.0311	20.0929	79923704.0
2012-06-05 11:00:00	AAPL	Stock	20.0929	20.1712	20.0107	20.04	40502280.0
2012-06-05 12:00:00	AAPL	Stock	20.046	20.0911	19.9404	20.0282	47879748.0
2012-06-05 13:00:00	AAPL	Stock	20.0271	20.1204	19.9596	20.0936	38828412.0
2012-06-05 14:00:00	AAPL	Stock	20.0975	20.1532	20.0536	20.1357	40624836.0
2012-06-05 15:00:00	AAPL	Stock	20.1354	20.1771	20.0621	20.0957	62594280.0
2012-06-05 16:00:00	AAPL	Stock	20.0957	20.1252	20.0739	20.1	8823388.0
2012-06-05 17:00:00	AAPL	Stock	20.0968	20.1071	20.0893	20.1067	160944.0
2012-06-05 18:00:00	AAPL	Stock	20.1054	20.1071	20.0986	20.1071	41328.0
2012-06-05 19:00:00	AAPL	Stock	20.1075	20.1607	20.1071	20.1607	282688.0
2012-06-05 04:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	200.0
2012-06-05 05:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	700.0
2012-06-05 06:00:00	MSFT	Stock	28.54	28.54	28.54	28.54	100.0
2012-06-05 07:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2012-06-05 08:00:00	MSFT	Stock	28.49	28.6	28.45	28.55	11020.0
2012-06-05 09:00:00	MSFT	Stock	28.54	28.69	28.4	28.56	4572281.0
2012-06-05 10:00:00	MSFT	Stock	28.56	28.75	28.54	28.61	7109985.0
2012-06-05 11:00:00	MSFT	Stock	28.62	28.695	28.395	28.4	7021963.0
2012-06-05 12:00:00	MSFT	Stock	28.4	28.54	28.39	28.53	6035342.0
2012-06-05 13:00:00	MSFT	Stock	28.522	28.55	28.47	28.53	4598077.0
2012-06-05 14:00:00	MSFT	Stock	28.53	28.61	28.52	28.545	4437392.0
2012-06-05 15:00:00	MSFT	Stock	28.545	28.6	28.45	28.52	9235057.0
2012-06-05 16:00:00	MSFT	Stock	28.53	28.63	28.5	28.6	2336351.0
2012-06-05 17:00:00	MSFT	Stock	28.57	28.63	28.57	28.63	25167.0
2012-06-05 18:00:00	MSFT	Stock	28.6	28.68	28.6	28.63	9750.0
2012-06-05 19:00:00	MSFT	Stock	28.61	28.74	28.61	28.74	8800.0
2012-06-05 08:00:00	NVDA	Stock	0.2938	0.2938	0.2938	0.2938	60000.0
2012-06-05 09:00:00	NVDA	Stock	0.292	0.297	0.2918	0.2962	38308240.0
2012-06-05 10:00:00	NVDA	Stock	0.2962	0.2998	0.2962	0.2988	71169840.0
2012-06-05 11:00:00	NVDA	Stock	0.2988	0.2995	0.2955	0.2955	36796880.0
2012-06-05 12:00:00	NVDA	Stock	0.2958	0.2988	0.2956	0.2985	31968280.0
2012-06-05 13:00:00	NVDA	Stock	0.2982	0.3002	0.2968	0.2998	42207640.0
2012-06-05 14:00:00	NVDA	Stock	0.2999	0.301	0.299	0.3	38643080.0
2012-06-05 15:00:00	NVDA	Stock	0.3001	0.3025	0.2995	0.3015	91253200.0
2012-06-05 16:00:00	NVDA	Stock	0.3015	0.302	0.2988	0.3015	14489520.0
2012-06-05 18:00:00	NVDA	Stock	0.3018	0.303	0.3018	0.303	16520.0
2012-06-05 05:00:00	AMZN	Stock	10.688	10.688	10.688	10.688	2000.0
2012-06-05 07:00:00	AMZN	Stock	10.6895	10.7025	10.6565	10.6775	80560.0
2012-06-05 08:00:00	AMZN	Stock	10.681	10.725	10.681	10.71	61860.0
2012-06-05 09:00:00	AMZN	Stock	10.7045	10.843	10.6165	10.633	11639200.0
2012-06-05 10:00:00	AMZN	Stock	10.633	10.765	10.576	10.606	15582860.0
2012-06-05 11:00:00	AMZN	Stock	10.606	10.665	10.565	10.572	9226360.0
2012-06-05 12:00:00	AMZN	Stock	10.572	10.6645	10.558	10.6255	9221420.0
2012-06-05 13:00:00	AMZN	Stock	10.627	10.67	10.5895	10.636	4794440.0
2012-06-05 14:00:00	AMZN	Stock	10.635	10.687	10.602	10.6835	6967420.0

> showing 50 of 43,857 rows — these rows as CSV

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