PREVIEW / stock_1hour / 2013-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-14.parquet
  size:    966 KB
  rows:    44,812
  symbols: 3,465

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-14 05:00:00	AAPL	Stock	16.6518	16.6607	16.6304	16.6429	47600.0
2013-02-14 06:00:00	AAPL	Stock	16.6071	16.625	16.5982	16.5982	146888.0
2013-02-14 07:00:00	AAPL	Stock	16.5982	16.6375	16.5946	16.635	196364.0
2013-02-14 08:00:00	AAPL	Stock	16.6293	16.6789	16.5982	16.6175	876708.0
2013-02-14 09:00:00	AAPL	Stock	16.6225	16.7421	16.5721	16.6164	80721480.0
2013-02-14 10:00:00	AAPL	Stock	16.6232	16.7686	16.6093	16.7186	52376184.0
2013-02-14 11:00:00	AAPL	Stock	16.7205	16.7607	16.6893	16.7082	28573384.0
2013-02-14 12:00:00	AAPL	Stock	16.7079	16.8443	16.7021	16.8364	43939924.0
2013-02-14 13:00:00	AAPL	Stock	16.8361	16.8436	16.7186	16.7436	31422384.0
2013-02-14 14:00:00	AAPL	Stock	16.7411	16.7696	16.6365	16.6493	40979372.0
2013-02-14 15:00:00	AAPL	Stock	16.6532	16.7018	16.635	16.6643	51754388.0
2013-02-14 16:00:00	AAPL	Stock	16.6639	16.7395	16.589	16.6707	16695756.0
2013-02-14 17:00:00	AAPL	Stock	16.6736	16.6946	16.6629	16.6946	275492.0
2013-02-14 18:00:00	AAPL	Stock	16.6796	16.6854	16.6714	16.6854	138768.0
2013-02-14 19:00:00	AAPL	Stock	16.68	16.6929	16.6786	16.6893	130620.0
2013-02-14 07:00:00	MSFT	Stock	27.94	27.94	27.94	27.94	200.0
2013-02-14 08:00:00	MSFT	Stock	27.94	28.1	27.91	27.94	18812.0
2013-02-14 09:00:00	MSFT	Stock	27.94	28.03	27.87	27.94	9308908.0
2013-02-14 10:00:00	MSFT	Stock	27.94	28.055	27.92	28.036	3808492.0
2013-02-14 11:00:00	MSFT	Stock	28.035	28.06	27.95	27.984	3184755.0
2013-02-14 12:00:00	MSFT	Stock	27.985	28.01	27.95	27.98	2922410.0
2013-02-14 13:00:00	MSFT	Stock	27.98	28.03	27.96	27.975	2783380.0
2013-02-14 14:00:00	MSFT	Stock	27.98	28.03	27.96	27.991	2536821.0
2013-02-14 15:00:00	MSFT	Stock	27.995	28.05	27.95	28.031	6095534.0
2013-02-14 16:00:00	MSFT	Stock	28.04	28.045	27.986	28.03	1524220.0
2013-02-14 17:00:00	MSFT	Stock	28.03	28.04	27.99	28.0	35008.0
2013-02-14 19:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	280.0
2013-02-14 04:00:00	NVDA	Stock	0.3	0.304	0.3	0.3035	200000.0
2013-02-14 05:00:00	NVDA	Stock	0.3035	0.3035	0.3022	0.3022	460240.0
2013-02-14 06:00:00	NVDA	Stock	0.302	0.302	0.3012	0.3012	256800.0
2013-02-14 07:00:00	NVDA	Stock	0.3042	0.306	0.3025	0.305	1390760.0
2013-02-14 08:00:00	NVDA	Stock	0.3048	0.3048	0.3005	0.303	5866560.0
2013-02-14 09:00:00	NVDA	Stock	0.303	0.3113	0.3012	0.3105	189425400.0
2013-02-14 10:00:00	NVDA	Stock	0.3108	0.311	0.3071	0.308	111011520.0
2013-02-14 11:00:00	NVDA	Stock	0.3083	0.3108	0.3078	0.3085	78371560.0
2013-02-14 12:00:00	NVDA	Stock	0.3085	0.314	0.3085	0.3133	81345640.0
2013-02-14 13:00:00	NVDA	Stock	0.3133	0.3148	0.312	0.3145	69016880.0
2013-02-14 14:00:00	NVDA	Stock	0.3146	0.3165	0.3138	0.3161	102816640.0
2013-02-14 15:00:00	NVDA	Stock	0.3163	0.3185	0.316	0.3185	212451440.0
2013-02-14 16:00:00	NVDA	Stock	0.3183	0.3188	0.312	0.3183	18212280.0
2013-02-14 17:00:00	NVDA	Stock	0.317	0.3183	0.316	0.316	577680.0
2013-02-14 18:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	40000.0
2013-02-14 19:00:00	NVDA	Stock	0.3165	0.3175	0.3165	0.3175	40000.0
2013-02-14 05:00:00	AMZN	Stock	13.443	13.443	13.443	13.443	2000.0
2013-02-14 06:00:00	AMZN	Stock	13.4395	13.4395	13.3375	13.3375	10000.0
2013-02-14 07:00:00	AMZN	Stock	13.3375	13.36	13.3125	13.34	37800.0
2013-02-14 08:00:00	AMZN	Stock	13.347	13.425	13.3285	13.392	146400.0
2013-02-14 09:00:00	AMZN	Stock	13.3985	13.4735	13.31	13.3295	15311860.0
2013-02-14 10:00:00	AMZN	Stock	13.325	13.4465	13.27	13.396	11836540.0
2013-02-14 11:00:00	AMZN	Stock	13.4005	13.45	13.3562	13.43	8232300.0

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

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