PREVIEW / stock_1hour / 2013-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-20.parquet
  size:    992 KB
  rows:    46,014
  symbols: 3,497

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-20 04:00:00	AAPL	Stock	16.4286	16.4464	16.4286	16.4464	39200.0
2013-02-20 06:00:00	AAPL	Stock	16.4107	16.4107	16.2314	16.2454	625464.0
2013-02-20 07:00:00	AAPL	Stock	16.2329	16.3343	16.1161	16.2793	6265364.0
2013-02-20 08:00:00	AAPL	Stock	16.2682	16.4214	16.1786	16.2757	4003272.0
2013-02-20 09:00:00	AAPL	Stock	16.2693	16.4104	16.1329	16.1406	79796108.0
2013-02-20 10:00:00	AAPL	Stock	16.1438	16.2203	16.0996	16.125	86197888.0
2013-02-20 11:00:00	AAPL	Stock	16.1225	16.1786	16.0618	16.1239	85774584.0
2013-02-20 12:00:00	AAPL	Stock	16.1246	16.1561	16.0904	16.1311	32297776.0
2013-02-20 13:00:00	AAPL	Stock	16.1349	16.1557	16.1146	16.1302	23679236.0
2013-02-20 14:00:00	AAPL	Stock	16.1304	16.2029	16.1029	16.1071	48644764.0
2013-02-20 15:00:00	AAPL	Stock	16.1071	16.1079	16.0286	16.0329	77537432.0
2013-02-20 16:00:00	AAPL	Stock	16.0382	16.1381	16.0179	16.0186	9981944.0
2013-02-20 17:00:00	AAPL	Stock	16.0189	16.1603	16.0071	16.0071	864276.0
2013-02-20 18:00:00	AAPL	Stock	16.0075	16.0179	16.0	16.0179	432768.0
2013-02-20 19:00:00	AAPL	Stock	16.0171	16.0246	16.0004	16.0004	301308.0
2013-02-20 07:00:00	MSFT	Stock	28.03	28.1	28.03	28.1	900.0
2013-02-20 08:00:00	MSFT	Stock	28.03	28.11	28.01	28.1	12046.0
2013-02-20 09:00:00	MSFT	Stock	28.1	28.2	27.96	28.02	5009826.0
2013-02-20 10:00:00	MSFT	Stock	28.025	28.1	27.98	27.997	4857309.0
2013-02-20 11:00:00	MSFT	Stock	27.995	28.01	27.83	27.94	8620738.0
2013-02-20 12:00:00	MSFT	Stock	27.95	28.0	27.92	27.966	3002964.0
2013-02-20 13:00:00	MSFT	Stock	27.96	27.965	27.9	27.92	3641612.0
2013-02-20 14:00:00	MSFT	Stock	27.92	27.97	27.85	27.89	5625654.0
2013-02-20 15:00:00	MSFT	Stock	27.89	27.91	27.84	27.86	10253854.0
2013-02-20 16:00:00	MSFT	Stock	27.88	27.95	27.8	27.88	2390344.0
2013-02-20 17:00:00	MSFT	Stock	27.88	28.054	27.84	27.84	45485.0
2013-02-20 18:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	1079.0
2013-02-20 19:00:00	MSFT	Stock	27.86	27.88	27.86	27.88	1955.0
2013-02-20 07:00:00	NVDA	Stock	0.3105	0.314	0.3105	0.314	56000.0
2013-02-20 08:00:00	NVDA	Stock	0.3145	0.315	0.3145	0.3145	32000.0
2013-02-20 09:00:00	NVDA	Stock	0.3148	0.3188	0.3143	0.316	79304520.0
2013-02-20 10:00:00	NVDA	Stock	0.316	0.32	0.3153	0.3184	127689040.0
2013-02-20 11:00:00	NVDA	Stock	0.3185	0.3185	0.3158	0.318	88089280.0
2013-02-20 12:00:00	NVDA	Stock	0.3179	0.318	0.316	0.316	45158040.0
2013-02-20 13:00:00	NVDA	Stock	0.316	0.3163	0.314	0.314	46139120.0
2013-02-20 14:00:00	NVDA	Stock	0.3143	0.315	0.3118	0.3118	79393800.0
2013-02-20 15:00:00	NVDA	Stock	0.3119	0.3119	0.3085	0.3095	161366600.0
2013-02-20 16:00:00	NVDA	Stock	0.3093	0.317	0.3086	0.3098	66620800.0
2013-02-20 17:00:00	NVDA	Stock	0.3095	0.3095	0.3088	0.309	220600.0
2013-02-20 18:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	10000.0
2013-02-20 19:00:00	NVDA	Stock	0.31	0.31	0.309	0.309	40000.0
2013-02-20 05:00:00	AMZN	Stock	13.525	13.525	13.52	13.52	11760.0
2013-02-20 06:00:00	AMZN	Stock	13.526	13.526	13.526	13.526	2000.0
2013-02-20 07:00:00	AMZN	Stock	13.486	13.4875	13.4505	13.4535	29200.0
2013-02-20 08:00:00	AMZN	Stock	13.4875	13.4875	13.44	13.465	215040.0
2013-02-20 09:00:00	AMZN	Stock	13.465	13.688	13.465	13.6185	15395240.0
2013-02-20 10:00:00	AMZN	Stock	13.617	13.715	13.6145	13.6195	14836460.0
2013-02-20 11:00:00	AMZN	Stock	13.619	13.6262	13.434	13.4878	11384200.0
2013-02-20 12:00:00	AMZN	Stock	13.4858	13.5885	13.4695	13.5585	5407760.0
2013-02-20 13:00:00	AMZN	Stock	13.5616	13.5616	13.485	13.4965	3518360.0

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

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