PREVIEW / stock_1hour / 2012-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-28.parquet
  size:    937 KB
  rows:    44,097
  symbols: 3,505

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-09-28 04:00:00	AAPL	Stock	24.4104	24.4286	24.4	24.4286	37352.0
2012-09-28 05:00:00	AAPL	Stock	24.4411	24.4411	24.4107	24.4107	75600.0
2012-09-28 06:00:00	AAPL	Stock	24.4107	24.4107	24.3236	24.3521	94220.0
2012-09-28 07:00:00	AAPL	Stock	24.3521	24.3521	24.245	24.2946	553336.0
2012-09-28 08:00:00	AAPL	Stock	24.2882	24.3214	24.175	24.2382	3669792.0
2012-09-28 09:00:00	AAPL	Stock	24.2425	24.3254	24.0989	24.1346	88885888.0
2012-09-28 10:00:00	AAPL	Stock	24.1289	24.2121	23.9582	24.0457	94118780.0
2012-09-28 11:00:00	AAPL	Stock	24.0457	24.0511	23.8125	23.9857	78719312.0
2012-09-28 12:00:00	AAPL	Stock	23.9852	24.1032	23.955	24.0636	54803308.0
2012-09-28 13:00:00	AAPL	Stock	24.0609	24.1229	23.9646	24.0329	40285112.0
2012-09-28 14:00:00	AAPL	Stock	24.0311	24.0618	23.8779	23.945	51813860.0
2012-09-28 15:00:00	AAPL	Stock	23.9407	23.9682	23.8225	23.8243	88076296.0
2012-09-28 16:00:00	AAPL	Stock	23.8243	24.19	23.815	23.8271	19491556.0
2012-09-28 17:00:00	AAPL	Stock	23.8271	24.0282	23.7929	23.8011	527632.0
2012-09-28 18:00:00	AAPL	Stock	23.8007	23.8018	23.7786	23.7786	388360.0
2012-09-28 19:00:00	AAPL	Stock	23.7882	23.7975	23.7714	23.7771	307356.0
2012-09-28 08:00:00	MSFT	Stock	30.23	30.23	30.0	30.02	28949.0
2012-09-28 09:00:00	MSFT	Stock	30.07	30.26	29.94	29.95	5843660.0
2012-09-28 10:00:00	MSFT	Stock	29.95	30.05	29.79	29.845	9856697.0
2012-09-28 11:00:00	MSFT	Stock	29.845	29.91	29.76	29.77	5522918.0
2012-09-28 12:00:00	MSFT	Stock	29.77	29.91	29.75	29.82	4096840.0
2012-09-28 13:00:00	MSFT	Stock	29.825	29.98	29.81	29.928	4859847.0
2012-09-28 14:00:00	MSFT	Stock	29.93	29.98	29.79	29.855	5848221.0
2012-09-28 15:00:00	MSFT	Stock	29.85	29.88	29.74	29.75	10056944.0
2012-09-28 16:00:00	MSFT	Stock	29.755	30.15	29.75	29.76	5972071.0
2012-09-28 17:00:00	MSFT	Stock	29.77	29.77	29.76	29.77	6841.0
2012-09-28 18:00:00	MSFT	Stock	29.83	29.83	29.76	29.79	3863.0
2012-09-28 19:00:00	MSFT	Stock	29.79	29.79	29.78	29.78	2297.0
2012-09-28 08:00:00	NVDA	Stock	0.3315	0.3315	0.3313	0.3313	132000.0
2012-09-28 09:00:00	NVDA	Stock	0.3305	0.3305	0.3261	0.3298	80458760.0
2012-09-28 10:00:00	NVDA	Stock	0.3295	0.336	0.3295	0.336	133007000.0
2012-09-28 11:00:00	NVDA	Stock	0.3358	0.3375	0.3349	0.336	69714240.0
2012-09-28 12:00:00	NVDA	Stock	0.336	0.3382	0.3358	0.3378	45719440.0
2012-09-28 13:00:00	NVDA	Stock	0.3375	0.3378	0.3358	0.337	28735880.0
2012-09-28 14:00:00	NVDA	Stock	0.3368	0.337	0.3344	0.3345	29297800.0
2012-09-28 15:00:00	NVDA	Stock	0.3345	0.3348	0.3322	0.3334	72269920.0
2012-09-28 16:00:00	NVDA	Stock	0.3335	0.334	0.3328	0.3335	3976080.0
2012-09-28 17:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	9920.0
2012-09-28 18:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	16000.0
2012-09-28 08:00:00	AMZN	Stock	12.788	12.8	12.7475	12.77	288960.0
2012-09-28 09:00:00	AMZN	Stock	12.775	12.85	12.75	12.7715	7675000.0
2012-09-28 10:00:00	AMZN	Stock	12.7705	12.8	12.66	12.7283	9021340.0
2012-09-28 11:00:00	AMZN	Stock	12.733	12.768	12.6805	12.714	5116420.0
2012-09-28 12:00:00	AMZN	Stock	12.715	12.7745	12.7095	12.7435	4014580.0
2012-09-28 13:00:00	AMZN	Stock	12.7435	12.8005	12.737	12.7875	4154420.0
2012-09-28 14:00:00	AMZN	Stock	12.7875	12.7965	12.7295	12.761	4051700.0
2012-09-28 15:00:00	AMZN	Stock	12.7585	12.779	12.716	12.716	6463100.0
2012-09-28 16:00:00	AMZN	Stock	12.716	12.7494	12.7125	12.726	1513740.0
2012-09-28 17:00:00	AMZN	Stock	12.725	12.725	12.7125	12.7125	22000.0
2012-09-28 19:00:00	AMZN	Stock	12.7215	12.724	12.7215	12.724	4000.0

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

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