PREVIEW / stock_1hour / 2013-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-27.parquet
  size:    966 KB
  rows:    45,220
  symbols: 3,487

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
2013-02-27 05:00:00	AAPL	Stock	15.9768	15.9768	15.9768	15.9768	8400.0
2013-02-27 06:00:00	AAPL	Stock	15.9886	16.0	15.9886	16.0	60760.0
2013-02-27 07:00:00	AAPL	Stock	15.9821	16.0232	15.9657	15.975	602868.0
2013-02-27 08:00:00	AAPL	Stock	15.9929	16.0179	15.9546	15.9711	1285032.0
2013-02-27 09:00:00	AAPL	Stock	15.9668	16.0393	15.8518	15.9043	57347920.0
2013-02-27 10:00:00	AAPL	Stock	15.9075	15.9996	15.8414	15.9375	57729476.0
2013-02-27 11:00:00	AAPL	Stock	15.9386	16.0832	15.9364	15.9695	55476652.0
2013-02-27 12:00:00	AAPL	Stock	15.9629	16.1586	15.8054	15.9304	138868072.0
2013-02-27 13:00:00	AAPL	Stock	15.9304	15.9868	15.7375	15.8536	97911912.0
2013-02-27 14:00:00	AAPL	Stock	15.8536	16.1179	15.825	16.095	79229556.0
2013-02-27 15:00:00	AAPL	Stock	16.0958	16.0964	15.8682	15.8775	80871784.0
2013-02-27 16:00:00	AAPL	Stock	15.8774	15.9929	15.8418	15.8671	12858720.0
2013-02-27 17:00:00	AAPL	Stock	15.8661	15.8804	15.8493	15.8493	808836.0
2013-02-27 18:00:00	AAPL	Stock	15.85	15.8543	15.8311	15.8543	422856.0
2013-02-27 19:00:00	AAPL	Stock	15.8554	15.8571	15.8464	15.85	226128.0
2013-02-27 07:00:00	MSFT	Stock	27.41	27.41	27.41	27.41	3000.0
2013-02-27 08:00:00	MSFT	Stock	27.32	27.41	27.32	27.39	7700.0
2013-02-27 09:00:00	MSFT	Stock	27.35	27.49	27.33	27.45	3043194.0
2013-02-27 10:00:00	MSFT	Stock	27.45	27.669	27.44	27.62	5502174.0
2013-02-27 11:00:00	MSFT	Stock	27.615	27.89	27.61	27.875	6195590.0
2013-02-27 12:00:00	MSFT	Stock	27.88	27.94	27.82	27.865	3808571.0
2013-02-27 13:00:00	MSFT	Stock	27.86	27.87	27.81	27.845	2364067.0
2013-02-27 14:00:00	MSFT	Stock	27.85	27.98	27.83	27.98	3718355.0
2013-02-27 15:00:00	MSFT	Stock	27.98	28.0	27.8	27.8	8671145.0
2013-02-27 16:00:00	MSFT	Stock	27.81	27.97	27.765	27.85	1714906.0
2013-02-27 17:00:00	MSFT	Stock	27.84	27.84	27.81	27.81	27709.0
2013-02-27 18:00:00	MSFT	Stock	27.82	27.85	27.82	27.85	3800.0
2013-02-27 19:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	900.0
2013-02-27 08:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	20000.0
2013-02-27 09:00:00	NVDA	Stock	0.3093	0.3133	0.3085	0.3128	39501760.0
2013-02-27 10:00:00	NVDA	Stock	0.3128	0.3133	0.3115	0.3129	53315200.0
2013-02-27 11:00:00	NVDA	Stock	0.3128	0.315	0.3128	0.3145	52089640.0
2013-02-27 12:00:00	NVDA	Stock	0.3143	0.315	0.3133	0.3143	48227480.0
2013-02-27 13:00:00	NVDA	Stock	0.3145	0.3145	0.3133	0.3135	40053720.0
2013-02-27 14:00:00	NVDA	Stock	0.3135	0.3155	0.3133	0.3154	91004440.0
2013-02-27 15:00:00	NVDA	Stock	0.3153	0.3173	0.3148	0.315	143886000.0
2013-02-27 16:00:00	NVDA	Stock	0.315	0.3164	0.3143	0.3164	8422160.0
2013-02-27 17:00:00	NVDA	Stock	0.3089	0.315	0.3089	0.315	431560.0
2013-02-27 04:00:00	AMZN	Stock	12.9745	12.9745	12.9745	12.9745	2000.0
2013-02-27 07:00:00	AMZN	Stock	12.99	12.99	12.989	12.989	22000.0
2013-02-27 08:00:00	AMZN	Stock	12.9985	13.0175	12.9855	12.9855	67480.0
2013-02-27 09:00:00	AMZN	Stock	12.9875	12.9875	12.843	12.88	5386860.0
2013-02-27 10:00:00	AMZN	Stock	12.8885	13.2039	12.8845	13.092	15148800.0
2013-02-27 11:00:00	AMZN	Stock	13.0915	13.187	13.0835	13.151	7148220.0
2013-02-27 12:00:00	AMZN	Stock	13.1505	13.2465	13.1425	13.18	6824760.0
2013-02-27 13:00:00	AMZN	Stock	13.184	13.255	13.1705	13.2355	5047380.0
2013-02-27 14:00:00	AMZN	Stock	13.236	13.2915	13.2185	13.2832	4528300.0
2013-02-27 15:00:00	AMZN	Stock	13.286	13.2865	13.1575	13.1605	11861220.0
2013-02-27 16:00:00	AMZN	Stock	13.1675	13.2296	13.1325	13.163	206560.0
2013-02-27 17:00:00	AMZN	Stock	13.1675	13.1945	13.1625	13.1945	30120.0

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

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